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  : Tuesday, April 29th 2008 @ 09:51:47 PM
Error Date    : Tuesday, April 29th 2008 @ 09:51:47 PM
Script        : http://www.xxx.org/install/upgrade_370b3.php?step=2
Referrer      : http://www.xxx.org/install/upgrade_370b3.php?step=2
IP Address    : 78.176.228.79
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.45-community

ALTER TABLE `album` ADD `picturecount` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `lastpicturedate` ;

Database error in vBulletin 3.7.0 Beta 3:

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

MySQL Error   : Unbekanntes Tabellenfeld 'public' in where clause
Error Number  : 1054
Date          : Friday, March 21st 2008 @ 12:15:13 PM
Script        : http://www.xxx.com/install/upgrade_370b4.php?step=1
Referrer      : http://www.xxx.com/install/upgrade_370b4.php
IP Address    : xxx.xxx.xxx.xxx
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.51a-0.dotdeb.1

    $upgrade->run_query(
        sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'album', 2, 3),
        "UPDATE " . TABLE_PREFIX . "album SET state = 'private' WHERE public = 0"
    );

//    $upgrade->run_query(
//        sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'album', 2, 3),
//        "UPDATE " . TABLE_PREFIX . "album SET state = 'private' WHERE public = 0"
//    );

Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:
ALTER TABLE album CHANGE picturecount visible INT UNSIGNED NOT NULL DEFAULT '0';

MySQL Error   : Doppelter Spaltenname: 'visible'
Error Number  : 1060
Date          : Friday, March 21st 2008 @ 12:24:18 PM
Script        : http://www.xxx.com/install/upgrade_370b6.php?step=1
Referrer      : http://www.xxx.com/install/upgrade_370b6.php
IP Address    : xxx.xxx.xxx.xxx
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.51a-0.dotdeb.1

        $upgrade->run_query(
            sprintf($upgradecore_phrases['altering_x_table'], 'album', 2, 2),
            "ALTER TABLE " . TABLE_PREFIX . "album CHANGE picturecount visible INT UNSIGNED NOT NULL DEFAULT '0'"
        );

//        $upgrade->run_query(
//            sprintf($upgradecore_phrases['altering_x_table'], 'album', 2, 2),
//            "ALTER TABLE " . TABLE_PREFIX . "album CHANGE picturecount visible INT UNSIGNED NOT NULL DEFAULT '0'"
//        );