Sql

[Hobbes]

[sql]
Database error in vBulletin Mod Control Panel 2.2.6:

Invalid SQL: INSERT INTO modlog (modlogid,userid,dateline,script,action,extrainfo, ipaddress) VALUES (NULL,'417',1051583741,'index.php','','','12.240.1 2.172')
mysql error: Unknown column 'modlogid' in 'field list'

mysql error number: 1054
[/sql]


and the query executed in the install does not add the modlogid field. how is it im the only one having this problem? or no one posted in the thread....and yeah....help???

[DigitalDesktops]

try deleting the modlog table, and run this query:

[sql]CREATE TABLE modlog (
modlogid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
userid int(10) unsigned DEFAULT '0' NOT NULL,
dateline int(10) unsigned DEFAULT '0' NOT NULL,
script char(20) NOT NULL,
action char(20) NOT NULL,
extrainfo char(200) NOT NULL,
ipaddress VARCHAR(15) NOT NULL,
PRIMARY KEY (modlogid)
);
[/sql]

[Hobbes]

dude, you rock...omg...yes....thank you...!

[Hobbes]

last thign im getting

[sql]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT type,modlog.userid as userid,modlog.threadid as threadid,fromforumid,toforumid,modlog.timestamp as timestamp,threadtitle,username
FROM modlog
LEFT JOIN user ON modlog.userid = user.userid

ORDER BY modlog.timestamp DESC
LIMIT 0,25
mysql error: Unknown column 'type' in 'field list'

mysql error number: 1054

[/sql]

digitaldesktops you rock,btw.

[Hobbes]

also, i think the 'type' field is missing...i could drop the query and rerun it, and add the ALTER table 'modlog' ADD field 'type'..or something.... help ????

[Hobbes]

ok w00t...done..and done..... thanks digitaldesktops j00 rock!!!