Printable Price list :: support thread

[pixodaros]

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 &quot;Price List&quot; 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.

[pixodaros]

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 &quot;Price List&quot; 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.

[swguy]

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

[dbltoe]

There should be a debug file in the logs folder.

Post it here using the # but make sure to hide any admin info.

[pixodaros]

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.

[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 &quot;Price List&quot; 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.

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

[pixodaros]

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.

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

[lat9]

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?

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