PDA

View Full Version : How/where exactly do I go to fix SQL database error?


PurpleButterfly
01-06-2008, 04:41 AM
Sorry, I am such a newbie in this area. I have no idea how or where to access my SQL so I can try and fix this error:

Database error in vBulletin 3.6.8:
Invalid SQL:
ALTER TABLE `usergroup`
ADD icashpermissions INT( 10 ) UNSIGNED NOT NULL DEFAULT '7';
MySQL Error : Duplicate column name 'icashpermissions'
Error Number : 1060


I have posted in that hack thread and PM'd the coder of that product but recognize that people don't live online to help a hundred needy vB'ers :o, and would be very grateful for anyone who has the time or inclination to offer any suggestions. :)

Marco van Herwaarden
01-06-2008, 08:02 AM
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.