Trying to upgrade

  • by
  • on 01.07.09
  • creampiesca.com
  • edit
  • I keep trying to upgrade and all I get is

    Database error in vBulletin 3.7.0 Beta 2:

    Invalid SQL:
    ALTER TABLE album
    CHANGE userid userid INT UNSIGNED NOT NULL DEFAULT '0',
    CHANGE createdate createdate INT UNSIGNED NOT NULL DEFAULT '0',
    CHANGE lastpicturedate lastpicturedate INT UNSIGNED NOT NULL DEFAULT '0',
    CHANGE picturecount picturecount INT UNSIGNED NOT NULL DEFAULT '0',
    CHANGE title title VARCHAR(100) NOT NULL DEFAULT '',
    CHANGE description description TEXT,
    CHANGE coverpictureid coverpictureid INT UNSIGNED NOT NULL DEFAULT '0';

    MySQL Error : Unknown column 'picturecount' in 'album'
    Error Number : 1054
    Request Date : Saturday, May 24th 2008 @ 07:36:51 PM
    Error Date : Saturday, May 24th 2008 @ 07:36:51 PM
    Script : http://www.packing4life.com/install/upgrade_370b3.php?step=2
    Referrer : http://www.packing4life.com/install/upgrade_370b3.php?step=1
    IP Address : 76.121.234.123
    Username :
    Classname : vB_Database
    MySQL Version : 5.0.22

    Any ideas to get this done.


  • I am working on doing that today and upgrade.

    Dave


  • Try running this query to add the missing field:

    ALTER TABLE album ADD picturecount INT UNSIGNED NOT NULL DEFAULT '0'

    Then refresh that upgrade step.

    Jake thanks for your reply, I found out today the requirements for the PHP and MySql and the hosting company is just a little behind in updating.

    My Data Base PHP 5.1.6, MySQL Version 5.0.22

    vBulletin 3.7.0 requires at least PHP 4.3.3 and MySQL 4.0.16 (These are the same requirements as vBulletin 3.6), but we strongly recommend that all customers run PHP 5.2.5 with APC and MySQL 5.0.51 or later. Major performance benefits can be had by taking the recommended route rather than simply satisfying the required versions.

    Is it possible this is the problem ?


  • Yes tried it and now I get.

    Database error in vBulletin 3.7.0 Beta 3:

    Invalid SQL:
    UPDATE album SET state = 'private' WHERE public = 0;

    MySQL Error : Unknown column 'public' in 'where clause'
    Error Number : 1054
    Request Date : Monday, May 26th 2008 @ 02:10:56 PM
    Error Date : Monday, May 26th 2008 @ 02:10:56 PM
    Script : http://www.packing4life.com/install/upgrade_370b4.php?step=1
    Referrer : http://www.packing4life.com/install/upgrade_370b4.php
    IP Address : 76.121.234.123
    Username :
    Classname : vB_Database
    MySQL Version : 5.0.22


  • Try running this query to add the missing field:

    ALTER TABLE album ADD picturecount INT UNSIGNED NOT NULL DEFAULT '0'

    Then refresh that upgrade step.


  • Those versions are fine and have nothing to do with that error. Did you follow Jake's instructions?


  • I have referred your error and support ticket to the Devs.

    Thank you Steve


  • I have referred your error and support ticket to the Devs.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Trying to upgrade , Please add it free.