Announcement

Collapse
No announcement yet.

Error running upgrade

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

  • Error running upgrade

    mySQL version: MySQL 4.0.20
    php version: phpMyAdmin 2.5.1

    please help. thank you.

    Error running upgrade Step 21/42

    Database error in vBulletin :
    Invalid SQL: ALTER TABLE usergroup
    CHANGE title title CHAR(100) NOT NULL,
    CHANGE usertitle usertitle CHAR(100) NOT NULL,
    CHANGE maxbuddypm pmsendmax SMALLINT UNSIGNED DEFAULT 5 NOT NULL,
    CHANGE showgroup genericoptions INT UNSIGNED NOT NULL

    mysql error: Unknown column 'maxbuddypm' in 'usergroup'

    mysql error number: 1054

    Date: Wednesday 16th of June 2004 03:30:06 AM
    Script: http://www.precisionmuscle.org/forum...l/upgrade1.php
    Referer: http://www.precisionmuscle.org/forum...e1.php?step=21

  • #2
    ok i figured out my problem in the above errors.

    but now i am getting this error in:

    Step 2) Adding and deleting data (Step 2 of 8)

    Database error in vBulletin 3.0.0 Beta 3:
    Invalid SQL: INSERT INTO datastore (title, data) VALUES ('wol_spiders', 'a:4:{s:10:\"spiderdesc\";s:64:\"Google
    Lycos
    Ask Jeeves
    Altavista
    AlltheWeb
    Inktomi
    Turnitin.com\";s:13:\"spiderstrings\";s:76:\"googlebot
    lycos
    ask jeeves
    scooter
    fast-webcrawler
    [email protected]
    turnitinbot\";s:12:\"spiderstring\";s:76:\"googlebot|lycos|ask jeeves|scooter|fast-webcrawler|[email protected]|turnitinbot\";s:11:\"spiderarray\";a:7:{s:9:\&quot ;googlebot\";s:6:\"Google\";s:5:\"lycos\";s:5:\"Lycos\" ;s:10:\"ask jeeves\";s:10:\"Ask Jeeves\";s:7:\"scooter\";s:9:\"Altavista\";s:15:\"fast-webcrawler\";s:9:\"AllTheWeb\";s:13:\"[email protected]\";s:7:\" Inktomi\";s:11:\"turnitinbot\";s:12:\"Turnitin.com\";}}')
    mysql error: Duplicate entry 'wol_spiders' for key 1
    mysql error number: 1062

    Comment


    • #3
      ok figured that one out too

      Comment

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