Printable Price list :: support thread

OldNGrey:

I have version that works with Zen Cart 1.5.8 and PHP 8.0 and 8.1. It does not work with ZC 1.5.7. The source files are located in GitHub at https://github.com/OldNGreyBMR/printable_price_list.

I appreciate all of work put in by lat9 into this and other plugins like Bootstrap so this is my contribution of the low hanging fruit.
There is not change in functionality or appearance.

The minor changes are listed in "readme_BMH_zc158.md" and the "readme.html "has been updated as well.
Thanks, OldNGrey, I'll tag your repo in mine and hopefully find a means to support both 157 and 158!

I have updated the source files in my GitHub https://github.com/OldNGreyBMR/printable_price_list to include files for both ZC157 and ZC158.

The ZC157 files will work with PHP7.4 and PHP8.0 but not PHP8.1 as strftime() is deprecated and the ZC function zcdate(), introduced in ZC158 must be used instead.

Using the github 301a version on ZC 1.5.7d pricelist is throwing several errors. Any chance one of you can help?

03-Sep-2023 09:20:03 America/Chicago] Request URI: /index.php?main_page=pricelist&profile=1, IP address: 73.67.37.4
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/includes/functions/sessions.php:77]
#5 _sess_write()
#6 session_write_close()
--> PHP Fatal error: 2014:Commands out of sync; you can't run this command now :: insert into sessions (sesskey, expiry, value)
values ('ff553641a663eb2fd4ed6974c1444bd4', 1693752243,
......
HR8ZDoyLjcwNTk5OTk5OTk5OTk5OTk2MDkyMDE0OTUzMzE5NDQ4OTc3NzA4ODE2NTI4MzIwMzEyNTs=', expiry=1693752243 ==> (as called by) /includes/functions/sessions.php on line 77 <== in /includes/classes/db/mysql/query_factory.php on line 171.

[03-Sep-2023 09:20:03 America/Chicago] Request URI: /index.php?main_page=pricelist&profile=1, IP address: 73.67.37.4
--> PHP Warning: Unknown: Cannot call session save handler in a recursive manner in Unknown on line 0.

[03-Sep-2023 09:20:03 America/Chicago] Request URI: /index.php?main_page=pricelist&profile=1, IP address: 73.67.37.4
--> PHP Warning: Unknown: Failed to write session data using user defined save handler. (session.save_path: /cache) in Unknown on line 0.

03-Sep-2023 09:20:03 America/Chicago] Request URI: /index.php?main_page=pricelist&profile=1, IP address: 73.67.37.4
--> PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 16384 bytes) in /includes/classes/db/mysql/query_factory.php on line 44.

Have you tried it on a clean install of zc1.5.7d with PHP of 7.4 without any extra plugins? I cannot induce any similar errors.

OldNGrey:

Have you tried it on a clean install of zc1.5.7d with PHP of 7.4 without any extra plugins? I cannot induce any similar errors.

I have not. I did bump my PHP memory up to 512MB which is insane, and all 3 errors stopped. So I think it has a memory leak, probably an endless loop, but I haven't had time to dig through it and find it yet.

How many active products are present on the site?

3092 :) just a few

Your report returns 3610 lines including category headings, 3483 without headings.
Is it still giving a memory error?

Not that i have seen, but I left php mem at 512.i also upgraded my server for more memory, mostly due to sql needs, so i haven't worried about it. Been working on clean build with 1.5.8a and a fresh template. It may just be an unreasonable number of products to load at once. And ya, mom got back from a PEZ convention with a ton of new and previously out of stock stuff, so numbers went way up.

Mine spits out 4790 items really quickly. You may have some bad data in a record or a mangled index.

I am having trouble installing printable price list 3.0.1 in Zen Cart 1.5.8a, I copied over the files but I don't see it in the Zen Cart Admin interface when I reload the tab or log out and log in. I found one error in editing one of the folders from the zip file (an oh instead of a zero when I replaced YOUR_ADMIN). Other than checking that the files were moved into the right places and named correctly, are there any strategies for debugging a failed plugin install?

pixodaros:

I am having trouble installing printable price list 3.0.1 in Zen Cart 1.5.8a, I copied over the files but I don't see it in the Zen Cart Admin interface when I reload the tab or log out and log in. I found one error in editing one of the folders from the zip file (an oh instead of a zero when I replaced YOUR_ADMIN). Other than checking that the files were moved into the right places and named correctly, are there any strategies for debugging a failed plugin install?
Under Admin > Configuration there should be 4 entries: Printable Price-list; Price-List Profile-1; Price-List Profile-2; Price-List Profile-3;

None of those entries has appeared. I just went through my files checking that every file listed in the readme was copied into the right folder and I think they are all there.

Edit: PHP version: 7.4.33 if it matters. I think I had trouble getting this to work on a clean 1.5.8a install with PHP 8.2 Reading backwards in this thread but 70 pages will take a while.

In the /logs folder I see an error similar to the errors reported by Gothstone in September 2023.```
[29-Dec-2023 21:13:53 America/Vancouver] Request URI: /MY_ADMIN/, IP address: 75.156.33.72, Language id 1
#1 trigger_error() called at [/MY_ROOT/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/WEBROOT/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/WEBROOT/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/WEBROOT/MY_ADMIN/includes/classes/WhosOnline.php:132]
#5 WhosOnline->retrieve() called at [/WEBROOT/MY_ADMIN//includes/classes/WhosOnline.php:218]
#6 WhosOnline->getStats() called at [/WEBROOT/MY_ADMIN/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php:15]
#7 include(/WEBROOT/MY_ADMIN/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php) called at [/WEBROOT/MY_ADMIN/index_dashboard.php:62]
#8 require(/WEBROOT/MY_ADMIN/index_dashboard.php) called at [/WEBROOT/MY_ADMIN/home.php:25]
#9 require(/WEBROOT/MY_ADMIN/home.php) called at [/WEBROOT/MY_ADMIN/index.php:11]
--> PHP Fatal error: 1267:Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' :: SELECT customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent, s.value as session_data
FROM whos_online w
LEFT OUTER JOIN sessions s ON (s.sesskey = w.session_id)
WHERE ip_address != '' AND ip_address NOT IN ('your','IP','(ADMIN)','24.69.74.129','70.71.138.184','75.156.33.72','75.156.33.72')
ORDER BY time_entry, LPAD(ip_address,11,'0') ==> (as called by) /WEBROOT/MY_ADMIN/includes/classes/WhosOnline.php on line 132 <== in /WEBROOT/includes/classes/db/mysql/query_factory.php on line 667.

I will look into the tweaked version of Printable Price List on Github and continue to read backwards in this thread

This is not a bug in PPL. It means you need to convert your database to utf8mb4.

Here's the doc:
https://docs.zen-cart.com/user/upgrading/convert_to_utf8/#pre-conversion-to-utf8

Will do. Will this fix the issues with the install or do I also need to apply the changes from Github?

Converting your database (as documented in the link above) fixes the "Illegal mixture of collations" problem, which can occur in many different operations.

This is unrelated to PPL.

I found one error in editing one of the folders from the zip file (an oh instead of a zero when I replaced YOUR_ADMIN).

When you rename a folder called "admin" or "YOUR_ADMIN", don't type the name in - copy and paste it from a known good link. That way you won't fat-finger it.

are there any strategies for debugging a failed plugin install?

Double check that you installed all 4 files into your admin folder. I just tested the admin installation in ZC 158/PHP 8.1 and it works perfectly.

I created a new test instance using the Database-only upgrade method. It worked fine at first, but when I logged in to the admin interface and moved the files for printable pricelist and refresh the admin interface I get a blank page with "WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data."

The customer-side site works just fine.

Typo in readme.html: I think "/includes/extra_definitions" should be "/includes/extra_datafiles" (at least, the ZIP file for PPL 3.0.1 has the second folder)

A typical error message from /logs

PHP Fatal error: 1062:Duplicate entry 'PL_DEFAULT_PROFILE' for key 'unq_config_key_zen' :: INSERT INTO configuration
            (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added)
         VALUES
            ('Installed Version', 'PL_INSTALLED_VERSION', 'v3.0.1', 'The plugin version currently installed.', 37 , 10, NULL , 'trim(', now()),

            ('Default Profile', 'PL_DEFAULT_PROFILE', '1', 'Choose the default profile to use.', 37 , 10, NULL , 'zen_cfg_select_option(array(\'1\', \'2\', \'3\' ),', now()),

            ('Show Profile Links?', 'PL_SHOW_PROFILES', 'true', 'Choose <em>true</em> to display links to the currently-enabled profiles on the <em>pricelist</em> page.', 37, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()),

            ('Show Information Sidebox Link?', 'PL_SHOW_INFO_LINK', 'true', 'Choose whether (<em>true</em>) or not (<em>false</em>) a "Price List" link should be shown in the Information sidebox.', 37, 30, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),', now()) ==> (as called by) /MYROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php on line 44 <== in /MYROOT/includes/classes/db/mysql/query_factory.php on line 667.

That PL_DEFAULT_PROFILE shows up in a few threads about PPL.

I could try converting from latin-1 to utf8mb4 first and then installing PPL.

I have been trying to balance not posting too often and documenting what I do off my own scratchpad.

A typical error message from /logs

PHP Fatal error: 1062:Duplicate entry 'PL_DEFAULT_PROFILE' for key 'unq_config_key_zen' :: INSERT INTO configuration
            (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added)
         VALUES
            ('Installed Version', 'PL_INSTALLED_VERSION', 'v3.0.1', 'The plugin version currently installed.', 37 , 10, NULL , 'trim(', now()),

            ('Default Profile', 'PL_DEFAULT_PROFILE', '1', 'Choose the default profile to use.', 37 , 10, NULL , 'zen_cfg_select_option(array(\'1\', \'2\', \'3\' ),', now()),

            ('Show Profile Links?', 'PL_SHOW_PROFILES', 'true', 'Choose <em>true</em> to display links to the currently-enabled profiles on the <em>pricelist</em> page.', 37, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()),

            ('Show Information Sidebox Link?', 'PL_SHOW_INFO_LINK', 'true', 'Choose whether (<em>true</em>) or not (<em>false</em>) a "Price List" link should be shown in the Information sidebox.', 37, 30, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),', now()) ==> (as called by) /MYROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php on line 44 <== in /MYROOT/includes/classes/db/mysql/query_factory.php on line 667.

That PL_DEFAULT_PROFILE shows up in a few threads about PPL.

I could try converting from latin-1 to utf8mb4 first and then installing PPL.

I have been trying to balance not posting too often and documenting what I do off my own scratchpad.