Everytime I try to upgrade from 1.1.3 to Beta 3 I got this error:
I have already deleted ignore field from user table, but I still got this error.
any idea whats wrong?
Code:
<p>Altering user table</p> <!-- ALTER TABLE user DROP biography, DROP canpost, CHANGE timezoneoffset timezoneoffset CHAR(4) NOT NULL --> <p>Altering User Table</p> <!-- ALTER TABLE user ADD buddylist MEDIUMTEXT NOT NULL --> <p>Altering User Table</p> <!-- ALTER TABLE user --> <!-- Database error in vBulletin Upgrade: Invalid SQL: ALTER TABLE user mysql error: You have an error in your SQL syntax near '' at line 2 mysql error number: 1064 Date: Friday 09th of March 2001 07:51:39 PM Script: /vb2_beta3/admin/upgrade1.php?step=8 Referer: [url]http://www.montada.com/vb2_beta3/admin/upgrade1.php?step=7[/url] --> </td></tr></table> <p>There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>
any idea whats wrong?