Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Upgrade from 2.2-MS2 to OM v2.2 RC2a


mr.andrey

Recommended Posts

Hello,

 

I'm running a 2.2-MS2 (looked in application_top.php) version of osCommerce, and I'm wanting to update to Online Merchant v2.2 RC2a.

 

Is there a list of database updates that need to be done to migrate it over to Online Merchant v2.2 RC2a?

 

I looked in the extras folder, and the list of DB updates doesn't seem to be complete. Table `administrators` seems to be the new requirement, and it's not mentioned there.

 

I looked on the forums, but couldn't find any answers.

 

Thanks,

Andrey.

Link to comment
Share on other sites

Is there a list of database updates that need to be done to migrate it over to Online Merchant v2.2 RC2a?

yes, you need add administrators table & compare the rest tables.

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

It seems odd that there doesn't seem to be a chronological list of DB changes...

 

In any case, I exported both the new and the old DB, and did a quick diff in Vim.

 

Here is the list of changes:

CREATE TABLE `administrators` (

`id` int(11) NOT NULL auto_increment,

`user_name` varchar(32) character set utf8 collate utf8_bin NOT NULL,

`user_password` varchar(40) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `administrators` VALUES ( !!! --- GET THIS VALUE FROM YOUR NEW DB --- !!!);

 

ALTER TABLE `banners`

ADD KEY `idx_banners_group` (`banners_group`)

 

ALTER TABLE `banners_history`

ADD KEY `idx_banners_history_banners_id` (`banners_id`)

 

ALTER TABLE `configuration`

MODIFY `configuration_title` varchar(255) NOT NULL,

MODIFY `configuration_key` varchar(255) NOT NULL

 

ALTER TABLE `currencies`

ADD KEY `idx_currencies_code` (`code`)

 

ALTER TABLE `customers`

ADD KEY `idx_customers_email_address` (`customers_email_address`)

 

ALTER TABLE `customers_basket`

MODIFY `final_price` decimal(15,4) default NULL,

MODIFY `customers_basket_date_added` char(8) default NULL,

ADD KEY `idx_customers_basket_customers_id` (`customers_id`)

 

ALTER TABLE `customers_basket_attributes`

ADD KEY `idx_customers_basket_att_customers_id` (`customers_id`)

 

ALTER TABLE `orders`

MODIFY `payment_method` varchar(255) NOT NULL,

ADD KEY `idx_orders_customers_id` (`customers_id`)

 

ALTER TABLE `orders_products`

ADD KEY `idx_orders_products_orders_id` (`orders_id`),

ADD KEY `idx_orders_products_products_id` (`products_id`)

 

ALTER TABLE `orders_products_attributes`

ADD KEY `idx_orders_products_att_orders_id` (`orders_id`)

 

ALTER TABLE `orders_products_download`

ADD KEY `idx_orders_products_download_orders_id` (`orders_id`)

 

ALTER TABLE `orders_status`

ADD `public_flag` int(11) default '1',

ADD `downloads_flag` int(11) default '0'

 

ALTER TABLE `orders_status_history`

ADD KEY `idx_orders_status_history_orders_id` (`orders_id`)

 

ALTER TABLE `products`

ADD KEY `idx_products_model` (`products_model`)

 

ALTER TABLE `products_attributes`

ADD KEY `idx_products_attributes_products_id` (`products_id`)

 

ALTER TABLE `reviews`

ADD KEY `idx_reviews_products_id` (`products_id`),

ADD KEY `idx_reviews_customers_id` (`customers_id`)

 

ALTER TABLE `specials`

ADD KEY `idx_specials_products_id` (`products_id`)

 

ALTER TABLE `whos_online`

MODIFY `last_page_url` text NOT NULL

 

ALTER TABLE `zones`

ADD KEY `idx_zones_country_id` (`zone_country_id`)

 

ALTER TABLE `zones_to_geo_zones`

ADD KEY `idx_zones_to_geo_zones_country_id` (`zone_country_id`)

 

Furthermore, after applying these changes to the old database, there are a bunch of new options in the `configuration` table. In my case, I just dropped it, imported the new table and reconfigured the site through the GUI (make sure all the payment modules, etc are reconfigured).

 

Best,

Andrey.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...