Zen Cart Logo
Forums / Templates, Stylesheets, Page Layout / Simple cross sell install question

Simple cross sell install question

Locked

Views: 960

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
28 Jan 2009, 9:20 PM
#1
r1formetoo avatar

r1formetoo

Zen Follower

Join Date:
Sep 2008
Posts:
429
Plugin Contributions:
0

Simple cross sell install question

I'm trying to install Tony Corbett's Cross sell Version 1.3.0 and it's telling me to Install SQL Patch, run the included SQL file (products_xsell.sql) but I don't know how to do that. I'm not sure what a query is, how to execute it, what file to upload or anything. Is anyone capable of putting this into more simple terms?

Ian

28 Jan 2009, 10:03 PM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Simple cross sell install question

Very simple - open the sql file in your text editor (Notepad is fine), and copy the whole file to the Windows clipboard.

Then go to Admin - Tools - Install SQL Patches and paste the file into the box and click Send.

28 Jan 2009, 10:57 PM
#3
r1formetoo avatar

r1formetoo

Zen Follower

Join Date:
Sep 2008
Posts:
429
Plugin Contributions:
0

Re: Simple cross sell install question

Here's what I got when I did that. Doesn't sound good to me...

Ian

Error 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.

28 Jan 2009, 11:06 PM
#4
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Simple cross sell install question

r1formetoo:

Here's what I got when I did that. Doesn't sound good to me...

Ian

Error 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.

This means that it already installed :)