Well as i said in the first post.. I have deleted all my hacks. All files are in tact.
The screen shot says I executed both queries.
Regardless I did a quick fresh install on a db. Droped the last activity table from my live database. Imported the tabel from my fresh install.
Now I have a new database error:
Database error in vBulletin 3.6.5:
PHP Code:
Invalid SQL:
SELECT * FROM guest FORCE INDEX (lastactive) WHERE lastactive > 1173430515;
MySQL Error : Table 'config_vb.guest' doesn't exist
Error Number : 1146
Date : Saturday, March 10th 2007 @ 08:55:15 AM
Script : /index.php
Referrer : /online.php
IP Address :
Username :
Classname : vb_database
The weird thing is guest is not a default table in the database. :S
Ok checked an old database back up an imported a guest table from it. Now I am back to the first error.
SQL query: DESCRIBE user;
PHP Code:
Field Type Null Key Default Extra
userid int(10) unsigned PRI NULL auto_increment
usergroupid smallint(5) unsigned MUL 0
membergroupids varchar(250)
displaygroupid smallint(5) unsigned 0
username varchar(100) MUL
password varchar(32)
passworddate date 0000-00-00
email varchar(100)
styleid smallint(5) unsigned 0
parentemail varchar(50)
homepage varchar(100)
icq varchar(20)
aim varchar(20)
yahoo varchar(32)
msn varchar(100)
skype varchar(32)
showvbcode smallint(5) unsigned 0
showbirthday smallint(5) unsigned 2
usertitle varchar(250)
customtitle smallint(6) 0
joindate int(10) unsigned 0
daysprune smallint(6) 0
lastvisit int(10) unsigned 0
lastpost int(10) unsigned MUL 0
lastpostid int(10) unsigned 0
posts int(10) unsigned 0
reputation int(11) 10
reputationlevelid int(10) unsigned 1
timezoneoffset varchar(4)
pmpopup smallint(6) 0
avatarid smallint(6) 0
avatarrevision int(10) unsigned 0
profilepicrevision int(10) unsigned 0
sigpicrevision int(10) unsigned 0
options int(10) unsigned 15
birthday varchar(10) MUL
birthday_search date MUL 0000-00-00
maxposts smallint(6) -1
startofweek smallint(6) 1
ipaddress varchar(15)
referrerid int(10) unsigned 0
languageid smallint(5) unsigned 0
emailstamp int(10) unsigned 0
threadedmode smallint(5) unsigned 0
autosubscribe smallint(6) -1
pmtotal smallint(5) unsigned 0
pmunread smallint(5) unsigned 0
salt char(3)
ipoints int(10) unsigned 0
infractions int(10) unsigned 0
warnings int(10) unsigned 0
infractiongroupids varchar(255)
infractiongroupid smallint(5) unsigned 0
adminoptions int(10) unsigned 0
vbp_vbplazaoptions int(10) unsigned 0
http://img237.imageshack.us/img237/46/tablevv9.gif
Here si the results of the two seperate queries.
03-10-2007, 07:02 AM
Hybrid Mode
