Announcement

Collapse
No announcement yet.

Mysql error during upgrade.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql error during upgrade.

    Database error in vBulletin 3.5.5:

    Invalid SQL:
    UPDATE tcusergroup
    SET genericpermissions = genericpermissions |
    WHERE adminpermissions & 2;

    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 'WHERE adminpermissions & 2' at line 3
    Error Number : 1064
    Date : Saturday, August 5th 2006 @ 12:32:36 AM
    Script : http://www.twoclusters.info/modules/...0b1.php?step=8
    Referrer : http://www.twoclusters.info/modules/...0b1.php?step=8
    IP Address : 65.95.97.152
    Username :
    Classname : vb_database
    server php version : 4.3.8
    sql version : 4.022

    Was trying to upgrade from 3.5.4

    Any idea what is the cause?

    Thanks.

  • #2
    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.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thanks.

      Seems I missed one or two files.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X