Just another Cross-Sell mod (support thread)

[pinetreecandles]

Nevermind, all is well now. I had modified the sytlesheet and messed something up. I have it fixed now.

Thanks again for the great mod.

[gustafr]

I have installed the Original Cross Sell and it works properly. However, when i try to install JAXSell i get the following error when installing the SQL patch (see below). Does anyone recognize this problem? Solution?
Thanks in advance!

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Cross Sell', 'Set Cross Sell Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';


UPDATE configuration SET configuration_group_id = @t4 WHERE configuration_key IN ('MIN_DISPLAY_XSELL','MAX_DISPLAY_XSELL','SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUC TS','XSELL_DISPLAY_PRICE');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Input type to be used in form', 'XSELL_FORM_INPUT_TYPE', 'model', 'Choose to use product ID or MODEL as your input type. Check readme file for more info', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'XSell Product Input Separator', 'XSELL_PRODUCT_INPUT_SEPARATOR', ',', 'You will need to insert all product id/model you want to cross-sell in 1 field, so each product id/model needs to be separated by a separator. The default is comma, choose another if you want to', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'XSell Sort Order', 'XSELL_SORT_ORDER', 'default', 'Sometimes you may want to display the xsell products randomly, especially if each product xsells with lots of others', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'defalt\', \'model\')');
12 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

[yellow1912]

First, there is a new version uploaded with minor bug fixes. Second: I have no idea why you have those errors, since the configuration_key are there, but the error reports seem to say they are empty.

[gustafr]

I know, it's really strange! I have no problem to run the sql patch to the original cross sell and i have tried several time with the same result.
I don't think anything was changed in the sql-file in the last release? However i got the same result.
No one with the same problem as i have?

[yellow1912]

If you use table prefix in the db, attach the prefix into the table names, then run the sql thru phpmyadmin to see if it makes any different.

[paulm]

ERROR: Cannot insert configuration_key "" because it already exists

This is a known sqlpatch.php issue, and it is *very* likely that you have an empty configuration_key in your configuration table.

An easy way around the issue is to remove the empty key:

DELETE FROM configuration WHERE configuration_key = "";

And after that you should be able to apply the sql patch without any errors.

(using phpMyAdmin as suggested by yellow will help too, an advantage of the above fix however is that it will fix issues you will otherwise have with lots of other sql patches as well)

[Chinchilla2661]

I've got both Cross Sell and JAX installed and running. Everything shows nicely in the public side, gets added to the db, both one way and both way xsells. Works really nice.

One problem tho. For some reason I'm not getting my list of xsells under the "List all Cross-sells" header. I'm using the current version located on your site. Any suggestions on fixing this would be great. If I figure it out, I'll post it here in case someone else comes across this.

[gustafr]

Thank you Paulm, your fix solved my problem. Now it works perfectly.
Best Regards
Gustaf

[yellow1912]

I've got both Cross Sell and JAX installed and running. Everything shows nicely in the public side, gets added to the db, both one way and both way xsells. Works really nice.

One problem tho. For some reason I'm not getting my list of xsells under the "List all Cross-sells" header. I'm using the current version located on your site. Any suggestions on fixing this would be great. If I figure it out, I'll post it here in case someone else comes across this.

You dont get the whole list, or you get part of the list? Your mysql version is?

[Chinchilla2661]

It's completely blank under the "List All Cross-Sells" section. They appear in the public side (catalog side), but not in the admin side. If I head back to the original Cross-Sell admin panel, scroll the list they appear there. They also appear in the db.

Server information:
Development server on localhost:
Database: MySQL 5.0.41-community-nt
HTTP Server: Apache/2.0.59 (Win32) PHP/5.2.2
PHP Version: 5.2.2 (Zend: 2.2.0)

I have attached ss's of the two different pages.

If it wasn't for being on the localhost, I'd send you a link so you could see yourself.