Cross Sell Advanced [Support Thread]

[lloyd_borrett]

G'day,

If someone is looking to enhance this plugin it would be really nice if given a list of n products, the mod had an option (checkbox) to ask it to automatically go through and cross-sell EACH combination together.

For example, if you give it 3 products: A, with cross sell to B and C, it could optionally cross-sell:
A to B and C,
B to A and C, and
C to A and B.

Obviously the larger n is, the greater the admin time saving would be.

Best regards, Lloyd Borrett.

[DivaVocals]

G'day,

If someone is looking to enhance this plugin it would be really nice if given a list of n products, the mod had an option (checkbox) to ask it to automatically go through and cross-sell EACH combination together.

For example, if you give it 3 products: A, with cross sell to B and C, it could optionally cross-sell:
A to B and C,
B to A and C, and
C to A and B.

Obviously the larger n is, the greater the admin time saving would be.

Best regards, Lloyd Borrett.

There are other cross sell modules that may already provide this functionality.. Suggest looking at one of those if you want the feature.. It's likely why no one has ever enhanced this one beyond it's current featureset..

[roeghar]

Hello, I'm having a problem with cross_sell_plus_advanced_combo_1.3. I'm running Zencart 1.5.4 which I updated to back in May of 2015. Before that I had been using this addon through many versions back to maybe 1.3.x and always appreciated its functionality. Decided to give it another try on my locally hosted test site (Mac OS X 10.8). I downloaded the latest version 1.3a and reuploaded the files to their proper places (checked it closely several times to make sure I hadn't dropped something in the wrong place. Went back to the admin page (running in the latest version of Firefox) and got a big white screen with this message- WARNING: An Error occurred, please refresh the page and try again. Maybe it was luck, maybe I remembered from the last try but the first file I pulled out of the configuration - config.xsell.php - fixed it. Well at least admin worked again but no configuration menu and no cross-sell. And the other thing, if I remember right, there used to be a sql patch that needed to be installed. Doesn't seem to be one in the new version. If the new version depends on an existant sql patch maybe mine disappeared along the upgrade path. Any suggestions would be appreciated as I did see this problem mentioned earlier in the thread

[roeghar]

One little addition. The Table: products_xsell is still in the database. I checked it with phpmyadmin.

[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