[mtha]

dah, the addon was for my board, which has mucho hacks already. I fixed the modlog.php above, you can redownload it now.

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: ALTER TABLE `modlog` ADD `postid` int(10) DEFAULT '0' NOT NULL AFTER `threadid`;
mysql error: Duplicate column name 'postid'

mysql error number: 1060

You already have the column 'postid' created somehow. Check the table modlog in your database, to make sure that you have it right. If so (and if your database isnt corupted), you dont have to do anything else. otherwise, just delete that column, and add it again.

Database error in vBulletin Control Panel 2.3.0:

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

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

mysql error number: 1054

dah, I have something called realname, instead of username, that's why.

please search for realname and change it to username, this problem should be fixed.


line 71 in modlog.php :

$logs=$DB_site->query("SELECT type,modlog.userid as userid,modlog.threadid as threadid,modlog.postid as postid,fromforumid,toforumid,modlog.timestamp as timestamp,modlog.ipaddress as ipaddress,threadtitle, user.username as username