restore database error

[darksigns]

Can anyone help on this?:

- I have a big database from a previous oscommers merchant it was made in 2007 I would like to use the latest v2.2 version.

- I made a backup from the database, installed the new store to a server, restored the database and I have this error on my site:

- I can't make an upgrade because I have to make new install on a new server the old server was dead.

Fatal error: Call to a member function add_current_page() on a non-object in /home/udchu/domains/udc.hu/public_html/oscommerce/includes/application_top.php on line 312

Can anyone help on this?:

:blink:

[Jan Zonjee]

- I have a big database from a previous oscommers merchant it was made in 2007 I would like to use the latest v2.2 version.

- I made a backup from the database, installed the new store to a server, restored the database and I have this error on my site:

- I can't make an upgrade because I have to make new install on a new server the old server was dead.

Fatal error: Call to a member function add_current_page() on a non-object in /home/udchu/domains/udc.hu/public_html/oscommerce/includes/application_top.php on line 312

You will have to make a few small changes to your database. Presumably (depending when this "old" site was made and which version was used):

alter table configuration modify configuration_title varchar(255) NOT NULL;
alter table configuration modify configuration_key varchar(255) NOT NULL;
insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Product Quantities In Shopping Cart', 'MAX_QTY_IN_CART', '99', 'Maximum number of product quantities that can be added to the shopping cart (0 for no limit)', '3', '19', now());

alter table banners add index idx_banners_group (banners_group);
alter table banners_history add index idx_banners_history_banners_id (banners_id);
alter table currencies add index idx_currencies_code (code);
alter table customers modify column customers_default_address_id INTEGER;
alter table customers add index idx_customers_email_address (customers_email_address);
alter table customers_basket modify column final_price DECIMAL(15,4);
alter table customers_basket add index idx_customers_basket_customers_id (customers_id);
alter table customers_basket_attributes add index idx_customers_basket_att_customers_id (customers_id);
alter table orders add index idx_orders_customers_id (customers_id);
alter table orders_products add index idx_orders_products_orders_id (orders_id);
alter table orders_products add index idx_orders_products_products_id (products_id);
alter table orders_status_history add index idx_orders_status_history_orders_id (orders_id);
alter table orders_products_attributes add index idx_orders_products_att_orders_id (orders_id);
alter table orders_products_download add index idx_orders_products_download_orders_id (orders_id);
alter table products add index idx_products_model (products_model);
alter table products_attributes add index idx_products_attributes_products_id (products_id);
alter table reviews add index idx_reviews_products_id (products_id);
alter table reviews add index idx_reviews_customers_id (customers_id);
alter table specials add index idx_specials_products_id (products_id);
alter table zones add index idx_zones_to_geo_zones_country_id (zone_country_id);

alter table orders_status add public_flag int DEFAULT '1';
alter table orders_status add downloads_flag int DEFAULT '0';

alter table orders modify payment_method varchar(255) NOT NULL;

alter table whos_online modify last_page_url text NOT NULL;

There is presumably another error than the one you get now. Just restart your browser or clear the cookie of your shop to try again. You are the only one seeing this error (but more people will when they get the same errors as you have now on the site).