MyBB Community Forums

i had to restart the installer because my internet got messed up....now i restarted the installer and i get this....

Quote:Performing QueriesPerforming necessary upgrade queries..

MySQL error: 1060
Duplicate column name 'totalpms'
Query: ALTER TABLE mybb_users ADD totalpms int(10) NOT NULL default '0' AFTER showcodebuttons;

the question is do i need to drop/delete the totalpms column

You'd have to use phpMyAdmin. Navigate to the mybb_users structure page and select the totalpms column and drop it.

now i dropped it but i keep on getting more errors of more columns....how can i delete all the columns that the first step in the installation installed in my database?

anyone?

Please see your other upgrade thread first (where I provided instructions on skipping forward to the next step of the upgrade process)

Alternatively someone else has posted the MySQL queries to drop the newly created columns so you can restart the upgrade: http://community.mybboard.net/showthread.php?tid=11820