Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

upgrading v2.2RC1 to v2.2RC2a


nahi_sonu

Recommended Posts

Hi,

im trying to upgrade my store from v2.2RC1 to RC2a (planning to keep updating to 2.3.1)

according to the guide.. the first step was to run sql query given on it.. when i tried it.. this is what came back:

 

#
# osCommerce, Open Source E-Commerce Solutions
# http://www.oscommerce.com
#
# Copyright (c) 2008 osCommerce
#
# Released under the GNU General Public License
#
# osCommerce SQL Upgrade from 2.2 RC1 to 2.2RC2a
alter table banners add index idx_banners_group (banners_group);# MySQL returned an empty result set (i.e. zero rows).
alter table banners_history add index idx_banners_history_banners_id (banners_id);# MySQL returned an empty result set (i.e. zero rows).
alter table currencies add index idx_currencies_code (code);# MySQL returned an empty result set (i.e. zero rows).
alter table customers add index idx_customers_email_address (customers_email_address);# MySQL returned an empty result set (i.e. zero rows).
alter table customers_basket add index idx_customers_basket_customers_id (customers_id);# MySQL returned an empty result set (i.e. zero rows).
alter table customers_basket_attributes add index idx_customers_basket_att_customers_id (customers_id);# MySQL returned an empty result set (i.e. zero rows).
alter table orders add index idx_orders_customers_id (customers_id);# MySQL returned an empty result set (i.e. zero rows).
alter table orders_products add index idx_orders_products_orders_id (orders_id);# MySQL returned an empty result set (i.e. zero rows).
alter table orders_products add index idx_orders_products_products_id (products_id);# MySQL returned an empty result set (i.e. zero rows).
alter table orders_status_history add index idx_orders_status_history_orders_id (orders_id);# MySQL returned an empty result set (i.e. zero rows).
alter table orders_products_attributes add index idx_orders_products_att_orders_id (orders_id);# MySQL returned an empty result set (i.e. zero rows).
alter table orders_products_download add index idx_orders_products_download_orders_id (orders_id);# MySQL returned an empty result set (i.e. zero rows).
alter table products add index idx_products_model (products_model);# MySQL returned an empty result set (i.e. zero rows).
alter table products_attributes add index idx_products_attributes_products_id (products_id);# MySQL returned an empty result set (i.e. zero rows).
alter table reviews add index idx_reviews_products_id (products_id);# MySQL returned an empty result set (i.e. zero rows).
alter table reviews add index idx_reviews_customers_id (customers_id);# MySQL returned an empty result set (i.e. zero rows).
alter table specials add index idx_specials_products_id (products_id);# MySQL returned an empty result set (i.e. zero rows).
alter table zones add index idx_zones_to_geo_zones_country_id (zone_country_id);# MySQL returned an empty result set (i.e. zero rows).
alter table orders_status add public_flag int DEFAULT '1';# 124 rows affected.
alter table orders_status add downloads_flag int DEFAULT '0';# 124 rows affected.
alter table orders modify payment_method varchar(255) NOT NULL;# 36 rows affected.
alter table whos_online modify last_page_url text NOT NULL;# 2 rows affected.

 

is it normal? and should i just continue to next step?

or is it some sort of error?

please let me know :$

thanks

outside links are not allowed in signatures

Link to comment
Share on other sites

Awais,

 

That is a normal result. It means the tables that needed to be altered were altered and those that didn't need to be altered were untouched.

 

 

 

Chris

Link to comment
Share on other sites

  • 2 weeks later...

Hello,

ive managed to upgrade the store from v2.2RC1 to v2.3.1 using the manual entries instructed in the update package.

but there are few problems on the store now sad.png

the whole template of the store is messed up..

the image path was "http://www.sitename.com/shop/images/"

but now its trying to access them from "http://www.sitename.com/shop/shop/shop/images/"

 

i think the problem is in includes/configuration.php

 

and another issue is:

when i check the server info section from the admin area, it still shows v2.2RC1 :S

outside links are not allowed in signatures

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...