X-Cart forums

[TL408]

svowl,

Can you please assist with my question below regarding to upgrading my webstore from 4.0.17 to 4.0.18 ?

Thank you
-Tuan

[svowl]

Originally Posted by TL408

svowl,

Can you please assist with my question below regarding to upgrading my webstore from 4.0.17 to 4.0.18 ?

Thank you
-Tuan

The table 'xcart_counters' was included in 4.0.18. So, it seems you have applied some patch that contained this table. To upgrade to 4.0.18, do the following:
1) Restore your old X-Cart (4.0.17) - both the files and the database
2) Uncompress the files from the upgrade pack to the directory with X-Cart
3) Check if 'xcart_counters' table exists in the database. If it exists, open the file <xcart_dir>/upgrade/4.0.17-4.0.18/patch.sql and delete this block:

CREATE TABLE xcart_counters (                                                   
  type char(1) NOT NULL default '',                                             
  value int(11) NOT NULL auto_increment,                                        
  PRIMARY KEY  (type,value)                                                     
) TYPE=MyISAM;

[TL408]

Thanks svowl. Your help is greatly appreciated.

-Tuan

Originally Posted by svowl

The table 'xcart_counters' was included in 4.0.18. So, it seems you have applied some patch that contained this table. To upgrade to 4.0.18, do the following:
1) Restore your old X-Cart (4.0.17) - both the files and the database
2) Uncompress the files from the upgrade pack to the directory with X-Cart
3) Check if 'xcart_counters' table exists in the database. If it exists, open the file <xcart_dir>/upgrade/4.0.17-4.0.18/patch.sql and delete this block:

CREATE TABLE xcart_counters (                                                   
  type char(1) NOT NULL default '',                                             
  value int(11) NOT NULL auto_increment,                                        
  PRIMARY KEY  (type,value)                                                     
) TYPE=MyISAM;

[kustomrides]

[quote="svowl"]

Originally Posted by TL408

svowl,

Open the file <xcart_dir>/upgrade/4.0.17-4.0.18/patch.sql and delete this block:

CREATE TABLE xcart_counters (                                                   
  type char(1) NOT NULL default '',                                             
  value int(11) NOT NULL auto_increment,                                        
  PRIMARY KEY  (type,value)                                                     
) TYPE=MyISAM;

Did this after encountering the SQL error. Thanks for saving a late night upgrade for me. Love this forum!