[xplorer]

Originally Posted by Serginfor.com

To upgrade the database gives this error

Creating a new tables definition .
SQL error #1105 : MyISAM table 'xcart_category_bookmarks' is in use (most likely by a MERGE table). Try FLUSH TABLES.
SQL query: CREATE TABLE xcart_category_bookmarks ( xcart_category_bookmarks.categoryid int(11) NOT NULL default '0', xcart_category_bookmarks.add_date int(11) NOT NULL default '0', xcart_category_bookmarks.login varchar(32) NOT NULL default '', UNIQUE KEY categoryid (categoryid,login)) TYPE=MyISAM

Try:

1. Find the following text in "tables.sql":

ALTER TABLE xcart_shipping_rates ADD apply_to char(6) NOT NULL default 'DST' AFTER type;

CREATE TABLE xcart_category_bookmarks (
    xcart_category_bookmarks.categoryid int(11) NOT NULL default '0',
    xcart_category_bookmarks.add_date int(11) NOT NULL default '0',
    xcart_category_bookmarks.login varchar(32) NOT NULL default '',
    UNIQUE KEY categoryid (categoryid,login)
) TYPE=MyISAM;

2. Manually execute the ALTER TABLE operation in the MySQL console (it appears as the operation consumes too much resources on your server and cannot be executed from the DB upgrade script)

3. Cut the operation from the file and save the file

4. Run the DB upgrade script