[Ted S]

Originally Posted by Megatr0n

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT id,views
FROM vb_lgv AS lgv
WHERE lgv.ipaddress = '81.97.205.196';

MySQL Error : Table 'smiggy_gupshupp.vb_lgv' doesn't exist
Error Number : 1146
Request Date : Tuesday, December 9th 2008 @ 09:49:08 AM
Error Date : Tuesday, December 9th 2008 @ 09:49:08 AM
Script : http://www.gupshupp.com/forums/showt...ost&t=8589
Referrer : http://www.gupshupp.com/forums/
IP Address : 81.97.205.196
Username : Unregistered
Classname : vB_Database
MySQL Version :

The installer was unable to create a table for storing records. Please create one manually via phpmyadmin, mysql shell or similar.

CREATE TABLE vb.lgv (
        id smallint(5) unsigned NOT NULL auto_increment,
        ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',
       firstaccess INT UNSIGNED NOT NULL DEFAULT '0',
       views INT(4) NOT NULL DEFAULT '0',
       lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
        PRIMARY KEY (id),
        KEY indexs (ipaddress,views,lastactivity)
      ) TYPE=MyISAM