3.0.xx upgrading to 3.1... is this normal?

[Mikael]

Hi there,

I have finally got around to upgrading our site from 3.0.15 (Developer) to 3.1 (Developer) and have come across a problem. I have searched the forums and not found anything similar so I am posting.

The files were all uploaded and I ran the www.mydomain.com/install, clicked continue and received the following errors...

No database selected - ALTER TABLE `class_memberships` CHANGE `mFeatured` `mFeatured` INT( 11 ) NOT NULL , CHANGE `mBold` `mBold` INT( 11 ) NOT NULL , CHANGE `mHighlighted` `mHighlighted` INT( 11 ) NOT NULL
Checking for file upload...
Adding file upload...
No database selected - ALTER TABLE `class_memberships` CHANGE `mFeatured` `mFeatured` INT( 11 ) NOT NULL , CHANGE `mBold` `mBold` INT( 11 ) NOT NULL , CHANGE `mHighlighted` `mHighlighted` INT( 11 ) NOT NULL
Checking for category link...
Changing category weight...
No database selected - SELECT id,cOrder FROM class_categories ORDER BY cOrder DESC
Adding category link...
No database selected - SELECT id,cOrder FROM class_categories ORDER BY cOrder DESC
Checking for 3.1...
No database selected - ALTER TABLE `class_products` CHANGE `price` `price` DOUBLE DEFAULT '0' NOT NULL
No database selected - ALTER TABLE `class_currency_settings` CHANGE `cCurrencySymbol` `cCurrencySymbol` VARCHAR( 50 ) DEFAULT '$' NOT NULL
Altering admin table...
No database selected - ALTER TABLE `class_admin` ADD `smtp` char(1) NOT NULL default 'N', ADD `smtpHost` VARCHAR( 255 ) NULL, ADD `smtpUsername` varchar(255) NULL, ADD `smtpPassword` varchar(255) NULL, ADD `smtpPort` varchar(255) NULL, ADD `htmlEditor` CHAR( 1 ) DEFAULT 'Y' NOT NULL;
Altering categories table...
No database selected - ALTER TABLE `class_categories` ADD `cKeywords` VARCHAR( 255 ) NOT NULL , ADD `cPromo` TEXT NOT NULL ;
Adding memberships table...
No database selected - CREATE TABLE `class_memberships` ( `mID` int(11) NOT NULL auto_increment, `mTitle` varchar(255) NOT NULL default '', `mDescription` text NOT NULL, `mPrice` double NOT NULL default '0', `mNumber` int(11) NOT NULL default '1', `mUserGroup` int(11) NOT NULL default '0', `mExpirationDays` int(11) NOT NULL default '0', `mExpireAds` char(1) NOT NULL default 'N', `mCats` varchar(255) NOT NULL default '', `mFeatured` INT(11) NOT NULL default '0', `mBold` INT(11) NOT NULL default '0', `mHighlighted` INT(11) NOT NULL default '0', PRIMARY KEY (`mID`) )
No database selected - CREATE TABLE `class_memberships_lookup` ( `mID` int(11) NOT NULL default '0', `packageID` int(11) NOT NULL default '0', UNIQUE KEY `mID` (`mID`,`packageID`) )
No database selected - CREATE TABLE `class_memberships_orders` ( `id` int(11) NOT NULL auto_increment, `userID` int(11) NOT NULL default '0', `packageID` int(11) NOT NULL default '0', `payProvider` int(11) NOT NULL default '0', `price` varchar(255) NOT NULL default '', `completed` char(1) NOT NULL default 'N', `oDate` datetime NOT NULL default '0000-00-00 00:00:00', `authNumber` varchar(255) NOT NULL default '', `numUsed` int(11) NOT NULL default '0', `fnumUsed` int(3) NOT NULL default '0', `bnumUsed` int(3) NOT NULL default '0', `hnumUsed` int(3) NOT NULL default '0', PRIMARY KEY (`id`) )
No database selected - CREATE TABLE `class_modules` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `displayname` varchar(255) NOT NULL default '', `description` varchar(255) NOT NULL default '', `directory` varchar(255) NOT NULL default '', `version` varchar(10) NOT NULL default '', `admin_capable` tinyint(1) NOT NULL default '0', `user_capable` tinyint(1) NOT NULL default '0', `state` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) )
No database selected - INSERT INTO `class_modules` VALUES (24, 'seller_store', 'Seller Store', 'Allows users to have their own store.', 'seller_store', 'V1.0', 1, 1, 1);
No database selected - INSERT INTO `class_modules` VALUES (28, 'ad_reporting', 'Ad Reporting', 'Allows users to quickly report an ad for questionable content.', 'ad_reporting', 'V1.0', 0, 1, 1);
No database selected - INSERT INTO `class_modules` VALUES (26, 'vbulletin', 'vBulletin', 'Integrates users with vbulletin.', 'integration_vbulletin', 'V1.0', 0, 1, 1);
No database selected - INSERT INTO `class_modules` VALUES (27, 'ad_notification', 'Ad Notification', 'Allows users to register and get email notification when a listing becomes available.', 'ad_notification', 'V1.0', 0, 1, 1);
No database selected - INSERT INTO `class_modules` VALUES (32, 'member_rating', 'Member Rating', 'Allows users to rate users.', 'member_rating', 'V1.0', 1, 1, 1);
Checking for fields...
Altering fields table...
No database selected - ALTER TABLE `class_fields` ADD `fRange` varchar(255) default NULL
No database selected - ALTER TABLE `class_fields` ADD `fRangeValue` varchar(255) default NULL
Checking for new user fields...
Altering users table...
No database selected - ALTER TABLE `class_users` ADD `cookie` varchar( 32 ) binary NOT NULL default ' ';
No database selected - ALTER TABLE `class_users` ADD `session` varchar( 32 ) binary NOT NULL default ' ';
Checking for showlistings template...
Altering search_settings table...
No database selected - ALTER TABLE `class_search_settings` ADD `sTemplate` tinyint( 1 ) NOT NULL default '1';
Checking for payment provider...
Adding WorldPay...
No database selected - INSERT INTO `class_payment` VALUES (10, "WorldPay", "Credit Card", "N", "N", NULL, NULL)
Checking for user_groups settings...
Altering user_groups table...
No database selected - ALTER TABLE `class_user_groups` ADD `uViewPhone` CHAR( 1 ) NOT NULL default 'N' ;
Checking for checkout settings...
Altering checkout_settings table...
No database selected - ALTER TABLE `class_checkout_settings` ADD `checkoutModifyStatus` CHAR( 1 ) NOT NULL default 'N' ;
Checking pages table...
Updating pages table...
No database selected - ALTER TABLE `class_pages` ADD `pPublish` CHAR( 1 ) NOT NULL , ADD `pNav` CHAR( 1 ) NOT NULL
Updating cartproducts table...
No database selected - ALTER TABLE `class_cartproducts` CHANGE `cBoldPrice` `cBoldPrice` DOUBLE NULL
No database selected - ALTER TABLE `class_cartproducts` CHANGE `cHighlightedPrice` `cHighlightedPrice` DOUBLE NULL
No database selected - ALTER TABLE `class_products_fields` CHANGE `sValue` `sValue` TEXT NOT NULL
Checking for email template...
Adding email template "New listing notification".
No database selected - INSERT INTO `class_email_templates` VALUES (6, 'New listing notification', 'New listing added', 'A new listing has been added to your classifieds website. ', 'A new listing has been added to your classifieds website. ');
No database selected -
Completed, but with errors !

I think the problem is I uploaded the full version rather than the upgrade version... D'Oh!

I do have a backup of the files and database, so rolling back should not be a problem. I just wanted to check if the above errors were due to my haste uploading and upgrading using the full version instead of the upgrade one.

I hope that makes sense to someone!

My apologies if this has been answered elsewhere.

Kind regards,

Mikael

[Eric Barnes]

Mikael,

You probably just overwrote your connections/classifieds.php file. So I would upload the one from the back then go through the upgrade steps again and all should be ok.

[Mikael]

Thanks for that, I replaced my connections/classifieds.php file and there appears to be one more error...

Table 'rcd2.class_memberships' doesn't exist - ALTER TABLE `class_memberships` CHANGE `mFeatured` `mFeatured` INT( 11 ) NOT NULL , CHANGE `mBold` `mBold` INT( 11 ) NOT NULL , CHANGE `mHighlighted` `mHighlighted` INT( 11 ) NOT NULL
Checking for file upload...
Adding file upload...
Checking for category link...
Changing category weight...
Adding category link...
Checking for 3.1...
Altering admin table...
Altering categories table...
Adding memberships table...
Checking for fields...
Altering fields table...
Checking for new user fields...
Checking for showlistings template...
Checking for payment provider...
Checking for user_groups settings...
Checking for checkout settings...
Checking pages table...
Updating cartproducts table...
Checking for email template...
Completed, but with errors !

Any thoughts?

Many thanks again,

Mikael

[Eric Barnes]

This is a misleading error message but everything should be in order now. Basically it tried to change a database field that didn't exist yet.

[Mikael]

Hi Eric,

Sorry I forgot to say thanks! Very rude of me. The site is fine now.

Thanks again,

Mikael