No announcement yet.

Help! Error when trying to upgrade

  • Filter
  • Time
  • Show
Clear All
new posts

  • Help! Error when trying to upgrade

    Everytime I try to upgrade from 1.1.3 to Beta 3 I got this error:
    <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][/url]
    <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>
    I have already deleted ignore field from user table, but I still got this error.

    any idea whats wrong?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.