Thanks DrByte, I did the local/configure technique and help me figure out the errors of "duplicated keys" and fixing them. :clap:
Printable View
Thanks DrByte, I did the local/configure technique and help me figure out the errors of "duplicated keys" and fixing them. :clap:
Hi all,
2 things:
1. So the name that's on the page where you download & the name in the actual software are different. That's why there was some confusion. Looks like someone took the old version & updated it, & didn't create a new unique name.
2. The issue was the template files that go into the "includes/modules" folder. We didn't see any instructions for them. The instructions say to rename YOUR_TEMPLATE directory (singular), there's actually multiple directories that need to be changed. There is one under "includes/modules," & that also needs to be changed, & that solved that problem.
HTH
I am trying to translate the display for the customers into French.
I copied all the files from the "english" language folders in a "french" language folder, and translated everything i could see.
However, i can still see TEXT_XSELL_PRODUCTS displayed, and i have no clue where i might be missing the translation of that header. I am not even sure in what file.
Could you point me to the right place?
Use your admin's Tools->Developers' Tool Kit and search for TEXT_XSELL_PRODUCTS in all Catalog .php files. That will let you know where it's defined in the english version.
We're really going to have to find you something to do:P
IF you have filled everything in, you might have missed a single quote (')on that define. Search first with the developers toolkit for the TEXT_XSELL_PRODUCTS to find what file(s) it is in.
If it's NOT in two files (english and french), add it to the french to match the english.
If it IS in two files, the french version is the problem. Should look something likeNote that there must always be an opening and closing single quote.Code:define('BOX_HEADING_MANUFACTURERS', 'Manufacturers');
Thank you. Fixed it (I should get a hang of that developer tool!)
I'm using version 1.5 and it works well for my site and products but I wonder if there is a way to include a small text message to each cross sell. My cross sells are substitutes for out of stock or unavailable products. These substitutes often have some differences from the original product. I already have the messages available and linked up in a local database and I fill the cross sell table from a homemade php socket. I need a text field maximum of 256 characters in size to display with each cross sell. I know that I'll need another column in my db table and I can load it via my homemade socket, but I need help with displaying it and adding an extra field on the admin page just in case I need to change an individual entry.
Hi, I have just added this mod onto my site.
Why do my products fall below each other (vertical) shouldn't they be side by side (horizontally) i.e 3 products per row and bigger?
If I change the column settings the list just moves from centre (1 per row) to the left (6 per row)
Using version 1.5.5f
Is this module compatible with 1.5.6?
Quote:
Originally Posted by ideasgirl
I'd also like to know the answer to this...
Anyone know?
Thanks!
Confirmed Working with 1.5.6c! Thanks Developers and Support!!!
***Only issue I noticed is that "config.xsell" must be installed last.
When I copied that file before anything else in the "YOUR_ADMIN" folder, My Zen Kart Admin portal would return the error HTTP 500 Bad Request.
After installing each file, I make sure to refresh a random page on my website and refresh the Zen Kart Admin (YOURWEBSITE.COM/YOURADMIN).
This helped my find the issue much faster than in the past :)
For Tagging:
Cross Sell Advanced HTTP 500 Bad Request fix
I am working on a site that is v 1.5.7c
Will this mod work on v1.5.7c?
Yes, it will - 100% compatible.Quote:
Originally Posted by 4tinak
New install v1.5.7c TEXT_XSELL_PRODUCTS is defined in product_info.php file but the TEXT_XSELL_PRODUCTS is displayed in box and now the "can we recommend?" as defined. Any suggestions on why the define is not working.Quote:
Originally Posted by Hollywood691
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.Quote:
Originally Posted by Georgecy
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.
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=2334Quote:
Originally Posted by lat9
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:Quote:
Originally Posted by Elemi
[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.Quote:
Originally Posted by Elemi
No, it was a fresh install of 1.5.7c in June 2020, with all patches added. No previous version of Cross-Sell. I had to create the zca_bootstrap folder too, as that hasn't been part of my site.
I'll try the uninstall suggestion tomorrow... it's 2am here and we all know doing techy stuff in the wee hours doesn't pay off... lol
Quote:
Originally Posted by Elemi
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.
:oops: Found it. v2.0.1 coming later today.Quote:
Originally Posted by Elemi
oh yay... I'm not quite going mad yet lolQuote:
Originally Posted by lat9
I've just submitted v2.0.1 of Cross Sell Advanced II for the Zen Cart moderators' review and will post back here when it's available for download.Quote:
Originally Posted by lat9
This release corrects (see GitHub issue #5) the MySQL error received on a 'fresh' install and also corrects the plugin's uninstall SQL script.
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2334Quote:
Originally Posted by lat9
Hmmm same issue. Would you like to be paid to do it for me because something isn't right somewhere when running it with Westminster_New 2.01 :-)Quote:
Originally Posted by lat9
Did you first run the plugin's uninstall SQL (located in the root of the zipped directory structure)? I'd expect that 'same issue' otherwise.Quote:
Originally Posted by Elemi
yes I did...Quote:
Originally Posted by lat9
What debug log(s) are being thrown?
Hi,
Thank you for updating this plugin to be compatible with v.1.5.7....it is much appreciated! I have run Multi Cross Sell on my site currently (v.1.5.5) and now when upgrading to v.1.5.7 can do so.
I have one issue that I cannot seem to diagnose....I have uploaded all files and edited tpl_product_info_display.php with the suggested code in the suggested area. When I am logged into Admin, it sees this new module, and shows all of my cross sold products. My only issue is that it is not displaying on the product info page.
I have a template installed and when placing in the edited tpl_product_info_display.php I have placed it in templates/mytemplate/templates I cannot even see the code when inspecting my website with browser tools. When I edit the suggested code to move the <?php and ?> code to inside of the green BOF and EOF statements, I can then see this appear when inspecting using my browser, but there is no code displaying in between the BOF Advanced Cross Sell II and EOF Cross Sell II
I have double checked my install to be sure that I have not missed installing anything and all is there and it is not throwing any errors (no Debug log in the Logs folder). It is almost as if for some reason it is not calling the tpl_modules_xsell2_products.php which is in this same folder.
Any ideas on why it is not displaying???
Thanks,
Jeff
Thanks.....I was able to make appropriate code changes due to custom template to get this plug-in working and displaying.
Thanks again for updating this fabulous plug in!
I had one more issue come up that I am hoping you will know the answer to.
The v.1.5.7 is a fresh install that I then installed the template into. Everything works well except that it displays the cross sells twice.
I have tried deleting the module and running the uninstall.sql statement and reinstalling it and I come up with the same result of the images displaying twice. I looked at the previous Multi Cross Sell plug in installed on my current v.1.5.5 site and am wondering if it is still picking up something in the database that is causing this conflict.
I have run the uninstall from the previous Multi Cross Sell v.1.03 on my v.5.7 site by uploading the unreg_multi_xsell file in the proper Admin folder and when I log into the Admin panel it comes up saying I "Must Use Remove Button on Multi Cross Sell First in Admin->Catalog->Multi Cross Sell" which does not exist as this is a fresh install of Zen Cart v.1.5.7.
It must have something in the database that it is grabbing from from the previous Xsell table that makes it think that the previous module is still installed?? I am wondering if this is what is causing the duplicate output display on the product display pages??
Thanks in advance for your help,
Jeff
There are/were a bunch of other Cross-Sell addons. To get me to the right one, could you post its Zen Cart download link?Quote:
Originally Posted by NWCE
Hi lat9,
Thanks for your reply and for your help!
Here is the link to the Multi Cross Sell v.1.03 that I had installed in my v.1.5.5 cart https://www.zen-cart.com/downloads.php?do=file&id=1128
If you wanted to see the output of what is happening on my working copy of my v.1.5.7 site you can see it here https://www.nitwitcollections.com/ja...ain_page=index
Thanks again,
Jeff
Oof, it's hard to tell whether it's remnants of that Multi Cross-Sell or that YourStore template.
If you're familiar with the use of phpMyAdmin (in your webhost's cPanel), you can examine your 'configuration_group' table to locate the entry with the title of 'Cross Sell Settings' and note its configuration_group_id value. We'll call that 'xx' in the suggestion below.
Then enter the following SQL command via phpMyAdmin's SQL tab (if you use a non-empty DB_PREFIX, you'll need to prepend that value to the table names):
DELETE FROM configuration WHERE configuration_group_id = xx;
DELETE FROM configuration_group WHERE configuration_group_id = xx;
DELETE FROM admin_pages WHERE page_key = 'MultiXsell';
I'm quite unfamiliar with that multi-xsell plugin (and don't have time for further investigation), so I'm unclear as to where that message is coming from. That said, it 'sounds like' you've got remnants of that plugin still present in your upgraded site.
Hi lat9,
Thanks for your help! I have run these SQL commands as you suggested and did see in configuration_group that is configuration_group_id 41. It ran fine and was successful and I now have no configuration_group_id 41 any longer in the tables of configuration and configuration_group. When I go to the site it still displays duplicate items. Also to answer your question on the YourStore template....it is a brand new template I purchased and am installing that was made specifically for Zen Cart v.1.5.7. It did include the plug in Related Products, but I have completely removed the plug in.
When I look in the admin_pages table I still under the page_key row ConfigMultiXSell, and the language_key row lists this as Box_Configuration_Multi_Xsell_products. I am assuming that I can delete this (it does show under the page_params that it is gID=41). Just wanted to check before doing....but does make sense as it is showing part of gID 41. I also have and see in this table the entries for ConfigXSellCombo (gID=78) and CatalogXSellComboAdmin but I am thinking that they relate to your Cross Sell Advanced II plug in.
Thanks again for your help,
Jeff
That "ConfigMultiXSell" is associated with the previous version, the configXSellCombo and catalogXSellComboAdmin are, as you surmised, associated with the Cross Sell Advanced II implementation.Quote:
Originally Posted by NWCE
Thanks again for your reply lat9.
I have removed this ConfigMultiXSell but still show duplicate outputs on the product info pages. Is there anything else that you could point me in the right direction of for me to research??
Thanks again,
Jeff
I have been searching and had a question to you lat9 as you obviously know what you're doing.
I have selected my database in MyPhPAdmin and run a Search on all tables for the word "Xsell". It returned 2 results in admin_pages amd 4 results in configuration. When I look at these results within these tables they all relate to your plug in. So this has to be telling me that the previous plug in is completely erased. I have also looked at the products_xsell table to insure that there are no duplicate entries.....and nothing.
As this is a real head scratcher and I cannot go live with this result, would the old version of this plug in (the one I'm currently using on my v.1.5.5 site) work in zen cart v.1.5.7 I know that there have been some fundamental changes to zen cart....so thought I'd ask someone who is integrally involved.
Thanks again,
Jeff
Jeff, that YourStore template is very, very invasive. I'll suggest that you search through your storefront files for xsell to see where it's being used other than the plugin itself.Quote:
Originally Posted by NWCE
Hi lat9,
Thanks for you help and suggestion on searching my storefront files. I will definitely do this and post back.
Thanks again,
Jeff
Hi lat9,
My apologies and thank you for you help......the module works perfectly!! After several hours of trying this and searching that, I tried installing the old Multi Cross Sell v 1.03 module from my zen cart v.1.5.5 into my test v.1.5.7 and it worked and displayed correctly. I did notice that it displayed duplicate product titles but the lower one was in bold.....so it got me to thinking.
As I had not installed the images onto my v.1.5.7 test site (folder way to large with over 2300 products) I wondered if what I was seeing on my test site with your module installed with simply duplicate product titles as one is the displaying title and one was for the Image-Alt function. I removed the Multi Cross Sell and re-installed your Cross Sell Advanced II module and uploaded images for just one product into my test v.1.5.7 site. It worked!
Once again, my apologies for not realizing this earlier......and thank you once again for your help.....it is much appreciated.
Jeff
Suggestion on next push - add the link to the template modification instructions to the text readme file (or perhaps delete it entirely so you don't have to maintain two copies).
ZC 1.5.8 changes
- change ./includes/modules/xsell/category_product_selection.php to call zen_draw_pulldown_products instead of zen_draw_products_pull_down.
Otherwise works like a champ. Note that the old Related Products module no longer works with 1.5.8/PHP8 and will require significant updates.
I am pointing people to this module instead.
I'd quite forgotten that I had this in GitHub! Was that function name changed from 157 to 158? Just trying to understand the "why" for the change.Quote:
Originally Posted by swguy
Yes, the function name was changed. I submitted a PR to your repo to fix.
Yep, saw the PR but didn't understand the why.
https://github.com/zencart/zencart/pull/5439
https://github.com/zencart/zencart/pull/4083
One of the function renames from 1.5.8.
Done, now in v2.0.2 readme.htmlQuote:
Originally Posted by swguy
v2.0.2 of Cross Sell Advanced II is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2334Quote:
Originally Posted by swguy
This release provides integration with zc158; see GitHub issue #7 for additional information.
Question about the help: you said
Note: If your site is using the ZCA Bootstrap Template, don't forget to copy the file /includes/templates/bootstrap/templates/tpl_modules_xsell2_products.php to your "clone" of the template!
Didn't you mean the other way around? Something like:
Note: If your site is not using the ZCA Bootstrap Template, don't forget to copy the file /includes/templates/bootstrap/templates/tpl_modules_xsell2_products.php to your template!
Or maybe:
Note: If your site is using a clone of the ZCA Bootstrap Template, don't forget to copy the file /includes/templates/bootstrap/templates/tpl_modules_xsell2_products.php to your "clone" of the template!
The Or maybe: provides a clarification of what I intended.Quote:
Originally Posted by swguy
v2.0.3 of Cross Sell Advanced II is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2334
Corrects the admin tool's pagination, thanks to @webchills.
Note: This *might* work with zc200, but I've not tested in that environment.
Google Merchant Center next doesn't like " in the titles.
So I use HTML entities like " instead of "
The cross sell items (related products) unfortunately show " instead of "
See -> https://roller-aus-blech.com/index.p...50&language=en
Thank you for updating this plugin lat9!
I am installing it in a v.2.1 upgrade and noticed that after uploading the files all installed correctly, I received the install message at the top of my Admin and I have the config areas in Admin.
When I go to edit the tpl_xxx_info_display.php files the tpl_document_general_info_display.php, tpl_document_product_info_display.php,and the tpl_product_free_shipping_info_display.php are very changed files from past Zen Cart versions.
There isn't the :
<!--eof Product URL -->
<!--bof also purchased products module-->
sections in these files any longer. When I simply added the code to the end of the files, it didn't throw any errors, but my index page now shows nothing in the center column (no products, no featured, no specials) just a white blank.....and again no error in the Debug Logs.
I have added the code to my tpl_product_info_display.php in the correct spot.
If I click on a category to go in, I then see the products in this category in my centre column as normal.
Any ideas on why it is not displaying on the index page???
Not without a link to the site.Quote:
Originally Posted by NWCE
The site I am working on is in my local computer as I am in the process of upgrading....unfortunately it is not on a live site.
I know this makes it extra difficult to diagnose....I only have the stock Zen Cart v.2.1 database installed with demo products to insure that my current live site database isn't causing any issues.
I do have a custom template, and the only file that is in my custom template (all others uploaded from this plugin are inside the stock Zen Cart) is the tpl_product_info_display.php which is the stock file with the added Cross Sell Advanced coding near the end of the file.
All was working and displaying properly on the development site before installing this plugin...and I am only installing one plugin at a time....testing and using it to insure to errors before moving onto the next.
Does this help?
In trying to decipher this error....the only error showing in my Debug Logs was for a plugin I have yet to install, ZX Slideshow, but is throwing an error as my Custom template file includes some code that is calling for this plugin.
I decided to uninstall the Cross Sell plugin first, (deleted all uploaded files and ran the SQL Unistall). I then installed the ZX Slideshow plugin, and everything in my Index page center column magically appeared!
I then installed the Cross Sell plugin once again, went to Admin and see it in the Admin->Config and in the Admin->Catalog.
Now when I load my site I get a total white screen with the following in the Debug Log:
[27-Jan-2025 17:05:19 UTC] Request URI: /plugin21/, IP address: 127.0.0.1, Language id 1
#0 C:\wamp64\www\new2121\includes\autoload_func.php(40): zen_debug_error_handler()
#1 C:\wamp64\www\new2121\includes\autoload_func.php(40): require_once()
#2 C:\wamp64\www\new2121\includes\application_top.php(329): require('C:\\wamp64\\www\\p...')
#3 C:\wamp64\www\new2121\index.php(25): require('C:\\wamp64\\www\\p...')
--> PHP Warning: require_once(includes/init_includes/init_xsell_config.php): Failed to open stream: No such file or directory in C:\wamp64\www\new2121\includes\autoload_func.php on line 40.
[27-Jan-2025 17:05:19 UTC] PHP Fatal error: Uncaught Error: Failed opening required 'includes/init_includes/init_xsell_config.php' (include_path='.;C:\php\pear') in C:\wamp64\www\new2121\includes\autoload_func.php:40
Stack trace:
#0 C:\wamp64\www\new2121\includes\application_top.php(329): require()
#1 C:\wamp64\www\new2121\index.php(25): require('C:\\wamp64\\www\\p...')
#2 {main}
thrown in C:\wamp64\www\new2121\includes\autoload_func.php on line 40
[27-Jan-2025 17:05:19 UTC] Request URI: /new2121/, IP address: 127.0.0.1
--> PHP Fatal error: Uncaught Error: Failed opening required 'includes/init_includes/init_xsell_config.php' (include_path='.;C:\php\pear') in C:\wamp64\www\new2121\includes\autoload_func.php:40
Stack trace:
#0 C:\wamp64\www\new2121\includes\application_top.php(329): require()
#1 C:\wamp64\www\new2121\index.php(25): require('C:\\wamp64\\www\\p...')
#2 {main}
thrown in C:\wamp64\www\new2121\includes\autoload_func.php on line 40.
[27-Jan-2025 17:05:19 UTC] Request URI: /new2121/, IP address: 127.0.0.1
--> PHP Fatal error: Uncaught Error: Failed opening required 'includes/init_includes/init_xsell_config.php' (include_path='.;C:\php\pear') in C:\wamp64\www\new2121\includes\autoload_func.php:40
Stack trace:
#0 C:\wamp64\www\new2121\includes\application_top.php(329): require()
#1 C:\wamp64\www\new2121\index.php(25): require('C:\\wamp64\\www\\p...')
#2 {main}
thrown in C:\wamp64\www\new2121\includes\autoload_func.php on line 40.
I have double checked and reuploaded the file the Admin/includes/init_includes/init_xsell_config.php without any change.
Would you be able to shed some light on where I've gone wrong??
Thanks for your help.
From the log, it appears that you've copied the /admin/includes/auto_loaders/config.xsell.php to the storefront directory /includes/auto_loaders; remove that file that's in the wrong place.
Thanks lat9 for pointing this out....sorry for the elementary mistake.
I have removed this file and it has restored my development site.
Thanks again for your help.
In doing some testing this morning now that this site is working properly....
I received this error:
--> PHP Fatal error: MySQL error 1146: Table 'new2121.zen_products_xsell' doesn't exist :: SELECT p.products_id, p.products_image, pd.products_name
FROM zen_products_xsell xp
INNER JOIN zen_products p
ON p.products_id = xp.xsell_id
INNER JOIN zen_products_description pd
ON pd.products_id = p.products_id
AND pd.language_id = 1
WHERE xp.products_id = 100
AND p.products_status = 1 ORDER BY xp.sort_order ASC ==> (as called by) C:\wamp64\www\new2121\includes\modules\xsell2_products.php on line 49 <== in C:\wamp64\www\new2121\includes\classes\db\mysql\query_factory.php on line 733.
I remember in a previous version several years ago that you had to manually add in this table. Is this user error once again??
Please disregard my last post (#162) above. When I logged into my Admin panel....I received the Confirmation of the install of the Cross Sell plugin.....so this error I posted above was only due to my previous misplacement of a file.
It all works without error now.
Sorry 'bout that.