[sv1cec]

Originally Posted by mcyates

I keep getting this error:

Invalid SQL: 
            INSERT INTO userban
            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
            VALUES
            (1033, 8, 0, 0, 'Ball boy', 1, 1103129995, 1103734795, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'

mysql error number: 1054

It obviouslyt because i haven't got the column reason added. What is the SQL query to add this? The warning points are still given to the user when you select which warning but this error comes up when you submit it.

ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext

Sorry about that, that's what happens when one doesn't keep notes of all the changes.