PDF Order Center - Problems
I have just installed a fresh copy of PDF Order Center into Zen 1.3.0.1
I pasted the SQL code into the Install SQL Tool in the Admin interface. I then uploaded all of the corresponding files, etc.
When I access the PDF Order Center I am shown the full screen of options. However, a few links are not working. The top navigation:
Code:
<= Reset form|Pending|Processing|Delivered|Update
does not fully work. The only link that works from those above is the "Reset form" link. The others give an error such as the following when I click on "Pending":
Code:
1146 Table 'cart_db.orders' doesn't exist
in:
[select count(*) as total from orders o left join orders_total ot on (o.orders_id = ot.orders_id) where (ot.class = 'ot_total') and (o.orders_status = '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Now, my tables are all prefixed with "zen_". I was under the impression that uploading the SQL via the Intsall Tool would automatically adjust for this, which the SQL import seems to have done. I have checked and the table "zen_orders" does exist. So how do I let the rest of the system to see that it should not look at "orders" but at "zen_orders"???
Thanks for any help/advice!
Kevin L.
Re: PDF Order Center - Problems
Re: PDF Order Center - Problems
grayson,
Thanks for the link. I have moved my post to that forum.
Thanks again,
Kevin L.
Re: PDF Order Center - Problems
Have just installed PDFOC without any problems and it is proving to be really useful and a real time saver. However, inadvertantly sent out 600 emails this evening to customers telling them we had despatched their order when in fact I had only meant to send out this message to a couple of customers.
Is there any way to make the system not send out emails if no boxes have been ticked rather than defaulting to every order receiving an email if nothing has been selected.
We have now set the default to not send out emails unless selected to prevent a repetition but it was a bit of an embarrassment nevertheless.
Re: PDF Order Center - Problems
We had the same issue - it emailed all our customers from years ago....
We have now switched off emailing to avoid this happening again and rely on the email receipt that is sent when they order as confirmation.
Re: PDF Order Center - Problems
Just happened to us as well - nearly 2000 orders :/ this needs fixing and quick support site doesnt exist anymore...
Re: PDF Order Center - Problems
Quote:
Originally Posted by
TPHoare
Have just installed PDFOC without any problems and it is proving to be really useful and a real time saver. However, inadvertantly sent out 600 emails this evening to customers telling them we had despatched their order when in fact I had only meant to send out this message to a couple of customers.
Is there any way to make the system not send out emails if no boxes have been ticked rather than defaulting to every order receiving an email if nothing has been selected.
We have now set the default to not send out emails unless selected to prevent a repetition but it was a bit of an embarrassment nevertheless.
LOL:laugh:
I think that anybody who has used this module has had the same problem you describe here. I know i did.
The selection method used is very vague.
Ronald.
Re: PDF Order Center - Problems
After two years I have still have the odd senior moment when I inadvertently set everything 'processing', 'despatched' or even 'cancelled' but the fact is that even with this problem it's still a very useful tool - and one to which I haven't yet found any alternative.
Re: PDF Order Center - Problems
I just think its wrong sitting back and saying "oh well what will happen will happen" I dont want to spent another morning replying to 47 emails of "unprofessionalism" , "remove my mail address", "who are you and what have I ordered" , "I'm calling my credit card company and blocking all payments from you".
I dont think its professional enough and I'd like to stop it, I will have a look and see what I need to do to code but I dont think I can fix it permanently. Perhaps I'll check to see if there are any orders older than a week and flag an error. Off work sick at the moment so I'll have a look later on in the week
Re: PDF Order Center - Problems
No, you're quite right, of course. If I knew the first thing about PHP I would have a go myself - it can't be that difficult.
Re: PDF Order Center - Problems
Paul M has made a fix for this issue, which I've merged with the last release from Grayson. Also included some other modifications.
BUT, for some reason it's still not available in the downloads section, although I submitted it more than a month ago.
So, if you would like to download this package, you could visit the dutch forum to obtain it over there.
http://www.zen-cart.nl/forums/index.php?topic=824.0
The only problem I noticed is that when sending the e-mails, there appears a red bar with header in it. Couldn't find it quickly, so if someone knows, let me know! :D (This doesn't affect the working of this mod.)
Re: PDF Order Center - Problems
Quote:
Originally Posted by
Briann
Paul M has made a fix for this issue, which I've merged with the last release from Grayson. Also included some other modifications.
BUT, for some reason it's still not available in the downloads section, although I submitted it more than a month ago.
So, if you would like to download this package, you could visit the dutch forum to obtain it over there.
http://www.zen-cart.nl/forums/index.php?topic=824.0
The only problem I noticed is that when sending the e-mails, there appears a red bar with header in it. Couldn't find it quickly, so if someone knows, let me know! :D (This doesn't affect the working of this mod.)
Is it version 1.2.1 that is in the first post in the thread? Or do we have to use the code snippets in the various posts?
Thanks for posting this!
Re: PDF Order Center - Problems
Is just saw your post..
Yeah, that's the newest version. But the link doesn't work anymore. (because of a merged thread) So I will correct it in a few minutes.
Edit: OOPS, I always forget that you cannot edit messages on zen-cart.com days later. :shocking:
So this is the working link: http://www.zen-cart.nl/forums/index.php?topic=3684.0
Re: PDF Order Center - Problems
Quote:
Originally Posted by
Briann
Is just saw your post..
Yeah, that's the newest version. But the link doesn't work anymore. (because of a merged thread) So I will correct it in a few minutes.
Edit: OOPS, I always forget that you cannot edit messages on zen-cart.com days later. :shocking:
So this is the working link:
http://www.zen-cart.nl/forums/index.php?topic=3684.0
Thank you! I appreciate you posting the link here and I will try this out very soon.
Re: PDF Order Center - Problems
How do you change the defaults to invoice and packing slip and final rather than preview
Regards
Gareth
Re: PDF Order Center - Problems
See admin > configuration > PDF Order Center
the following settings:
Printing: default template?
Printing: final invoice or preview?
:thumbsup:
Re: PDF Order Center - Problems
lol what an idiot ive been....
Ive been trolling through the code for ages trying to hack it.
Cheers
Gareth
Re: PDF Order Center - Problems
Hi
I installed this mod but there was a problem, it said "Can't write to directory! Please set the permissions of your temp_pdf folder to 777." I cannot find temp_pdf folder from download, can someone please help?
thanks!
Re: PDF Order Center - Problems
I guess it's also told in the readme, but you if I remember well you need to create the temp_pdf/ folder in /modules/pdfoc/ yourself.
Re: PDF Order Center - Problems
Hello,
I get this error message when I install the pdfoc.sql file. I've tried for hours on end to solve this but haven't had any success yet.
Also in Admin --> Configuration --> Pdf Order Center - the Pdf Order Center is completely empty...
Anyone with the same problem??
Regards
Jacob
"Error
SQL query:
#NEXT_X_ROWS_AS_ONE_COMMAND:2
INSERT INTO zc_soundfactory_nu_configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES (
'Order Listing: max entries per page?', 'PDFOC_ORDERLISTINGMAX_DEFAULT', '100', 'Determines the maximum number of orders shown per page in the orders list. Only orders on the current page will be included when pressing the Use and Omit buttons.', @pdfocid , 5, NULL , NULL
);
MySQL said:
#1062 - Duplicate entry 'PDFOC_ORDERLISTINGMAX_DEFAULT' for key 2 "
Re: PDF Order Center - Problems
Quote:
Originally Posted by
Briann
Is there an english version?
Re: PDF Order Center - 403 Permission Denied
403 Permission Denied
You do not have permission for this request /myadmin/includes/modules/pdfoc/temp_pdf/batch_orders.pdf
When ever I try to click on the link for the generated pdf file from the pdf order center I get this error. I have the temp_pdf folder with permission 777. I have also tried putting a standard zencart admin .htaccess file into this folder (as this was a solution for a similar issue I found on the forums).
But I cannot seem to get this to work. If I go to my ftp I can download but this is not very practical or convenient. I am running zencart 1.3.9h.
Any suggestion please let me know. :D
By the way on a new store separate from the above issue.
Using PDF Order Center with Zen Cart 1.3.9
Wanted to clarify this post..
Zen Cart v1.3.9 has some additional security measures which includes a number of .htaccess files to help lock down your store a little better. IF you are running Zen Cart 1.3.9, you MUST modify the .htaccess file or you will get errors when you attempt to view your PDF files using this mod.
The location of the .htaccess file to be modified is located here: admin/includes. Because these directives are case sensitive, here is the updated correction needed:
Replace the entire contents of the admin/includes/.htaccess file with this:
Code:
#
# @copyright Copyright 2003-2010 Zen Cart Development Team
# @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
# @version $Id: .htaccess 16111 2010-04-29 22:39:02Z drbyte $
#
# This is used with Apache WebServers
#
# The following blocks direct HTTP requests to all filetypes in this directory recursively, except certain approved exceptions
# It also prevents the ability of any scripts to run. No type of script, be it PHP, PERL or whatever, can normally be executed if ExecCGI is disabled.
# Will also prevent people from seeing what is in the dir. and any sub-directories
#
# For this to work, you must include either 'All' or at least: 'Limit' and 'Indexes' parameters to the AllowOverride configuration in your apache/conf/httpd.conf file.
# Additionally, if you want the added protection offered by the OPTIONS directive below, you'll need to add 'Options' to the AllowOverride list, if 'All' is not specified.
# Example:
#<Directory "/usr/local/apache/htdocs">
# AllowOverride Limit Options Indexes
#</Directory>
###############################
# deny *everything*
<FilesMatch ".*">
Order Allow,Deny
Deny from all
</FilesMatch>
# but now allow just *certain* necessary files:
<FilesMatch ".*\.(js|css|jpg|JPG|gif|GIF|png|PNG|pdf|PDF)$">
Order Allow,Deny
Allow from all
</FilesMatch>
IndexIgnore */*
Quote:
Originally Posted by
supersnow
So got it to work so I didn't get the 404 permission denied. The .htaccess file was updated to this (just in case someone else has this issue):
Code:
# deny *everything*
<FilesMatch ".*\..*">
Order Allow,Deny
Deny from all
</FilesMatch>
# but now allow just *certain* necessary files:
<FilesMatch "(^$|^favicon.ico$|.*\.(php|js|css|jpg|gif|png|pdf)$)">
Order Allow,Deny
Allow from all
</FilesMatch>
And it was working fine for about two days. Now I have new problem it has decided to stop printing the sold to address and the ship to address on my packing slips and invoices.
The labels still pull through the address but so some reason the packing slip and invoice don't.
This is driving me crazy I love the pdf order center I just want it to work. Please help!:cry:
