Cross Sell ver 1.3 Install Errors

[jayson.gurney]

I have just downloaded and install the cross sell 1.3 module and when i ran the sql install script i got the following errors - can any explain why this happened and how i can fix it?

Failed: 5
Error ERROR: Cannot create table products_xsell because it already exists
Error ERROR: Cannot insert configuration_key "MIN_DISPLAY_XSELL" because it already exists
Error ERROR: Cannot insert configuration_key "MAX_DISPLAY_XSELL" because it already exists
Error ERROR: Cannot insert configuration_key "SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS" because it already exists
Error ERROR: Cannot insert configuration_key "XSELL_DISPLAY_PRICE" because it already exists
Warning Note: 5 statements ignored. See "upgrade_exceptions" table for additional details.

[dbrewster]

Jayson,

It looks like you had an old version of Cross Sell that you are upgrading, because the database tables already existed.

Ignore those error messages and see if Cross Sell is working for you. Be sure to follow all the file edits exactly, and double-check your work. It may take careful reading.

---Diana

[jayson.gurney]

Jayson,

It looks like you had an old version of Cross Sell that you are upgrading, because the database tables already existed.

Ignore those error messages and see if Cross Sell is working for you. Be sure to follow all the file edits exactly, and double-check your work. It may take careful reading.

---Diana

I would have agreed if it was not after a fresh install to a new sql database - any one with any idea? Does zencart 1.3.0.1 have these tables already installed or something?

[jayson.gurney]

Hi have just trashed the server and done a new and fresh install - looks like its something to do with the sql script being called via the sql import utilty. If i copy the script data and paste it into the import utility its worked ok

[Woodymon]

Hi have just trashed the server and done a new and fresh install - looks like its something to do with the sql script being called via the sql import utilty. If i copy the script data and paste it into the import utility its worked ok

If you are referring to /admin/sqlpatch.php then avoid pasting your sql into the form window. Either upload the *.sql file via the upload button or patch your db using phpmyadmin.

And as suggested in another thread do check your db table prefix.

Woody