Thanks. Didn't know there was a github for it. :)
Printable View
Thanks. Didn't know there was a github for it. :)
I've installed that version here, but pages don't seem to break when printing or creating a pdf. Is anyone experiencing this? Please advise.Quote:
Originally Posted by lat9
What browser? I get a 5-page printout using FireFox.
I get a 3-pages printout with all browsers Attachment 15499Quote:
Originally Posted by lat9
OK, I went back and checked IE-11 (4 pages), FireFox (4 pages) and Chrome (not working, 3 pages, all run together). Chrome's always been a bug-a-boo regarding the CSS-based print controls; I'll investigate further.
Thanks for checking and investigating. I've tried with another PC and the pages break all right with Safari, Firefox and Explorer. They do not break with Opera and Chrome.Quote:
Originally Posted by lat9
I just found an article that indicates that Chrome (I'm guessing Opera as well) doesn't honor the page-break CSS controls if the control is present on a table element (like a <tr> which is what's currently being used by PPL). Knowing the cause is half-way to the solution!
Thanks for having looked into this! I also read the issue being discussed on a few stackoverflow articles. This is not a biggie though. So I'll just leave it as is for now.
Thanks again!
One little request for future releases:
Is it possible to expand the Categories drop-down menu in a way that individual subcats can be selected for printing?
As an example, on one of my sites I have 10 or 15 subcats which are all under the category *Professional Products* such as:
*Professional Products*
-- Blackmores
-- China Med
-- Zen Therapeutics
etc
It would be good if I could select only say the subcat China Med and print these products.
As it stands, I have to select *Professional Products* , hit the print button, scroll through to find the page number pertaining to China Med and print that page (or 2 if it extends over 2 pages).
Thanks / Frank
This request has been noted in the plugin's GitHub repository: https://github.com/lat9/printable_price_list/issues/9Quote:
Originally Posted by frank18
Quote:
Originally Posted by lat9
Thank you!
I'd love to give this plugin a try. It would be great for our storefront as well. Does it support attributes yet? That's the only thing stopping me
The plugin's current "support" of attributes consists of recognizing that products have attributes and displaying a "More Info..." instead of a buy-now/add-to-cart button.
What functionality do you expect when you ask "Does it support attributes yet?"?
I'm just wondering if it displays the prices of different things.
On our site we have extracts that come in 1 oz 2 oz 4 oz 8 oz 16 oz 32 oz 1/2 gal 1 gal. If I were to use this plugin would it show the prices for each or just show a "more info"?
The plugin will show the "starting at" price and a "more info" link.Quote:
Originally Posted by CHerbalist
I've reviewed this plugin and, as it has no core- or template-overwrites, it's compatible with Zen Cart 1.5.5.
this module seem good but when you ask for just no tax to be in the listing then the prices come up as zero!!! http://www.saving-light-bulbs.co.uk/...list&profile=3
If you ask for net and with tax then you get both columns with the net figure!!!
Any idea on how to fix?
I've recorded this as an issue on the plugin's GitHub repository (https://github.com/lat9/printable_price_list/issues/10).
The issue is that the Price (ex) appears to be tied to the Price (inc), so that if the latter is not displayed as part of the pricelist the former is not calculated.
I've submitted v2.0.2 to the Plugins (https://www.zen-cart.com/downloads.php?do=file&id=173) for review to correct the issue reported by @ptowers49.
Besides updating the plugin's version number, the pertinent change to correct the problem requires an edit of /includes/modules/pages/pricelist/header_php.php (around line 52), adding the bit in red:
The plugin's zip-file is also available from its github repository (https://github.com/lat9/printable_pr...ses/tag/v2.0.2).Code:$profile_settings = array (
array ('PL_GROUP_NAME', 'group_name', 'char'),
array ('PL_PROFILE_NAME', 'profile_name', 'char'),
array ('PL_USE_MASTER_CATS_ONLY', 'master_cats_only', 'bool'),
array ('PL_SHOW_BOXES', 'show_boxes', 'bool'),
array ('PL_CATEGORY_TREE_MAIN_CATS_ONLY', 'main_cats_only', 'bool'),
array ('PL_MAINCATS_NEW_PAGE', 'maincats_new_page', 'bool'),
array ('PL_NOWRAP', 'nowrap', 'bool'),
array ('PL_SHOW_MODEL', 'show_model', 'bool-col', 'p.products_model'),
array ('PL_SHOW_MANUFACTURER', 'show_manufacturer', 'bool-col', 'p.manufacturers_id'),
array ('PL_SHOW_WEIGHT', 'show_weight', 'bool-col', 'p.products_weight'),
array ('PL_SHOW_SOH', 'show_stock', 'bool-col', 'p.products_quantity'),
array ('PL_SHOW_NOTES_A', 'show_notes_a', 'bool-col'),
array ('PL_SHOW_NOTES_B', 'show_notes_b', 'bool-col'),
array ('PL_SHOW_PRICE', 'show_price', 'bool-col', 'p.products_price'),
array ('PL_SHOW_TAX_FREE', 'show_taxfree', 'bool-col', 'p.products_price'),
array ('PL_SHOW_SPECIAL_PRICE', 'show_special_price', 'bool'),
array ('PL_SHOW_SPECIAL_DATE', 'show_special_date', 'bool'),
array ('PL_SHOW_ADDTOCART_BUTTON', 'show_cart_button', 'bool-col'),
array ('PL_ADDTOCART_TARGET', 'add_cart_target', 'char'),
array ('PL_SHOW_IMAGE', 'show_image', 'bool', 'p.products_image'),
array ('PL_IMAGE_PRODUCT_HEIGHT', 'image_height', 'int'),
array ('PL_IMAGE_PRODUCT_WIDTH', 'image_width', 'int'),
array ('PL_SHOW_DESCRIPTION', 'show_description', 'bool'),
array ('PL_TRUNCATE_DESCRIPTION', 'truncate_desc', 'int'),
array ('PL_SHOW_INACTIVE', 'show_inactive', 'bool'),
array ('PL_SORT_PRODUCTS_BY', 'sort_by', 'char'),
array ('PL_SORT_ASC_DESC', 'sort_dir', 'char'),
array ('PL_DEBUG', 'debug', 'bool'),
array ('PL_HEADER_LOGO', 'show_logo', 'bool'),
array ('PL_SHOW_PRICELIST_PAGE_HEADERS', 'show_headers', 'bool'),
array ('PL_SHOW_PRICELIST_PAGE_FOOTERS', 'show_footers', 'bool'),
);
v2.0.2 is now available for download from the Zen Cart Plugins.
thanks for the reply
I have tried this but the inc £ price still seems to be the ex VAT price !!!
please check
http://www.saving-light-bulbs.co.uk/...list&profile=1
any ideas?
Regards
Paul
@ptowers49, what is your setting for Configuration->My Store->Display Prices with Tax?
I have Display Prices with Tax set to false as I do not want the website to show prices with VAT.,
The issue is that that in the price list the column titles inc £ shows the prices net VAT!!!
This column should either have the prices with VAT or be removed.
If you can help that would be great
Regards
Paul
Understood. I believe I've found the issue; it'll take me a bit to correct it.
I've just submitted v2.0.3 to the Plugins for review, correcting the display of the Price (inc) values to actually include the tax value.
v2.0.3 is now available for download from the Zen Cart Plugins.
working great now with inc and ex TAX prices thanks
Thanks for the feedback; I appreciate it!
I have uploaded the files and they worked first time on 1.5.4 and no bugs found as yet, many thanks.
I have uploaded the additional product cost field (using product_cost_display plugin) but do not know how to add this column to the printout. Can you help with this??
Thanks again.
I've never used the product_cost_display plugin, so I don't know how easy/difficult it would be to add that column. In any case, what you are requesting is over-and-above the scope of "Printable Price List"; if you are interested in pursuing a custom-programming solution, please PM me.
OK, that wasn't too difficult. There are a couple of edits to be made.Quote:
Originally Posted by lat9
First, /includes/modules/pages/pricelist/header_php.php, starting at line 52, make the highlighted additions:
Next up, /includes/templates/template_default/pricelist/tpl_main_page.php. Two edits in this file, the first starting at line 139:Code:$profile_settings = array (
array ('PL_GROUP_NAME', 'group_name', 'char'),
array ('PL_PROFILE_NAME', 'profile_name', 'char'),
array ('PL_USE_MASTER_CATS_ONLY', 'master_cats_only', 'bool'),
array ('PL_SHOW_BOXES', 'show_boxes', 'bool'),
array ('PL_CATEGORY_TREE_MAIN_CATS_ONLY', 'main_cats_only', 'bool'),
array ('PL_MAINCATS_NEW_PAGE', 'maincats_new_page', 'bool'),
array ('PL_NOWRAP', 'nowrap', 'bool'),
array ('PL_SHOW_MODEL', 'show_model', 'bool-col', 'p.products_model'),
array ('PL_SHOW_MANUFACTURER', 'show_manufacturer', 'bool-col', 'p.manufacturers_id'),
array ('PL_SHOW_WEIGHT', 'show_weight', 'bool-col', 'p.products_weight'),
array ('PL_SHOW_SOH', 'show_stock', 'bool-col', 'p.products_quantity'),
array ('PL_SHOW_NOTES_A', 'show_notes_a', 'bool-col'),
array ('PL_SHOW_NOTES_B', 'show_notes_b', 'bool-col'),
array ('PL_SHOW_PRICE', 'show_price', 'bool-col', 'p.products_price'),
array ('PL_SHOW_TAX_FREE', 'show_taxfree', 'bool-col', 'p.products_price'),
array ('PL_SHOW_SPECIAL_PRICE', 'show_special_price', 'bool'),
array ('PL_SHOW_SPECIAL_DATE', 'show_special_date', 'bool'),
array ('PL_SHOW_ADDTOCART_BUTTON', 'show_cart_button', 'bool-col'),
array ('PL_ADDTOCART_TARGET', 'add_cart_target', 'char'),
array ('PL_SHOW_IMAGE', 'show_image', 'bool', 'p.products_image'),
array ('PL_IMAGE_PRODUCT_HEIGHT', 'image_height', 'int'),
array ('PL_IMAGE_PRODUCT_WIDTH', 'image_width', 'int'),
array ('PL_SHOW_DESCRIPTION', 'show_description', 'bool'),
array ('PL_TRUNCATE_DESCRIPTION', 'truncate_desc', 'int'),
array ('PL_SHOW_INACTIVE', 'show_inactive', 'bool'),
array ('PL_SORT_PRODUCTS_BY', 'sort_by', 'char'),
array ('PL_SORT_ASC_DESC', 'sort_dir', 'char'),
array ('PL_DEBUG', 'debug', 'bool'),
array ('PL_HEADER_LOGO', 'show_logo', 'bool'),
array ('PL_SHOW_PRICELIST_PAGE_HEADERS', 'show_headers', 'bool'),
array ('PL_SHOW_PRICELIST_PAGE_FOOTERS', 'show_footers', 'bool'),
);
//-20160204-lat9-Add support for products_cost field *** 1 of 1 ***
global $sniffer;
if ($sniffer->field_exists (TABLE_PRODUCTS, 'products_cost')) {
define ('PL_SHOW_PRODUCT_COST_' . $this->current_profile, 'true');
$profile_settings[] = array ('PL_SHOW_PRODUCT_COST', 'show_cost', 'bool-col', 'p.products_cost');
}
//-20160204-lat9-Add support for products_cost field *** 1 of 1 ***
Next, find the start of the next block (around line 251 with the above addition):Code:if ($price_list->config['show_notes_b']) {
?>
<td class="ntsPL"><div><?php echo TABLE_HEADING_NOTES_B; ?></div></td>
<?php
}
$pl_currency_symbol = (defined ('PL_INCLUDE_CURRENCY_SYMBOL') && PL_INCLUDE_CURRENCY_SYMBOL == 'false') ? '' : $price_list->currency_symbol;
//-bof-20160204-lat9-Add support for products_cost *** 1 of 2 ***
if ($price_list->config['show_cost']) {
?>
<td class="prcPL"><div><?php echo 'Cost ' . $pl_currency_symbol; ?></div></td>
<?php
}
//-eof-20160204-lat9-Add support for products_cost *** 1 of 2 ***
The 'cost' column will appear to the left of the other product price-related columns.Code:if ($price_list->config['show_notes_b']) {
?>
<td class="ntsbPL"> </td>
<?php
}
$price_class = ($special_price_ex > 0) ? 'prcPL notSplPL' : 'prcPL';
//-bof-20160204-lat9-Add support for products_cost *** 2 of 2 ***
if ($price_list->config['show_cost']) {
?>
<td class="<?php echo $price_class; ?>"><?php echo $price_list->display_price ($current_row['products_cost']);; ?></td>
<?php
}
//-eof-20160204-lat9-Add support for products_cost *** 2 of 2 ***
if ($price_list->config['show_price']) {
?>
<td class="<?php echo $price_class; ?>"><?php echo $products_price_inc; ?></td>
<?php
}
Believed to be missing from uninstall.sql
DELETE FROM configuration where configuration_key like 'TEXT_PL%';
Shouldn't be necessary for the updated versions. There was (in versions prior to v2.0.0) a database value named TEXT_PL_HEADER_LOGO_*, but the current version's installation now renames those database constants to PL_HEADER_LOGO_*.Quote:
Originally Posted by swguy
It was needed on a 1.3.9 upgrade of an old cart. Got continual blank page in admin until I did this step.
... and what was the error associated with the blank page? How did you go about the upgrade? Did you upgrade this plugin or were you simply looking to remove the older version?Quote:
Originally Posted by swguy
I got a db error early on so I ran the uninstaller and then reinstalled. I don't have the log but it was a duplicate entry error.
Oh, I see now. It's not that the configuration key(s) need to be added to the uninstaller, it's the installer that has issues.
Right now, the installer installs all the PPL keys and then checks for the presence of the old-named configuration value, renaming it if present (that's where the duplicate key message comes from). I need to move the check/rename to before where the individual price-list settings are created.
Hi Have been looking through threads and can't find an answer. Using zc1.5.4 and installed this mod a few times but just getting a blank screen when I type in the url? Has anyone an idea what is happening here thanks guys
When you get a "blank screen", that's Zen Cart's way of letting you know that there's a myDEBUG*.log file waiting in your /logs folder to identify the source of that issue.
Thank you to the creators and those responsible for continuing this add on. I've been using it from nearly it's beginning. I recently updated from ZC 1.39 to the latest ZC and then found that I needed to also update the version of the Printable Pricelist I had been using. The new version installed without any issues and worked right out of the box.
My reason for posting this was that I've always wanted to be able to have a profile for either featured or special items. I'd like visitors to be able to print out a listing of all the products that are currently on special or be able to use that as a sales flyer.
Is it possible to do with the current version or is this perhaps a feature we can look forward to in the future?
I've added your enhancement request to the plugin's GitHub repository's issues: https://github.com/lat9/printable_price_list/issues
ZC v 1.5.5b
upgraded from 1.39h a few months ago
Upgrade when smoothly
Apache Version 2.4.18
PHP Version 5.5.32
MySQL Version 5.6.34
After installing Pricelist I'm getting tons of my debug error logs with the following..(paths altered to protect the innocent)
[17-Nov-2016 15:34:58 UTC] Request URI: /store/index.php?language=en&main_page=pricelist&zenid=o4gkinvm213nuoq4k1eqmu0dg7, IP address: 192.243.55.132
#1 constant() called at [/home/public_html/store/includes/modules/pages/pricelist/header_php.php:91]
#2 price_list->__construct() called at [/home/public_html/store/includes/modules/pages/pricelist/header_php.php:318]
#3 require(/home/public_html/store/includes/modules/pages/pricelist/header_php.php) called at [/home/public_html/store/index.php:36]
[17-Nov-2016 15:34:58 UTC] PHP Warning: constant(): Couldn't find constant PL_SHOW_SPECIAL_DATE_3 in /home/public_html/store/includes/modules/pages/pricelist/header_php.php on line 91
I'm going to try commenting the line containing PL_SHOW_SPECIAL_DATE in header_php.php and see if that at least stops the debug logs.
any other advise is welcome.
Nope, commenting out the one line in the array that has the var PL_Showdate etc.. did not stop the error logs from being generated. :-(
It sounds like the plugin's installation got messed somehow. Try running the plugin's uninstall SQL, located in the root of the plugin's distribution zip-file and then refreshing the admin's display to cause the plugin's auto-install script to run.
Make sure to save any changes you might have made!
That seems to have resolved it. It appears that I had left over page config info that was the problem. I say this because the output catalog page looks different than it did before doing the remove and refresh. What I'm saying is after upgrading the first time I still had my profile definitions and this time I had to go in and tweak my profiles as their were reset to a default setting. I do miss the old 2 column layout even though it was never perfect by any means. It just looked better when printed on paper.Quote:
Originally Posted by lat9
Is there a way to set the print margins in the profiles or via CSS or something?
Yea, that 2-column layout was not "playing well" with the CSS styling. I've got the feature-request noted in the plugin's GitHub repository!
You can use the profile-*.css files in the /includes/templates/template_default/pricelist folder to customize those margins.
Thanks very much for making this mod available Paul.
Great plugin with many features. I am not sure if it is just me but when I activate 'Image' I get this random display image positioning. Further more if I change the same profile without the 'Description' images show totally different again.?
How do I fix that?
And when or how far away to display prices with Attributes. All my prices are priced with attributes and unfortunately can't see them.
Thank for your kind support.
Attachment 17375
OK I think fixed my image random positioning with
.imgDescrRndPL_1 img, .imgDescrRndPL_2 img{ float: left; } >> instead of { float: right; }
Yes Of course :-) how did you missed?Quote:
Originally Posted by paulm
All my products are listed with attributes and I can not see prices when listed
I have been using this mod successfully for many years now. (Great Plugin!) I am busy testing the upgrade of my site to 1.5.5 and installed the latest upgrade of the mod. Everything was working fine until I installed the Responsive Sheffield Blue template. Now I cant get the link to the price list to show up in the footer anymore. (Everything looks to be set up correctly in the EZ pages menu). There is no mention of this problem in the template's support thread but I am guessing it has something to do with Flexible Footer?
I have tried reinstalling the mod. Anyone else have this problem or can help with some suggestions?
Since the price-list link was showing in the footer before you installed the template, I'll suggest that you post in that template's support-thread to see if someone more familiar with its inner-workings can help.Quote:
Originally Posted by Francois
Quote:
Originally Posted by oavs
I'm having that same issue, but when I went to try your solution, I couldn't find that line in ANY of the files...?Quote:
Originally Posted by oavs
There are interference overwrites in that template. I've dealt with them specifically with that flexible footer in Responsive Sheffield Blue before.Quote:
Originally Posted by Francois
Either it masked the stock code you are using with ez pages or it overlooked them entirely.
You just have to replace the connection to the stock code and it will work again!
I'm installing attributes into this module tonight :). Do you use attributes normally - stock 1.55f - without modification in your cart?Quote:
Originally Posted by oavs
Please note that this plugin's got a GitHub repository: https://github.com/lat9/printable_price_listQuote:
Originally Posted by twitchtoo
It's been asked before, but I never saw a definitive answer regarding it, but when I have "Show Product images?" set to "True", the images show up, but they're randomly placed to the left and right of each product. Another issue I am having, is that regardless of what I set my image size to (in this case 50px by 50px) when I go to actually print the list, each line is positively massive, and causes my list to use probably 5 times as many pages as it would actually need to. (see image below).
Attachment 18117
Is there any way to fix these two issues?
These issues will be fixed in the upcoming release!Quote:
Originally Posted by Lordzoabar
Just to be able to log these errors somewhere I am posting them here.
With PHP7 using profile2 in landscape I get error of: Allowed memory size of 327155712 bytes exhausted
If I disable images in profile2 landscape I get : #4 queryFactory->Execute() called at [/home/bailey/_sites/bmh156a.bmh.com.au/public/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 zen_sessions (sesskey, expiry, `value`)
values ('1r6d2bid76bmed4uj4qd762032', 1573438219, 'c2VjdXJpdH ... [*** NOTE THIS VALUE IS 5191 CHARS ***]')
ON DUPLICATE KEY UPDATE `value`='c2VjdXJpdH ... [*** NOTE THIS VALUE IS 5191 CHARS ***]', expiry=1573438219
PHP Warning: Unknown: Cannot call session save handler in a recursive manner in Unknown on line 0
These errors only occur with this profile.
I have increased the memory size.
To avoid this error ensure "Main cats New Page" and "Main Cats New Table" are both set to false
----------
environment Dev: Zen Cart 156c; Apache 2.4.33; PHP 7.3.1; MySQL 5.7.21; Windows 10
environment Test: Zen Cart 156a; Apache 2.4.29; PHP 7.2.4; MySQL 5.7.24; Linux 4.15.0
Thank you for this plugin.
Is there an update on how to display attribute price list?
Nope, not yet. I've created an issue in the plugin's GitHub repository (https://github.com/lat9/printable_price_list/issues/15) to track that change.Quote:
Originally Posted by oavs
Hi all,
anyone has the 2-column layout and can tell me how i do this in the profile-*.css files ( /includes/templates/template_default/pricelist )
I try it but it dont work. :(
TIA
Hi I am following up to see if there has been an update to include attributes on the pricelist yet. Thank you!Quote:
Originally Posted by lat9
Time flies, but not yet. It's back on my radar. What template and Zen Cart version are you using?Quote:
Originally Posted by chuckrey
Quote:
Originally Posted by oavs
Looking for ideas regarding how the attributes' pricing should be displayed.Quote:
Originally Posted by chuckrey
Does it make sense to use the shopping cart page as a model, and just put them under the product?
Option 1 Value 1: +$1.00
Option 1 Value 2: +$5.00
Option 2 Value 1: -$3.00
etc.
Kind of; it's just that some sites have products with a large number of options, so that could heavily expand the formatting. I'm adding other price-list configuration values, so it might be appropriate for a setting to control whether/not to include the attributes' list.Quote:
Originally Posted by swguy
I've just submitted v3.0.0 of the Printable Price List for the Zen Cart moderators' review; I'll post back here when it's available for download.
This version contains the following changes:
- CHANGE: Minimum Zen Cart version is now zc157.
- BUGFIX: Include 'date_added' when creating initial configuration settings.
- BUGFIX: Correct PHP warnings issued if no pricing is to be displayed.
- BUGFIX: Correctly display prices with/without tax, based on the site's configuration setting.
- BUGFIX: Product pricing now includes any updates for products priced by attributes.
- CHANGE: Price-lists can now be configured for featured, special or sub-category products' listings.
- CHANGE: Only categories with products are now displayed.
- CHANGE: Now displaying products' attributes' pricing.
- CHANGE: Products' images (if configured) now display next to the product's name, no more location randomization.
Thank you for your response and my apologies for my delayed response.Quote:
Originally Posted by lat9
I am currently using the Westminster New Template and have 1.5.7c installed.
Thank you!
That update from yesterday now includes attributes pricing, but you'll need to enable that processing via a pricelist-by-pricelist configuration setting. You can grab a copy from the plugin's GitHub repository: https://github.com/lat9/printable_pr...ses/tag/v3.0.0Quote:
Originally Posted by chuckrey
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=173Quote:
Originally Posted by lat9
Wow, that was fast! I will load it shortly and give it a try. Thank you very much for all you do. Where an I send something to buy you a coffee?Quote:
Originally Posted by lat9
There's a "Donate" link in the bottom of the right sidebox on my website.Quote:
Originally Posted by chuckrey
While testing in XAMPP
Issue:
The following debug-log is generated:
This only happens when Group Name is not blank and results in all groups being refused.Code:[18-Jan-2022 09:44:24 ] Request URI: /index.php?main_page=pricelist&profile=1, IP address: ::1
#1 require(...\includes\templates\template_default\pricelist\tpl_main_page.php)
called at [...\index.php:94]
--> PHP Warning: Use of undefined constant zen_in_guest_checkout - assumed 'zen_in_guest_checkout'
(this will throw an Error in a future version of PHP) in
...\includes\templates\template_default\pricelist\tpl_main_page.php on line 68.
A quick search for !zen_in_guest_checkout) with Admin Developers Tool Kit gives only 1 hit: tpl_main_page.php on line 68
All others !zen_in_guest_checkout are followed by ())
Fix:
In:
.../includes/templates/template_default/pricelist/tpl_main_page.php
or:
.../includes/templates/your_template/pricelist/tpl_main_page.php
Find (normally on line 68):
Replace by:PHP Code:if (zen_is_logged_in() && !zen_in_guest_checkout) {
PHP Code:if (zen_is_logged_in() && !zen_in_guest_checkout()) {
You are correct.
PR submitted: https://github.com/lat9/printable_price_list/pull/23/
Thanks @Philibel and @swguy; the associated changes will be included in v3.0.1 of the Printable Price List. I'll hold off for a couple of days prior to release, since there's (it seems) always something else.
With Printable Price List 3.0.0 I am getting the following logged Warning
constant(): Couldn't find constant PL_SHOW_SPECIAL_DATE_3 in \includes\modules\pages\pricelist\header_php.php on line 104.
Environment: zc157c, bootstrap 3.2.0
What's the history of the site's use of Printable Price List? In the per-profile admin settings, there should be a Show Specials Expiry? setting; is it there?Quote:
Originally Posted by OldNGrey
This is test zc157c environment: Zen Cart 157c; Apache 2.4.46; PHP 7.4.13; 10.4.17-MariaDB; XAMPP v3.2.4; Windows 10 build 19041 Printable Price-List V3.0.0
print-List profiles have Specials expiry = false. This error only occurs with profile 3.
Update- problem resolved I have been using price-list for a very long time. After importing data from 156a I ran the pricelist_remove.sql and reran the profiles with no errors.
I must have been something residual in the data from earlier version
I've just submitted v3.0.1 for the Zen Cart moderators' review and will post back here when it's available for download.Quote:
Originally Posted by lat9
This release contains the changes associated with issue #24 (invalid function call results in PHP warning/error).
@lat9
Has this module been tested with 158 yet?
Nope, it's pretty far down my ever-growing list.Quote:
Originally Posted by haredo
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!Quote:
Originally Posted by OldNGrey
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?
Quote:
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.
Quote:
[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.
Quote:
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.
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.Quote:
Originally Posted by OldNGrey
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?
Under Admin > Configuration there should be 4 entries: Printable Price-list; Price-List Profile-1; Price-List Profile-2; Price-List Profile-3;Quote:
Originally Posted by pixodaros
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.I will look into the tweaked version of Printable Price List on Github and continue to read backwards in this threadCode:
[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.
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/upgra...ersion-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)