Quote:
Originally Posted by Breath
Ok heres's a fix for it.
Open the xml file and change
Code:
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')");
to
Code:
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL)");
This does the trick on mysql5
|
Just a warning that I got a datbase error when I did this and now I get one when i try to add any product.
Here is the error:
Quote:
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-End Error Mess = 'a:4:{s:17:\"custom_link_added\";s:44:\"The custom link has su' at line 1
Error Number : 1064
|