Cross Sell Advanced [Support Thread]

[Georgecy]

Is it compatible with 1.5.7c and ZCA bootstrap template? Any specific installation instructions?

[Georgecy]

Is it compatible with 1.5.7c and ZCA bootstrap template? Any specific installation instructions?

I have installed the Cross sell advanced on 1.5.7.c with php 7.4 and mysql 5.7 and it gave the error below. Any comments are welcome.

PHP Fatal error: 3065:Expression #1 of ORDER BY clause is not in SELECT list, references column 'store_157c.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT :: select distinct p.products_id, p.products_image, pd.products_name
from products_xsell xp, products p, products_description pd
where xp.products_id = '4400'
and xp.xsell_id = p.products_id
and p.products_id = pd.products_id
and pd.language_id = '1'
and p.products_status = 1 order by xp.sort_order asc limit 6 ==> (as called by) /includes/modules/bootstrap/xsell_products.php on line 40 <== in /includes/classes/db/mysql/query_factory.php on line 170.

[lat9]

I've just submitted v2.0.0 of (now) Cross Sell Advanced II for the Zen Cart moderators' review and will post back here when it's available for download at https://www.zen-cart.com/downloads.php?do=file&id=2334.

This version, based on v1.5 of Cross Sell Advanced (https://www.zen-cart.com/downloads.php?do=file&id=400:

• Requires Zen Cart 1.5.7 (fully-patched) or later.
• Is updated to support now-current versions of PHP and strict MySQL installations.
• Combines the processing of the previous version's two admin tools into one.
• Includes a Database I/O Manager (DbIo) handler, enabling import/export of the cross-sells via a .csv file.
• No more auto-deleting admin installation!
• Removes associated cross-sells when a product is removed.
• Includes integration with the ZCA Bootstrap template.

Early adopters can check out the updates on the plugin's GitHub repository: https://github.com/lat9/cross_sell_advanced

[lat9]

I've just submitted v2.0.0 of (now) Cross Sell Advanced II for the Zen Cart moderators' review and will post back here when it's available for download at https://www.zen-cart.com/downloads.php?do=file&id=2334.

This version, based on v1.5 of Cross Sell Advanced (https://www.zen-cart.com/downloads.php?do=file&id=400:

• Requires Zen Cart 1.5.7 (fully-patched) or later.
• Is updated to support now-current versions of PHP and strict MySQL installations.
• Combines the processing of the previous version's two admin tools into one.
• Includes a Database I/O Manager (DbIo) handler, enabling import/export of the cross-sells via a .csv file.
• No more auto-deleting admin installation!
• Removes associated cross-sells when a product is removed.
• Includes integration with the ZCA Bootstrap template.

Early adopters can check out the updates on the plugin's GitHub repository: https://github.com/lat9/cross_sell_advanced

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2334

[Elemi]

My 1.5.7c doesn't appear to have zca_bootstrap. Is it needed for this add-on to work?

[Elemi]

My 1.5.7c doesn't appear to have zca_bootstrap. Is it needed for this add-on to work?

So I went ahead and installed it, however when I add the /YOUR_ADMIN/includes/auto_loaders/config.xsell.php my admin crashes completely, and when I remove it I have full access again... here's the error log:

[09-Jan-2022 10:11:38 Pacific/Auckland] Request URI: /ditCh-yIE-joInt/whos_online.php?t=15, IP address: 222.155.5.136
#1 trigger_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php:164]
#5 require_once(/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php) called at [/home/amoraromatherapy/public_html/includes/autoload_func.php:37]
#6 require(/home/amoraromatherapy/public_html/includes/autoload_func.php) called at [/home/amoraromatherapy/public_html/myadmin/includes/application_top.php:37]
#7 require(/home/amoraromatherapy/public_html/myadmin/includes/application_top.php) called at [/home/amoraromatherapy/public_html/myadmin/whos_online.php:11]
--> PHP Fatal error: 1146:Table 'amorarom_amordotcom.products_xsell' doesn't exist :: ALTER TABLE products_xsell
MODIFY COLUMN `ID` int(11) NOT NULL auto_increment,
MODIFY COLUMN products_id int(11) NOT NULL,
MODIFY COLUMN xsell_id int(11) NOT NULL,
MODIFY COLUMN sort_order int(11) NOT NULL DEFAULT 1 ==> (as called by) /home/amoraromatherapy/public_html/myadmin/includes/init_includes/init_xsell_config.php on line 164 <== in /home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php on line 170.


All manual template changes have been done.

[lat9]

So I went ahead and installed it, however when I add the /YOUR_ADMIN/includes/auto_loaders/config.xsell.php my admin crashes completely, and when I remove it I have full access again... here's the error log:

[09-Jan-2022 10:11:38 Pacific/Auckland] Request URI: /ditCh-yIE-joInt/whos_online.php?t=15, IP address: 222.155.5.136
#1 trigger_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php:164]
#5 require_once(/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php) called at [/home/amoraromatherapy/public_html/includes/autoload_func.php:37]
#6 require(/home/amoraromatherapy/public_html/includes/autoload_func.php) called at [/home/amoraromatherapy/public_html/myadmin/includes/application_top.php:37]
#7 require(/home/amoraromatherapy/public_html/myadmin/includes/application_top.php) called at [/home/amoraromatherapy/public_html/myadmin/whos_online.php:11]
--> PHP Fatal error: 1146:Table 'amorarom_amordotcom.products_xsell' doesn't exist :: ALTER TABLE products_xsell
MODIFY COLUMN `ID` int(11) NOT NULL auto_increment,
MODIFY COLUMN products_id int(11) NOT NULL,
MODIFY COLUMN xsell_id int(11) NOT NULL,
MODIFY COLUMN sort_order int(11) NOT NULL DEFAULT 1 ==> (as called by) /home/amoraromatherapy/public_html/myadmin/includes/init_includes/init_xsell_config.php on line 164 <== in /home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php on line 170.


All manual template changes have been done.

Did you have a previous version of a Cross-Sell plugin installed? Since that table doesn't exist, you could run the Cross-Sell Advanced II uninstall SQL (part of the zipped package) which will remove the configuration settings (not the code) and then (restoring the config. file) attempt the install again.

[Carbonless]

So I went ahead and installed it, however when I add the /YOUR_ADMIN/includes/auto_loaders/config.xsell.php my admin crashes completely, and when I remove it I have full access again... here's the error log:

[09-Jan-2022 10:11:38 Pacific/Auckland] Request URI: /ditCh-yIE-joInt/whos_online.php?t=15, IP address: 222.155.5.136
#1 trigger_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php:164]
#5 require_once(/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php) called at [/home/amoraromatherapy/public_html/includes/autoload_func.php:37]
#6 require(/home/amoraromatherapy/public_html/includes/autoload_func.php) called at [/home/amoraromatherapy/public_html/myadmin/includes/application_top.php:37]
#7 require(/home/amoraromatherapy/public_html/myadmin/includes/application_top.php) called at [/home/amoraromatherapy/public_html/myadmin/whos_online.php:11]
--> PHP Fatal error: 1146:Table 'amorarom_amordotcom.products_xsell' doesn't exist :: ALTER TABLE products_xsell
MODIFY COLUMN `ID` int(11) NOT NULL auto_increment,
MODIFY COLUMN products_id int(11) NOT NULL,
MODIFY COLUMN xsell_id int(11) NOT NULL,
MODIFY COLUMN sort_order int(11) NOT NULL DEFAULT 1 ==> (as called by) /home/amoraromatherapy/public_html/myadmin/includes/init_includes/init_xsell_config.php on line 164 <== in /home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php on line 170.


All manual template changes have been done.

I have 1.5.7c fresh install, do not have ZCA bootstrap on my test server... crashes my admin.

Havent taken time yet to see why.