When I run the alter-table I get
Altering the Posts table to store the parent user id to restore the in reply to userrname.
SQL ERROR: Unable to do_query: ALTER TABLE w3t_Posts ADD B_ParentUser INT(9) UNSIGNED, ADD B_LastPosterId INT(9) UNSIGNED, ADD B_LastPostNum INT(11) UNSIGNED
Duplicate column name 'B_ParentUser'Altering the Users table to add a field for banned users.
SQL ERROR: Unable to do_query: ALTER TABLE w3t_Users ADD U_Banned INT(1) UNSIGNED DEFAULT '0'
Duplicate column name 'U_Banned'Adding a table to store languages users can choose from...
SQL ERROR: Unable to do_query: CREATE TABLE w3t_Languages ( L_Entry INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY, L_Language VARCHAR(255), L_Description VARCHAR(255), L_Active INT(1) )
Table 'w3t_Languages' already existsSQL ERROR: Unable to do_query: CREATE TABLE w3t_Mailer ( M_Time INT(11), M_Subject VARCHAR(255), M_Message TEXT, M_Groups VARCHAR(255), M_Bogus VARCHAR(255), M_Onebyone INT(1), M_Loop INT(9), M_Type VARCHAR(10) )
Table 'w3t_Mailer' already existsDone
---
I did run the requested SQL for the mass mailer before updating.
The forum is working and it shows to have updated to 6.3B4.
But the one feature that I wanted is not working as banned users can still browse the forum?
Darn those banned IP users. They shall have none of our bandwith. []
http://forums.operationsports.com/ubbthreads/images/graemlins/freddy.gif[/]
Any help is greatly appreciated as I am SQL illiterate.