Printable Price list :: support thread

Printable View

Show 100 post(s) from this thread on one page

31 Dec 2023, 10:01 PM
pixodaros

Re: Printable Price list :: zc158

A typical error message from /logs

Code:

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 true to display links to the currently-enabled profiles on the pricelist page.', 37, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Information Sidebox Link?', 'PL_SHOW_INFO_LINK', 'true', 'Choose whether (true) or not (false) 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.
31 Dec 2023, 10:02 PM
pixodaros

Re: Printable Price list :: zc158

A typical error message from /logs

Code:

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 true to display links to the currently-enabled profiles on the pricelist page.', 37, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Information Sidebox Link?', 'PL_SHOW_INFO_LINK', 'true', 'Choose whether (true) or not (false) 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.
31 Dec 2023, 10:36 PM
swguy

Re: Printable Price list :: zc158

You seem to have a half-done install. Run the remove sql script and clean things up.
1 Jan 2024, 12:33 AM
dbltoe

Re: Printable Price list :: zc158

There should be a debug file in the logs folder.

Post it here using the # but make sure to hide any admin info.
1 Jan 2024, 06:38 AM
pixodaros

Re: Printable Price list :: zc158

The text which I quoted was found in several dozen files with names like WEBROOT/logs/myDEBUG-adm-20231231-xxxx-xxxx-error.log The lines from "PHP Fatal Error" onwards always seemed to be the same. Here is the full, censored text of one file.

Code:

[31-Dec-2023 13:24:05 America/Vancouver] Request URI: /1.5.8a/MY_ADMIN/, IP address: 75.156.33.72, Language id 1 #1 trigger_error() called at [/WEBROOT/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/init_includes/init_price_list_admin.php:44] #5 require_once(/WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php) called at [/WEBROOT/includes/autoload_func.php:40] #6 require(/WEBROOT/includes/autoload_func.php) called at [/WEBROOT/MY_ADMIN/includes/application_top.php:42] #7 require(/WEBROOT/MY_ADMIN/includes/application_top.php) called at [/WEBROOT/MY_ADMIN/home.php:9] #8 require(/WEBROOT/MY_ADMIN/home.php) called at [/WEBROOT/MY_ADMIN/index.php:11] --> 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 true to display links to the currently-enabled profiles on the pricelist page.', 37, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Information Sidebox Link?', 'PL_SHOW_INFO_LINK', 'true', 'Choose whether (true) or not (false) 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) /WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php on line 44 <== in /WEBROOT/includes/classes/db/mysql/query_factory.php on line 667.

I notice that the Request URI is relative to public_html not relative to webroot.

My current strategy is to give up on installing this plugin and just use Image Handler 5 and the latin1 to utf8 conversion tool.
1 Jan 2024, 01:17 PM
swguy

Re: Printable Price list :: zc158

Some of the last few posts got caught by our spam filter. Please see post #703:

> You seem to have a half-done install. Run the remove sql script and clean things up.

for instructions on how to fix this issue.
1 Jan 2024, 10:10 PM
pixodaros

Re: Printable Price list :: zc158

Quote:

Originally Posted by swguy

Some of the last few posts got caught by our spam filter. Please see post #703:

> You seem to have a half-done install. Run the remove sql script and clean things up.

for instructions on how to fix this issue.

Ok, I see that the post with the first quote from the logs may have been blocked.

I ran pricelist_remove.sql on the test database. When I log in to the test instance admin interface, I still get a blank page and the message "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."

After I ran pricelist_remove.sql, SELECT * FROM configuration WHERE configuration_key LIKE 'PL_%'; returned nothing

After I logged in to the admin interface and saw the blank screen with the warning, I repeated the same query and saw 41 entries with configuation keys such as PL_ADDTOCART_TARGET_1 and PL_DEBUG_1

I do not see instructions for uninstalling the plugin in the readme.md or readme.html

My focus is now on creating a new test instance with the database upgrade script and Image Handler 5. I can't put in any more tIme to get PPL working with the site upgraded from 1.5.4 to 1.5.8. I am willing to provide BRIEF additional information to help the maintainers debug this.
2 Jan 2024, 06:25 AM
OldNGrey

Re: Printable Price list :: zc158

I think some of the problems discussed here are from using version of PPL from the plugins downloads on zc158a. That version is for zc157.

In posting #684 of this thread I gave links to my GitHub which has versions suitable for zc157 and zc158.
The source files in my GitHub https://github.com/OldNGreyBMR/printable_price_list to include files for both ZC157 and ZC158.

With Lat9's consent I'll package up my version to a zip file and submit it.
3 Jan 2024, 12:12 AM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by OldNGrey

I think some of the problems discussed here are from using version of PPL from the plugins downloads on zc158a. That version is for zc157.

In posting #684 of this thread I gave links to my GitHub which has versions suitable for zc157 and zc158.
The source files in my GitHub https://github.com/OldNGreyBMR/printable_price_list to include files for both ZC157 and ZC158.

With Lat9's consent I'll package up my version to a zip file and submit it.

Just to keep a single repository to avoid confusion, how about submitting a PR to my GitHub with your changes?
3 Jan 2024, 01:16 AM
pixodaros

Re: Printable Price list :: zc158

Sometime in the next week or two, I would be willing to try the fix by OldNGrey on a test install of my "1.5.4 to 1.5.8 database-only upgrade" and see if that fixes it for me.
6 Jan 2024, 01:53 AM
pixodaros

Re: Printable Price list :: zc158

Quote:

Originally Posted by pixodaros

Sometime in the next week or two, I would be willing to try the fix by OldNGrey on a test install of my "1.5.4 to 1.5.8 database-only upgrade" and see if that fixes it for me.

I had a look at the 1.5.8 download on Github. Two of the README files have BMH in the names and includes/modules/sideboxes/YOUR_TEMPLATE/information.php in the official PPL 3.0.1 download becomes includes/modules/sideboxs/bmh_bootstrap/information.php in the OldNGrey 1.5.8 folder on Github.

Should we rename the folder with information.php to MY_TEMPLATE?

includes/extra_definitions in the original readme.html becomes includes/extra_datafiles but I think that is a 1.5.7 or 1.5.8 thing
7 Jan 2024, 01:59 PM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by lat9

Just to keep a single repository to avoid confusion, how about submitting a PR to my GitHub with your changes?

@OldNGrey, if you're willing (as you've shown) to take the plugin over, I'd be more than happy to point the plugin's GitHub link to your repo.
10 Jan 2024, 04:26 AM
OldNGrey

Re: Printable Price list :: zc158

Quote:

Originally Posted by pixodaros

I had a look at the 1.5.8 download on Github. Two of the README files have BMH in the names and includes/modules/sideboxes/YOUR_TEMPLATE/information.php in the official PPL 3.0.1 download becomes includes/modules/sideboxs/bmh_bootstrap/information.php in the OldNGrey 1.5.8 folder on Github.

Should we rename the folder with information.php to MY_TEMPLATE?

includes/extra_definitions in the original readme.html becomes includes/extra_datafiles but I think that is a 1.5.7 or 1.5.8 thing

Sorry! My mistake. I placed part of my working files in Github and not the generic set for use by everyone else.

I have updated GitHub to display the correct folders names eg YOUR_ADMIN and YOUR_TEMPLATE as well as updating the readme files.
10 Jan 2024, 06:16 AM
OldNGrey

Re: Printable Price list :: zc158

Quote:

Originally Posted by lat9

@OldNGrey, if you're willing (as you've shown) to take the plugin over, I'd be more than happy to point the plugin's GitHub link to your repo.

Thanks but don't change it too soon. I'm still getting my head around GitHub and managed to blow away all my local repository changes for Printable Price List.
Just manually rebuilding it backup on GitHub with the latest changes.
10 Jan 2024, 09:09 AM
pixodaros

Re: Printable Price list :: zc158

Quote:

Originally Posted by OldNGrey

Sorry! My mistake. I placed part of my working files in Github and not the generic set for use by everyone else.

I have updated GitHub to display the correct folders names eg YOUR_ADMIN and YOUR_TEMPLATE as well as updating the readme files.

Great, I will try to install that set of files using the instructions in the readme on Wednesday.
10 Jan 2024, 11:09 PM
pixodaros

Re: Printable Price list :: zc158

When I installed the zc158 files version of PPL from the latest Github and clicked a button in the Admin interface I saw:

"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."

with the following log:

Code:

[10-Jan-2024 13:58:37 America/Vancouver] Request URI: /1.5.8/MY_ADMIN/keepalive.php?_=1704923553513, IP address: MY_IP, Language id 1 #1 trigger_error() called at [/WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php:667] #2 queryFactory->show_error() called at [/WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php:634] #3 queryFactory->set_error() called at [/WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php:275] #4 queryFactory->Execute() called at [/WEBROOT/1.5.8/MY_ADMIN/includes/init_includes/init_price_list_admin.php:44] #5 require_once(/WEBROOT/1.5.8/MY_ADMIN/includes/init_includes/init_price_list_admin.php) called at [/WEBROOT/1.5.8/includes/autoload_func.php:40] #6 require(/WEBROOT/1.5.8/includes/autoload_func.php) called at [/WEBROOT/1.5.8/MY_ADMIN/includes/application_top.php:42] #7 require(/WEBROOT/1.5.8/MY_ADMIN/includes/application_top.php) called at [/WEBROOT/1.5.8/MY_ADMIN/keepalive.php:9] --> 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.0', '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 true to display links to the currently-enabled profiles on the pricelist page.', 37, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Information Sidebox Link?', 'PL_SHOW_INFO_LINK', 'true', 'Choose whether (true) or not (false) 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) /WEBROOT/1.5.8/MY_ADMIN/includes/init_includes/init_price_list_admin.php on line 44 <== in /WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php on line 667.

This plugin is not important enough to the site owner for me to be able to spend much time debugging this, but I should be able to keep up the buggy version for a day or two if you want more information or have a suggested fix.
10 Jan 2024, 11:48 PM
pixodaros

Re: Printable Price list :: zc158

(second reply today, first reply describes error and log)

I had a look at table 'configuration' on a clean copy of the database. It does not seem to contain anything that begins with 'PL_' So this does not seem to be an issue with database entries left over from the ZC 1.5.4 install which had PPL

Similar errors from 2006 https://www.zen-cart.com/showthread....EFAULT_PROFILE and 2007 https://www.zen-cart.com/showthread....EFAULT_PROFILE

I don't know anything about unq_config_key_zen and I don't see it in init_price_list_admin.php or the other PHP files mentioned. If I knew more PHP or this was my shop I might be able to put in more time.

Edit: until my first post appears here is a copy of the log

Code:

[10-Jan-2024 13:58:37 America/Vancouver] Request URI: /1.5.8/MY_ADMIN/keepalive.php?_=1704923553513, IP address: MY_IP, Language id 1 #1 trigger_error() called at [/WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php:667] #2 queryFactory->show_error() called at [/WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php:634] #3 queryFactory->set_error() called at [/WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php:275] #4 queryFactory->Execute() called at [/WEBROOT/1.5.8/MY_ADMIN/includes/init_includes/init_price_list_admin.php:44] #5 require_once(/WEBROOT/1.5.8/MY_ADMIN/includes/init_includes/init_price_list_admin.php) called at [/WEBROOT/1.5.8/includes/autoload_func.php:40] #6 require(/WEBROOT/1.5.8/includes/autoload_func.php) called at [/WEBROOT/1.5.8/MY_ADMIN/includes/application_top.php:42] #7 require(/WEBROOT/1.5.8/MY_ADMIN/includes/application_top.php) called at [/WEBROOT/1.5.8/MY_ADMIN/keepalive.php:9] --> 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.0', '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 true to display links to the currently-enabled profiles on the pricelist page.', 37, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Information Sidebox Link?', 'PL_SHOW_INFO_LINK', 'true', 'Choose whether (true) or not (false) 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) /WEBROOT/1.5.8/MY_ADMIN/includes/init_includes/init_price_list_admin.php on line 44 <== in /WEBROOT/1.5.8/includes/classes/db/mysql/query_factory.php on line 667.
11 Jan 2024, 07:15 AM
OldNGrey

1 Attachment(s)

Re: Printable Price list :: zc158
Quote:

Originally Posted by pixodaros

(second reply today, first reply describes error and log)
I had a look at table 'configuration' on a clean copy of the database. It does not seem to contain anything that begins with 'PL_' So this does not seem to be an issue with database entries left over from the ZC 1.5.4 install which had PPL

Quote:

Originally Posted by pixodaros

I don't know anything about unq_config_key_zen and I don't see it in init_price_list_admin.php or the other PHP files mentioned. If I knew more PHP or this was my shop I might be able to put in more time.

unq_config_key_zen is the name of an index on the configuration table. This be seen with phpMyAdmin when looking at the table structure.
Attachment 20446

You may have something unusual in your database.
1. I would run the pricelist_remove sql script to remove the PL_ entries in the configuration table.
2. Then check with phpmyadmin that the PL_ values have been removed.
Code:

SELECT * FROM `zen_configuration` WHERE `configuration_title` like "PL_%"

Code:

order by `configuration_title`;

If there are any errors shown in zencart logs or phpmyadmin please record them

If all is OK then install the files for printable price list.

On a Vanilla install of zc158a it works out of the box with PHP versions from 7.4 up. If the remove script is run the values are removed from the database and then if admin > configuration > Printable Price-list is selected they are installed.
11 Jan 2024, 08:35 AM
pixodaros

Re: Printable Price list :: zc158

Just to confirm, are you suggesting restoring the backup, then running the pricelist remove SQL script, then installing PPL?

On the broken ZC 1.5.8 install, there is no such table as zen_configuration

Code:

SELECT * FROM `zen_configuration` WHERE `configuration_title` like "PL_%";

returns nothing

On the 1.5.4 install,

Code:

SELECT * FROM configuration WHERE configuration_key LIKE 'PL_%';

returns 119 lines. I could repeat that query on a clean 1.5.8 install.
11 Jan 2024, 10:25 PM
OldNGrey

Re: Printable Price list :: zc158

If you are the adding the Printable -pricelist plugin to new zc158a installation with a clean zc158a database when checking the database content use the same sql query

Code:

SELECT * FROM configuration WHERE configuration_key LIKE 'PL_%';

If you have used a table name prefix like "zen_" you will change the table name in the query to suit eg

Code:

SELECT * FROM `zen_configuration`

If you get errors post them here.

Always apply and test changes in a test environment first.
11 Jan 2024, 11:12 PM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by pixodaros

Just to confirm, are you suggesting restoring the backup, then running the pricelist remove SQL script, then installing PPL?

On the broken ZC 1.5.8 install, there is no such table as zen_configuration

Code:

SELECT * FROM `zen_configuration` WHERE `configuration_title` like "PL_%";

returns nothing

On the 1.5.4 install,

Code:

SELECT * FROM configuration WHERE configuration_key LIKE 'PL_%';

returns 119 lines. I could repeat that query on a clean 1.5.8 install.

Wherever that line is, it should be coded as

"SELECT * FROM " . TABLE_CONFIGURATION . " WHERE configuration_key LIKE 'PL_%'"
12 Jan 2024, 08:52 PM
pixodaros

Re: Printable Price list :: zc158

Quote:

Originally Posted by OldNGrey

If you are the adding the Printable -pricelist plugin to new zc158a installation with a clean zc158a database when checking the database content use the same sql query

Code:

SELECT * FROM configuration WHERE configuration_key LIKE 'PL_%';

If you have used a table name prefix like "zen_" you will change the table name in the query to suit eg

Code:

SELECT * FROM `zen_configuration`

If you get errors post them here.

Always apply and test changes in a test environment first.

Some of the issues seem to be related to the old database I am importing, so a clean test environment would not help, but I agree its always wise to backup site and database before trying (and to test everything before you take a site live).

# Trial no. 1

Ran the pricelist_remove.sql script on my ZC 1.5.8 test install

Logged in to admin on the test install and saw a blank screen with the text "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."

Checked the logs on the test install.

Code:

[11-Jan-2024 16:33:43 America/Vancouver] Request URI: /1.5.8/MY_ADMIN/, IP address: 75.156.33.72, Language id 1 #1 trigger_error() called at [/WEBROOT/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/init_includes/init_price_list_admin.php:155] #5 require_once(/WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php) called at [/WEBROOT/includes/autoload_func.php:40] #6 require(/WEBROOT/includes/autoload_func.php) called at [/WEBROOT/MY_ADMIN/includes/application_top.php:42] #7 require(/WEBROOT/MY_ADMIN/includes/application_top.php) called at [/WEBROOT/MY_ADMIN/home.php:9] #8 require(/WEBROOT/MY_ADMIN/home.php) called at [/WEBROOT/MY_ADMIN/index.php:11] --> PHP Fatal error: 1062:Duplicate entry 'PL_HEADER_LOGO_1' 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 ('Enable Profile?', 'PL_ENABLE_1', 'true', 'Choose true to enable this price-list profile to be used on the pricelist page.', 42, 10, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Group Name', 'PL_GROUP_NAME_1', '', 'Set this field to a Group Name (see Customers->Group Pricing) to enable this profile only for customers in that group. Leave the field empty for the profile to apply to all customers.', 42, 15, NULL, NULL, now()), ('Profile Name', 'PL_PROFILE_NAME_1', 'Product Profile 1', 'Give this profile a name.', 42, 20, NULL, NULL, now()), ('Display Linked Products?', 'PL_USE_MASTER_CATS_ONLY_1', 'false', 'Should products be listed under all linked categories (false) or only under their master-category (true)?', 42, 32, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Selections?', 'PL_SHOW_BOXES_1', 'true', 'Set this value to true to display language and currency selections as well as a categories dropdown menu.', 42, 35, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Categories Dropdown: Main Only?', 'PL_CATEGORY_TREE_MAIN_CATS_ONLY_1', 'true', 'Should the categories dropdown menu contain only the main categories? If set to false, then all categories are displayed. Note: This setting is ignored if Show Selections is set to false', 42, 37, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Main Categories: New Page', 'PL_MAINCATS_NEW_PAGE_1', 'false', 'If true, main categories on the printed price-list will start on a new page.', 42, 40, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('No Wrap', 'PL_NOWRAP_1', 'false', 'To enable or disable wrapping on screen (nowrap is easier for debugging)', 42, 60, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Model', 'PL_SHOW_MODEL_1', 'true', 'Display each product\'s model number in a separate column?', 42, 100, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Manufacturer', 'PL_SHOW_MANUFACTURER_1', 'true', 'Display each product\'s manufacturer in a separate column?', 42, 105, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Weight', 'PL_SHOW_WEIGHT_1', 'false', 'Display each product\'s weight in a separate column?', 42, 110, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Stock-on-Hand', 'PL_SHOW_SOH_1', 'false', 'Display each product\'s stock-on-hand in a separate column?', 42, 115, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Notes (A)', 'PL_SHOW_NOTES_A_1', 'false', 'Display an empty column for each product, allowing the customer to make notes?', 42, 120, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Notes (B)', 'PL_SHOW_NOTES_B_1', 'false', 'Display another empty column for each product, allowing the customer to make notes?', 42, 125, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Price', 'PL_SHOW_PRICE_1', 'true', 'Display each product\'s price, including or excluding tax based on your shop\'s tax-configuration settings)?', 42, 130, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Price (ex)', 'PL_SHOW_TAX_FREE_1', 'false', 'Display each product\'s tax-free price in a separate column?', 42, 135, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Specials Prices?', 'PL_SHOW_SPECIAL_PRICE_1', 'true', 'Display each product\'s "special" price? If true, the script will execute 4 extra queries per product!', 42, 140, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Specials Expiry?', 'PL_SHOW_SPECIAL_DATE_1', 'false', 'Show special price expiry date? This works only for specials (not for pricing by attributes and sales). Executes one extra query per special if enabled.', 42, 145, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Add-to-Cart', 'PL_SHOW_ADDTOCART_BUTTON_1', 'false', 'Display an add-to-cart button for each product? If the product has attributes, a "More info" link displays instead.', 42, 150, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Add-to-Cart Button Target', 'PL_ADDTOCART_TARGET_1', 'Cartpage', 'How to react to an Add-to-Cart button click: Cartpage sends all results to the same web page, _self sends result to the current page and _blank sends each result to a new page.', 42, 155, NULL, 'zen_cfg_select_option(array(\'Cartpage\', \'_self\', \'_blank\'),', now()), ('Show Product Images?', 'PL_SHOW_IMAGE_1', 'false', 'Display each product\'s image?', 42, 160, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Image Height', 'PL_IMAGE_PRODUCT_HEIGHT_1', '80', 'If the product images are to be displayed, what is the height of each image?', 42, 165, NULL, NULL, now()), ('Image Width', 'PL_IMAGE_PRODUCT_WIDTH_1', '100', 'If the product images are to be displayed, what is the width of each image?', 42, 170, NULL, NULL, now()), ('Show Descriptions?', 'PL_SHOW_DESCRIPTION_1', 'false', 'Display each product\'s description?', 42, 175, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Truncate Descriptions?', 'PL_TRUNCATE_DESCRIPTION_1', '300', 'If Show Descriptions? is set to true and this field is a value other than 0 or blank, product descriptions will be truncated to this length — HTML will be stripped.', 42, 180, NULL, NULL, now()), ('Show Inactive Products and Categories?', 'PL_SHOW_INACTIVE_1', 'false', 'Set this value to true to include disabled products and categories in the list.', 42, 200, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Sort By: Field', 'PL_SORT_PRODUCTS_BY_1', 'products_price', 'How products are sorted within a category', 42, 210, NULL, 'zen_cfg_select_option(array(\'products_name\', \'products_price\', \'products_model\' ),', now()), ('Sort By: Asc/Desc', 'PL_SORT_ASC_DESC_1', 'asc', 'Sort ascending or descending', 42, 215, NULL, 'zen_cfg_select_option(array(\'asc\', \'desc\' ),', now()), ('Enable Debug?', 'PL_DEBUG_1', 'false', 'If true debug info is shown', 42, 200, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Store Logo On-Screen?', 'PL_HEADER_LOGO_1', 'true', 'Display the store\'s logo at the top of the screen?', 42, 260, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Page Headers?', 'PL_SHOW_PRICELIST_PAGE_HEADERS_1', 'false', 'If true the page headers on each page are shown (screen and print).', 42, 270, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Page Footers?', 'PL_SHOW_PRICELIST_PAGE_FOOTERS_1', 'true', 'If true the page footers on each page are shown (screen and print).', 42, 280, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()) ==> (as called by) /WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php on line 155 <== in /WEBROOT/includes/classes/db/mysql/query_factory.php on line 667.

# Trial no. 2

Looked at a second test install on the same host, its broken after I tried to install PPL.

# Trial no. 3

Logged in to a test install on my own host with clean data. It has traces of a failed install of PPL.

# Trial no. 4

Created a clean install of ZC 1.5.8a on my own host with a new empty database. Site appears blank after the 'remove zc_install' phase.

Trial no. 5 will come after a meeting
12 Jan 2024, 10:49 PM
pixodaros

Re: Printable Price list :: zc158

# Trial no. 5

Hypothesis: the problem is caused because the imported database has traces of a ZC 1.5.4 install with PPL and the installation process tries to INSERT things which already exist

Restored my modified install of ZC 1.5.8 with imported data from ZC 1.5.4

SELECT * FROM configuration WHERE configuration_key LIKE 'PL_%'; returns 119 lines
SELECT * FROM configuration_group WHERE configuration_group_title='Printable Price-list'; returns 1 line
SELECT * FROM configuration_group WHERE configuration_group_title LIKE 'Price-list Profile-%'; returns 3 lines
SELECT * FROM admin_pages WHERE page_key LIKE 'config%Pricelist%'; returns 4 lines

Ran the following SQL commands in phpMyAdmin:

DELETE FROM configuration WHERE configuration_key LIKE 'PL_%';
DELETE FROM configuration_group WHERE configuration_group_title='Printable Price-list';
DELETE FROM configuration_group WHERE configuration_group_title LIKE 'Price-list Profile-%';
DELETE FROM admin_pages WHERE page_key LIKE 'config%Pricelist%';

Uploaded ONG's fix to PPL, extracted it, copied the folders into the appropriate folder in my ZC 1.5.8 install with the upgraded data from 1.5.8, and clicked any button in the admin interface:

Blank screen 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.

Three logged errors. The SQL commands are very long so I will only quote one in full.

Code:

[12-Jan-2024 13:39:58 America/Vancouver] Request URI: /1.5.8/MY_ADMIN/, IP address: 172.218.225.67, Language id 1 #1 trigger_error() called at [/WEBROOT/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/init_includes/init_price_list_admin.php:155] #5 require_once(/WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php) called at [/WEBROOT/includes/autoload_func.php:40] #6 require(/WEBROOT/includes/autoload_func.php) called at [/WEBROOT/MY_ADMIN/includes/application_top.php:42] #7 require(/WEBROOT/MY_ADMIN/includes/application_top.php) called at [/WEBROOT/MY_ADMIN/home.php:9] #8 require(/WEBROOT/MY_ADMIN/home.php) called at [/WEBROOT/MY_ADMIN/index.php:11] --> PHP Fatal error: 1062:Duplicate entry 'PL_HEADER_LOGO_1' 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 ('Enable Profile?', 'PL_ENABLE_1', 'true', 'Choose true to enable this price-list profile to be used on the pricelist page.', 42, 10, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Group Name', 'PL_GROUP_NAME_1', '', 'Set this field to a Group Name (see Customers->Group Pricing) to enable this profile only for customers in that group. Leave the field empty for the profile to apply to all customers.', 42, 15, NULL, NULL, now()), ('Profile Name', 'PL_PROFILE_NAME_1', 'Product Profile 1', 'Give this profile a name.', 42, 20, NULL, NULL, now()), ('Display Linked Products?', 'PL_USE_MASTER_CATS_ONLY_1', 'false', 'Should products be listed under all linked categories (false) or only under their master-category (true)?', 42, 32, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Selections?', 'PL_SHOW_BOXES_1', 'true', 'Set this value to true to display language and currency selections as well as a categories dropdown menu.', 42, 35, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Categories Dropdown: Main Only?', 'PL_CATEGORY_TREE_MAIN_CATS_ONLY_1', 'true', 'Should the categories dropdown menu contain only the main categories? If set to false, then all categories are displayed. Note: This setting is ignored if Show Selections is set to false', 42, 37, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Main Categories: New Page', 'PL_MAINCATS_NEW_PAGE_1', 'false', 'If true, main categories on the printed price-list will start on a new page.', 42, 40, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('No Wrap', 'PL_NOWRAP_1', 'false', 'To enable or disable wrapping on screen (nowrap is easier for debugging)', 42, 60, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Model', 'PL_SHOW_MODEL_1', 'true', 'Display each product\'s model number in a separate column?', 42, 100, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Manufacturer', 'PL_SHOW_MANUFACTURER_1', 'true', 'Display each product\'s manufacturer in a separate column?', 42, 105, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Weight', 'PL_SHOW_WEIGHT_1', 'false', 'Display each product\'s weight in a separate column?', 42, 110, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Stock-on-Hand', 'PL_SHOW_SOH_1', 'false', 'Display each product\'s stock-on-hand in a separate column?', 42, 115, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Notes (A)', 'PL_SHOW_NOTES_A_1', 'false', 'Display an empty column for each product, allowing the customer to make notes?', 42, 120, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Notes (B)', 'PL_SHOW_NOTES_B_1', 'false', 'Display another empty column for each product, allowing the customer to make notes?', 42, 125, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Price', 'PL_SHOW_PRICE_1', 'true', 'Display each product\'s price, including or excluding tax based on your shop\'s tax-configuration settings)?', 42, 130, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Price (ex)', 'PL_SHOW_TAX_FREE_1', 'false', 'Display each product\'s tax-free price in a separate column?', 42, 135, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Specials Prices?', 'PL_SHOW_SPECIAL_PRICE_1', 'true', 'Display each product\'s "special" price? If true, the script will execute 4 extra queries per product!', 42, 140, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Specials Expiry?', 'PL_SHOW_SPECIAL_DATE_1', 'false', 'Show special price expiry date? This works only for specials (not for pricing by attributes and sales). Executes one extra query per special if enabled.', 42, 145, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Columns: Add-to-Cart', 'PL_SHOW_ADDTOCART_BUTTON_1', 'false', 'Display an add-to-cart button for each product? If the product has attributes, a "More info" link displays instead.', 42, 150, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Add-to-Cart Button Target', 'PL_ADDTOCART_TARGET_1', 'Cartpage', 'How to react to an Add-to-Cart button click: Cartpage sends all results to the same web page, _self sends result to the current page and _blank sends each result to a new page.', 42, 155, NULL, 'zen_cfg_select_option(array(\'Cartpage\', \'_self\', \'_blank\'),', now()), ('Show Product Images?', 'PL_SHOW_IMAGE_1', 'false', 'Display each product\'s image?', 42, 160, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Image Height', 'PL_IMAGE_PRODUCT_HEIGHT_1', '80', 'If the product images are to be displayed, what is the height of each image?', 42, 165, NULL, NULL, now()), ('Image Width', 'PL_IMAGE_PRODUCT_WIDTH_1', '100', 'If the product images are to be displayed, what is the width of each image?', 42, 170, NULL, NULL, now()), ('Show Descriptions?', 'PL_SHOW_DESCRIPTION_1', 'false', 'Display each product\'s description?', 42, 175, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Truncate Descriptions?', 'PL_TRUNCATE_DESCRIPTION_1', '300', 'If Show Descriptions? is set to true and this field is a value other than 0 or blank, product descriptions will be truncated to this length — HTML will be stripped.', 42, 180, NULL, NULL, now()), ('Show Inactive Products and Categories?', 'PL_SHOW_INACTIVE_1', 'false', 'Set this value to true to include disabled products and categories in the list.', 42, 200, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Sort By: Field', 'PL_SORT_PRODUCTS_BY_1', 'products_price', 'How products are sorted within a category', 42, 210, NULL, 'zen_cfg_select_option(array(\'products_name\', \'products_price\', \'products_model\' ),', now()), ('Sort By: Asc/Desc', 'PL_SORT_ASC_DESC_1', 'asc', 'Sort ascending or descending', 42, 215, NULL, 'zen_cfg_select_option(array(\'asc\', \'desc\' ),', now()), ('Enable Debug?', 'PL_DEBUG_1', 'false', 'If true debug info is shown', 42, 200, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Store Logo On-Screen?', 'PL_HEADER_LOGO_1', 'true', 'Display the store\'s logo at the top of the screen?', 42, 260, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Page Headers?', 'PL_SHOW_PRICELIST_PAGE_HEADERS_1', 'false', 'If true the page headers on each page are shown (screen and print).', 42, 270, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()), ('Show Page Footers?', 'PL_SHOW_PRICELIST_PAGE_FOOTERS_1', 'true', 'If true the page footers on each page are shown (screen and print).', 42, 280, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),', now()) ==> (as called by) /WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php on line 155 <== in /WEBROOT/includes/classes/db/mysql/query_factory.php on line 667

Code:

[12-Jan-2024 13:39:54 America/Vancouver] Request URI: /1.5.8/MY_ADMIN/, IP address: 172.218.225.67, Language id 1 #1 trigger_error() called at [/WEBROOT/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/init_includes/init_price_list_admin.php:155] #5 require_once(/WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php) called at [/WEBROOT/includes/autoload_func.php:40] #6 require(/WEBROOT/includes/autoload_func.php) called at [/WEBROOT/MY_ADMIN/includes/application_top.php:42] #7 require(/WEBROOT/MY_ADMIN/includes/application_top.php) called at [/WEBROOT/MY_ADMIN/home.php:9] #8 require(/WEBROOT/MY_ADMIN/home.php) called at [/WEBROOT/MY_ADMIN/index.php:11] --> PHP Fatal error: 1062:Duplicate entry 'PL_HEADER_LOGO_1' for key 'unq_config_key_zen' :: INSERT INTO configuration ...

Code:

[12-Jan-2024 13:39:51 America/Vancouver] Request URI: /1.5.8/MY_ADMIN/keepalive.php?_=1705095253356, IP address: 172.218.225.67, Language id 1 #1 trigger_error() called at [/WEBROOT/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/init_includes/init_price_list_admin.php:155] #5 require_once(/WEBROOT/MY_ADMIN/includes/init_includes/init_price_list_admin.php) called at [/WEBROOT/includes/autoload_func.php:40] #6 require(/WEBROOT/includes/autoload_func.php) called at [/WEBROOT/MY_ADMIN/includes/application_top.php:42] #7 require(/WEBROOT/MY_ADMIN/includes/application_top.php) called at [/WEBROOT/MY_ADMIN/keepalive.php:9] --> PHP Fatal error: 1062:Duplicate entry 'PL_HEADER_LOGO_1' for key 'unq_config_key_zen' :: INSERT INTO configuration ...

I will double-check with the client but at this point I think I will abandon this plugin.
13 Jan 2024, 01:32 AM
OldNGrey

Re: Printable Price list :: zc158

When you imported the zc154 data into the zc158a database did you run zc_install to update the database structure to 158a and check each upgrade step was completed successfully without error?

Are you working on a clean install of zc158a files or have you copied some of the old zc154 files over to the new installation that you are working on?

Without seeing your installation the steps I would take are:

Remove all old printable-pricelist files from the test setup
Import the zc154 data into the test zc158a installation
Run zc_install to update the database to zc158a
Resolve any issues shown in the debug files
Use the sql script in phpmyadmin to delete the "PL_" references in the configuration table. Check that all the values have been removed and that there are no errors.
copy the new zc158 files for printable-pricelist to the correct structure in zc158a
open the admin console and check that all is working as expected.
13 Jan 2024, 04:19 AM
pixodaros

Re: Printable Price list :: zc158

I followed the instructions for a database-only upgrade of the ZC 1.5.4 install, plus the additional steps to convert the database from latin-1 to utf8. I think I built the customer-facing part of the new site entirely by hand, editing the new language.whatever files to contain text from the old site and configuring other things through the Admin interface.

I might try one or two of those ideas on my own time as a service to the project but the plugin is not worth more time to the client.
19 May 2024, 10:57 PM
lat9

Re: Printable Price list :: zc158

I've got an 'encapsulated plugin' version of Printable Price List staged for release: https://github.com/lat9/printable_price_list/tree/4.0.0

It requires Zen Cart 1.5.8a or later (i.e. 2.0.0 and 2.0.1 at this time) but should make its use (and updates) easier going forward.

If you're upgrading from a previous version be sure to read the various Wiki articles (https://github.com/lat9/printable_price_list/wiki) since you will need to remove all files associated with that prior version before installing the new one. Your existing configuration settings will be preserved.
1 Jun 2024, 01:55 PM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by lat9

I've got an 'encapsulated plugin' version of Printable Price List staged for release: https://github.com/lat9/printable_price_list/tree/4.0.0

It requires Zen Cart 1.5.8a or later (i.e. 2.0.0 and 2.0.1 at this time) but should make its use (and updates) easier going forward.

If you're upgrading from a previous version be sure to read the various Wiki articles (https://github.com/lat9/printable_price_list/wiki) since you will need to remove all files associated with that prior version before installing the new one. Your existing configuration settings will be preserved.

Printable Price List, v4.0.0, is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=173

This version is released as a Zen Cart encapsulated plugin.

It's been validated with zc158a and the zc200 (and later) releases. If you are upgrading from a previous, non-encapsulated, version of the plugin be sure to read the readme.html provided in the plugin's distribution since you'll need to remove the files associated with that previous version!
1 Jun 2024, 02:53 PM
swguy

Re: Printable Price list :: zc158

A nice refresh for one of our earlier plugins! Thank you @lat9.
3 Jun 2024, 03:02 PM
swguy

Re: Printable Price list :: zc158

Sugggested addition to

https://github.com/lat9/printable_pr...rior-to-v4.0.0

Be sure you also remove the *folder*

/includes/modules/pages/pricelist/

(not just the header_php.php under it).
3 Jun 2024, 03:35 PM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by swguy

Sugggested addition to

https://github.com/lat9/printable_pr...rior-to-v4.0.0

Be sure you also remove the *folder*

/includes/modules/pages/pricelist/

(not just the header_php.php under it).

Done. A similar documentation update was made to the /includes/templates/template_default/pricelist directory.
3 Jun 2024, 06:03 PM
swguy

Re: Printable Price list :: zc158

The row that has just 'product_count' isn't being handled correctly - undefined array key warnings at 167, 170, 172, 177 (in PHP 8/ZC 2.0.0).
3 Jun 2024, 08:22 PM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by swguy

The row that has just 'product_count' isn't being handled correctly - undefined array key warnings at 167, 170, 172, 177 (in PHP 8/ZC 2.0.0).

... and a copy of the logs as well as the settings for the associated price-list?
3 Jun 2024, 10:04 PM
swguy

Re: Printable Price list :: zc158

Just sent!
22 Jul 2024, 01:55 PM
lat9

Re: Printable Price list :: zc158

v4.0.1 of Printable Price list is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=173

This release corrects PHP issues identified in GitHub issues #31 and #32.
15 Nov 2024, 11:25 AM
siilike1232

Re: Printable Price list :: zc158

Using ZC v2.0.1 PPL v.4.0.1.
Cannot turn off the currency dropdown for the price list header using Configuation - Printable Price-list. I have set the Printable Price-list to False, but it is still displaying currency dropdown.
15 Nov 2024, 03:49 PM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by siilike1232

Using ZC v2.0.1 PPL v.4.0.1.
Cannot turn off the currency dropdown for the price list header using Configuation - Printable Price-list. I have set the Printable Price-list to False, but it is still displaying currency dropdown.

There is no setting through which the currency dropdown can be hidden. The setting I think you refer to (Include currency symbol in pricelist header?), simply shows/hides the currently-selected currency symbol from the table's header.
18 Nov 2024, 08:20 AM
siilike1232

Re: Printable Price list :: zc158

Quote:

Originally Posted by lat9

There is no setting through which the currency dropdown can be hidden. The setting I think you refer to (Include currency symbol in pricelist header?), simply shows/hides the currently-selected currency symbol from the table's header.

Thank you! But how can I hide/delete the currency dropdown?
18 Nov 2024, 02:08 PM
lat9

Re: Printable Price list :: zc158

Quote:

Originally Posted by siilike1232

Thank you! But how can I hide/delete the currency dropdown?

You can add the following to your template's override of PPL's /css/profile-base.css:

Code:

#currenciesPLContent { display: none; }
18 Nov 2024, 03:18 PM
siilike1232

Re: Printable Price list :: zc158

Quote:

Originally Posted by lat9

You can add the following to your template's override of PPL's /css/profile-base.css:

Code:

#currenciesPLContent { display: none; }

Thank you so much! That did the trick :)
18 May 2025, 05:29 AM
Bruce1952

Re: Printable Price list :: support thread

Hi All,

Running version 1.58a on a linux server running PHP Version: 8.1.31

Template Bootstrap Version 3.7.6

CKEditor version 5

Image Handler version 5

I am getting this error in Printable Pricelist:

memory_get_usage:17110824, memory_get_peak_usage: 17135464, queries: 1090 Fatal error: Uncaught Error: Cannot access private property queryFactory::$total_query_time in /home/xxxx/public_html/dev.outdoorking.com/zc_plugins/PrintablePriceList/v4.0.1/catalog/includes/templates/default/templates/tpl_pricelist_default.php:453 Stack trace: #0 /home/xxxx/public_html/dev.outdoorking.com/includes/templates/bootstrap/common/tpl_main_page.php(233): require() #1 /home/xxxx/public_html/dev.outdoorking.com/index.php(94): require('/home/a1ntacdk3...') #2 {main} thrown in /home/xxxx/public_html/dev.outdoorking.com/zc_plugins/PrintablePriceList/v4.0.1/catalog/includes/templates/default/templates/tpl_pricelist_default.php on line 453

Any help to fix this error message would be greatly appreciated.
18 May 2025, 02:23 PM
lat9

Re: Printable Price list :: support thread

Quote:

Originally Posted by Bruce1952

Hi All,

Running version 1.58a on a linux server running PHP Version: 8.1.31

Template Bootstrap Version 3.7.6

CKEditor version 5

Image Handler version 5

I am getting this error in Printable Pricelist:

memory_get_usage:17110824, memory_get_peak_usage: 17135464, queries: 1090 Fatal error: Uncaught Error: Cannot access private property queryFactory::$total_query_time in /home/xxxx/public_html/dev.outdoorking.com/zc_plugins/PrintablePriceList/v4.0.1/catalog/includes/templates/default/templates/tpl_pricelist_default.php:453 Stack trace: #0 /home/xxxx/public_html/dev.outdoorking.com/includes/templates/bootstrap/common/tpl_main_page.php(233): require() #1 /home/xxxx/public_html/dev.outdoorking.com/index.php(94): require('/home/a1ntacdk3...') #2 {main} thrown in /home/xxxx/public_html/dev.outdoorking.com/zc_plugins/PrintablePriceList/v4.0.1/catalog/includes/templates/default/templates/tpl_pricelist_default.php on line 453

Any help to fix this error message would be greatly appreciated.

Change line 453 of the file highlighted above from

PHP Code:

echo ', query time: ' . $db->total_query_time;

to

PHP Code:

echo ', query time: ' . $db->queryTime();

Show 100 post(s) from this thread on one page