|
Member
Join Date: Apr 2006
Location: UK
Posts: 56
Rep Power: 17
|
3.0.xx upgrading to 3.1... is this normal?
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
|
05-22-2006, 08:17 AM
Similar Threads
Linear Mode
