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 <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.
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 <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.
Re: Printable Price list :: zc158
You seem to have a half-done install. Run the remove sql script and clean things up.
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.
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 <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) /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.
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.
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.
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.
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?
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.
