PDF Order Center

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 "

This is 3rd party code and you should find out if there is a support thread for it in the contributed addons section

Sorry..
thnks!

Are you trying to install PDFOC on a clean install of Zen-Cart?
On what version are you installing?

It seems a value exists two times in the database?
Could you check with PHPmyAdmin?

Briann:

So this is the working link: http://www.zen-cart.nl/forums/index.php?topic=3684.0

Is there an english version?

dw08gm:

Is there an english version?
Did you check the free software addons link above left???

Sorry I am not talking about the mod but the link: http://www.zen-cart.nl/forums/index.php?topic=3684.0.

Briann:

Are you trying to install PDFOC on a clean install of Zen-Cart?
On what version are you installing?

It seems a value exists two times in the database?
Could you check with PHPmyAdmin?

Hi Briann,

Thanks for the help! I'm using v 1.39f. I've installed some add-ons, they are:

-ih2
-fual slimbox
-tabbed pro
-sales report
-monthly sales etc.

It seems to be a database error. Most add-ons including sql's I have been able to figure out, but I haven't been able to get this one right. Actually I prefer this module's over Super Orders and I think the invoice customizations are easier to handle (at least for me) so it would be great to get it working.

I can't see why there should be double entries in the database. I've made uninstalls as soon as something's gone wrong and then made re-installs again.

I've attached the sql file, I've figured there's something wrong with the table prefixes (it's not an upgrade)??

Kind regards
Jacob

Solved it thanks to Briann. Had to rearrange the configuration group id numbers...

TakeCare
Jacob

I have a new invoice for PDF order center..but the table with sub total, tax, shipping and total only shows up on the first page if I am processing multiple invoices at the same time.

Can someone help me...I had a friend code it for me..as I cannot do that..and they are unavailable for a bit to help fix it...and I need to get this resolved.

I've attached it here just as a txt file..if someone could help I would appreciate it!

This is our problem. For some reason I have no idea but all my orders got updated to processing when I was wanting to print a few of my orders out. Now we have over 5000 orders in the system and I know I can remove the order status history entries in the that table but then I have the problem that the order table also stores the most current status. How to I get this to sync to the correct status that it should be prior to the error that has happen because of the PDF order center?

supersnow:

This is our problem. For some reason I have no idea but all my orders got updated to processing when I was wanting to print a few of my orders out. Now we have over 5000 orders in the system and I know I can remove the order status history entries in the that table but then I have the problem that the order table also stores the most current status. How to I get this to sync to the correct status that it should be prior to the error that has happen because of the PDF order center?

Fixed. I had a backup form the night before - thanks to camelot-hosting!

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

All orders will get updated, when a user chooses 'Process Selected Orders' when there is no selection made, yet.

The most recent version solves this issue.

About the other issue:

A simple CHMOD 777 should have done the job. I don't have a clue why this would happen. You could consider asking your hosting company, as this is probably related to the server settings.

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):

# 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:

Hopefully someone can help - I love pdf order center and I really love the invoices & packingslips etc. The only thing between the pdf print working and not working is an update to super orders to 3.0. I do not have pdf order center and super orders integrated. So I am not sure what else would be interferring with the address printing.

But I don't like the super order invoice and packing slip printing I want to use PDF order center but I really need to tha the SOLD to and BILL to address to show up on the invoices and the packing slips.

As I said in my previous post the label print from PDFOC works but not the invoices or packing slips - weird!

Please help!:cry:

supersnow:

I do not have pdf order center and super orders integrated. So I am not sure what else would be interferring with the address printing.
I just wanted to weigh in here.. There is NOTHING in the Super Orders shop files or the install/uninstall/upgrade SQL files that would in anyway interfere with PDF Order Center.

These two modules are mutually exclusive. They do not share files and in fact (as the PDF Order Center readme states) they both can run together side by side.

Briann, if you find that these statements are not true with regards to Super Orders v3.0, please let me know where there might be conflicts between these two modules.

Super Order v3.0 sought to correct some long standing issues/buglets with Blindside's otherwise awesome Super Orders contirbution while adding a few new features. None of these changes would have affected how Super Orders v3.0 would work on a store running PDF Order Creator or vice versa..

DivaVocals:

I just wanted to weigh in here.. There is NOTHING in the Super Orders shop files or the install/uninstall/upgrade SQL files that would in anyway interfere with PDF Order Center.

These two modules are mutually exclusive. They do not share files and in fact (as the PDF Order Center readme states) they both can run together side by side.

Briann, if you find that these statements are not true with regards to Super Orders v3.0, please let me know where there might be conflicts between these two modules.

Super Order v3.0 sought to correct some long standing issues/buglets with Blindside's otherwise awesome Super Orders contirbution while adding a few new features. None of these changes would have affected how Super Orders v3.0 would work on a store running PDF Order Creator or vice versa..

I didn't think they did, I just let it be known that I have both installed just in case. But if you have any idea how I can fix the issue that would be great. I like some of the functions of super orders and the PDFOC too! I just want them to work!

I was looking at my cache log files and I found this:

**[13-Jan-2011 01:12:22] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/---/public_html/admin/includes/languages/english/pdfoc.php:209) in /home/---/public_html/admin/includes/init_includes/init_templates.php on line 28

**Hope this helps to find the problem and I am unsure what this means.

supersnow:

I didn't think they did, I just let it be known that I have both installed just in case. But if you have any idea how I can fix the issue that would be great. I like some of the functions of super orders and the PDFOC too! I just want them to work!Since these modules do NOT share any common files it's unlikely that having both installed would cause any issues you are having with either one..

supersnow:

I was looking at my cache log files and I found this:

[13-Jan-2011 01:12:22] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/---/public_html/admin/includes/languages/english/pdfoc.php:209) in /home/---/public_html/admin/includes/init_includes/init_templates.php on line 28

Hope this helps to find the problem and I am unsure what this means.
You reported this exact same error in the Super Orders thread, and I wanted to post this here as well.. Unfortunately just as I posted in my reply to you in the Super Orders support thread, the likely root cause of this error is because of another modification you have made in your store (inadvertently or intentionally).

It's POSSIBLE that this is related to your WordPress Integration issues. (the "headers already sent by" is a common WordPress error. This is particularly true if you are using the WOZ module which makes changes which could cause this error -- in which case you should try to track down the cause by posting your questions inthe WOZ support thread) Since I cannot see your store files I cannot say for sure what is cause of the errors you are getting..

I can say this for sure, it's likely that the error you are reporting "headers already sent by" is caused by something UNRELATED to PDF Order Center or Super Orders. These modules are not the cause of the issue, rather both of these modules are ILLUMINATING an issue whose source is elsewhere in your store.

Do a search in the forum for "headers already sent by" and you'll see this.

I did a Bing search and you can check out some of the threads on this error. Perhaps one of them contains the key to the source of the issue:
http://www.bing.com/search?q=PHP+Warning%3A+session_start%28%29+%5B%3Ca+href%3D%27function.session-start%27%3Efunction.session-start%3C%2Fa%3E%5D%3A+Cannot+send+session+cache+limiter+-+headers+already+sent+site%3Azen-cart.com&form=QBRE&qb=2

Within the research results I found this post which includes some information and links from DrByte:
http://www.zen-cart.com/forum/showthread.php?p=622932