Advanced Xsell installation Zencart v. 1.3.8

[ericw]

Get the following error when install is finished in module manager


1050 Table 'products_xsell' already exists
in:
[CREATE TABLE products_xsell ( ID int(10) NOT NULL auto_increment, products_id int(10) unsigned NOT NULL default 1, xsell_id int(10) unsigned NOT NULL default 1, sort_order int(10) unsigned NOT NULL default 1, PRIMARY KEY (ID), KEY idx_products_id_xsell (products_id) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


Advanced xsell will not let me add inventory xsell items.

The following is the module manager listing I get.

ID module_code patch_level version_name Update
1 ri_jaxs -1 Revision 185 update

[Absolute]

Just run the install script without the CREATE xsell_products line. That table is already there, so you don't need to install it. Just use phpMyAdmin, and check that it has the same structure as that required in the SQL statement.

Alternatively, if you can't access the install script, just log into your phpMyAdmin and remove the table mentioned. This will mean you will loose all your xsell data, so backup first if you want to keep it.

If you don't have phpMyAdmin, or direct access to your database, you will need to use a DROP statement to remove the pre-existing table.

Absolute

[NWCE]

Hi Absolute,

I am having a similar problem with the script as EricW. I am running Zen Cart v 1.3.8 with a previously installed cross sell program in it. My advanced cross sell works, other than in the Config->Cross Sell, it does not have the entire table that allows to set the maximum number of products to XSell. My ri_jaxs 185 when I try to update it will give me the same error as EricW had, and when I check the script in myPHPadmin I receive this error:

Error

SQL query:

[ CREATE TABLE products_xsell(
ID int( 10 ) NOT NULL AUTO_INCREMENT ,
products_id int( 10 ) unsigned NOT NULL default 1,
xsell_id int( 10 ) unsigned NOT NULL default 1,
sort_order int( 10 ) unsigned NOT NULL default 1,
PRIMARY KEY ( ID ) ,
KEY idx_products_id_xsell( products_id )
) TYPE = MYISAM ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CREATE TABLE products_xsell ( ID int(10) NOT NULL auto_increment, products_id i' at line 1

There is an obvious syntax error, but I don't understand what I can do to fix it. Would you have any suggestions?

Thanks,

Jeff

[NWCE]

Would there be a file in the original cross sell to simply modify with this code, in order to complete the build of the table. It would then contain all of the optional fields in the Config->Cross Sell.

Just a thought,

Jeff

[NWCE]

Hi,

I found a fix for this problem when upgrading from 1.3.8a to 1.3.9d. When you have completely installed the advanced cross sell module, but do not have the complete table in Config->Cross Sell to allow me to set the number of cross sell products, etc.

Simply go into Admin->Tools->Install SQL Patches Re-run the SQL 0 and SQL 1 patches in this. You will see a couple of item errors when running these, but just disregard them. You will now have the complete table in Config->Cross Sell.

I have been using the advanced cross sell for over a month now, with no problems.