Cross Sell Advanced [Support Thread]

[roeghar]

Ok, a month or so later, I noticed a bump up in the version of this mod to cross_sell_plus_advanced_combo_1.3 2, so I had another go at it. Went through and striped out any files from older versions ( I've got several old ones in my downloads folder.) Don't think I missed any. But still the same results - admin/includes/auto_loaders/config.xsell.php breaks the admin and triggers the "WARNING: An Error occurred, please refresh the page and try again." Pull config.xsell.php out and admin comes back. Sill in Zencart 1.5.4.

I checked in in server of mine running Zencart 1.5.1 to check what products were entered in cross-sell and then went back to my current install and realized that they were still working. Unfortunately, I have no cross sell and advanced cross sell in my drop down catalog menu so I can't add new products to the cross sell data base, which I really need to do.

Any suggestions would sure be appreciated. I really miss this modules.

Thanks

[DrByte]

breaks the admin and triggers the "WARNING: An Error occurred, please refresh the page and try again."

That usually indicates a SQL error, and its details are in your /logs/ folder on the server.
This FAQ (which I find by using the Search and pasting in the error message) speaks directly to that issue: http://www.zen-cart.com/content.php?...-and-try-again

[roeghar]

Thank you DrByte for getting back to me. This is what myDEBUG reports:

[22-Jan-2016 17:44:29 America/Chicago] PHP Fatal error: 1062uplicate entry 'MIN_DISPLAY_XSELL' for key 'unq_config_key_zen' :: 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 (NULL, 'Display Cross-Sell Products Minimum', 'MIN_DISPLAY_XSELL', '1', 'This is the minimum number of configured Cross-Sell products required in order to cause the Cross Sell information to be displayed.<br />Default: 1', '86', 20, NULL, now(), NULL, NULL) ==> (as called by) /Library/WebServer/Documents/jokgha/includes/init_includes/init_xsell_config.php on line 69 <== in /Library/WebServer/Documents/includes/classes/db/mysql/query_factory.php on line 155

I mucked about in the files and tried to enable STRICT_ERROR_REPORTING but that didn't seem to yield any more information. I'm afraid I just don't understand what "Duplicate entry 'MIN_DISPLAY_XSELL' for key 'unq_config_key_zen' " means or how to correct it. Every thing about my local of line site works fine.

Here are its values:Server Host: www.esftestsite (127.0.0.1) Database Host: localhost (127.0.0.1)
Server OS: Darwin 12.6.0 Database: MySQL 5.5.41
Server Date: 01/23/2016 14:36:59 Database Date: 01/23/2016 14:36:59
Server Up Time: 14:36 up 2 days, 19:55, 1 user, load averages: 0.58 0.68 0.71 HTTP Server: Apache/2.2.29 (Unix) DAV/2 PHP/5.3.29 mod_ssl/2.2.29 OpenSSL/0.9.8zd
PHP Version: 5.3.29 (Zend: 2.3.0) PHP Memory Limit: 128M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 141,787 kB Database Index Size: 3,702 kB

I checked out your post 1062: Duplicate entry 'xxxxxx' for key which seems to be relevant to this problem but an not sure as only the cross-sell module seems to be affected.

Not sure what to do next.

[gilby]

You probably have remnants of a previous cross that did not get uninstalled completely before installing this version
Using phpmyadmin search for the key in configuration
MIN_DISPLAY_XSELL
and then delete it

[roeghar]

Thanks to both gilby and DrByte

First, I carefully repeated the edits to cache.php and sessions.php to make sure I hadn't messed up in making the changes. Still the same results: admin works fine with the edits until config.xsell.php is dropped into the auto_loaders folder. The only change is in the error message. Now returns: "WARNING: An Error occurred, please refresh the page and try again."

Next, I searched and found in phpmyadmin the MIN_DISPLAY_XSELL configuration entry and deleted it. No change, same result. Then I also deleted MAX_DISPLAY_XSELL to see if that might help. Same results. Same error message.

Again, I'm stuck. I appreciate the suggestions and am open to whatever else anyone can suggest.

[explorer1979]

Hi all,

I am using ZC 1.5.4, rebuild / upgrade it on a testing folder .. (Before running ZC 1.5.1 on Live)
On the ZC 1.5.1 it work well WITH Cross Sell 1.3.1 Modules.

Now, on ZC 1.5.4 I am experience error of the Cross Sell 1.3.1 modules, it show this error at log
PHP Warning: mysql_query(): Access denied for user in admin/xsell.php on line 151
PHP Warning: mysql_query(): A link to the server could not be established in admin/xsell.php on line 151
PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in admin/xsell.php on line 170

Ok, I know it is abit off topic above ... now go the key point ....

Do Cross Sell Advanced 1.3a now still need Cross Sell First??? (Since on the early version I see a notice text it depend on Cross Sell this Modules)

Thank you.

Best Regards,
Jimmy Chan

[lat9]

The plugin is making direct PHP mysql_* function calls on a version of Zen Cart where the database has been opened via the PHP mysqli_* series of calls; that's where the debug-log arises.

[ideasgirl]

Ok, a month or so later, I noticed a bump up in the version of this mod to cross_sell_plus_advanced_combo_1.3 2, so I had another go at it. Went through and striped out any files from older versions ( I've got several old ones in my downloads folder.) Don't think I missed any. But still the same results - admin/includes/auto_loaders/config.xsell.php breaks the admin and triggers the "WARNING: An Error occurred, please refresh the page and try again." Pull config.xsell.php out and admin comes back. Sill in Zencart 1.5.4.

I checked in in server of mine running Zencart 1.5.1 to check what products were entered in cross-sell and then went back to my current install and realized that they were still working. Unfortunately, I have no cross sell and advanced cross sell in my drop down catalog menu so I can't add new products to the cross sell data base, which I really need to do.

Any suggestions would sure be appreciated. I really miss this modules.

Thanks

I'm having this issue even is a new installation of the module, not an update.

That usually indicates a SQL error, and its details are in your /logs/ folder on the server.
This FAQ (which I find by using the Search and pasting in the error message) speaks directly to that issue: http://www.zen-cart.com/content.php?...-and-try-again

There's no error in any of my logs.

You probably have remnants of a previous cross that did not get uninstalled completely before installing this version
Using phpmyadmin search for the key in configuration
MIN_DISPLAY_XSELL
and then delete it

I do not since it's a new installation.

Thanks to both gilby and DrByte

First, I carefully repeated the edits to cache.php and sessions.php to make sure I hadn't messed up in making the changes. Still the same results: admin works fine with the edits until config.xsell.php is dropped into the auto_loaders folder. The only change is in the error message. Now returns: "WARNING: An Error occurred, please refresh the page and try again."

Next, I searched and found in phpmyadmin the MIN_DISPLAY_XSELL configuration entry and deleted it. No change, same result. Then I also deleted MAX_DISPLAY_XSELL to see if that might help. Same results. Same error message.

Again, I'm stuck. I appreciate the suggestions and am open to whatever else anyone can suggest.

I don't have any table with xsell. The only one there is xsell1 which is from the Multi Cross Sell which I'm trying to substitute.

ZC v1.5.5e (upgrade from 1.5.4)
PHP Version: 5.6.30
Database: MySQL 5.6.35