PDFoc Trouble

[Slash74]

I have just uploaded all the files for this contibution plus intergrated super orders as well. I am now receiving an error which stipulates the following:

catalog/admin/includes/classes/split_page_results.php on line 47

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'PDFOC_ORDERLISTINGMAX_DEFAULT' at line 1
in:
[select o.orders_id, o.customers_id, o.customers_name, o.date_purchased, o.orders_status, ot.text as order_total from [*****]orders o left join [*****]orders_total ot on (o.orders_id = ot.orders_id) where (ot.class = 'ot_total') order by orders_id DESC limit -0, PDFOC_ORDERLISTINGMAX_DEFAULT]
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.

[*****] indicates my username.

I hadn't checked the outcome before intergrating super orders.

Also will this effect anything if i left it until i had received my response to have it configured correctly?

[Slash74]

Sorry forgot to mention i am running zen-cart 1.3.5v just in case this information was also required.

[Slash74]

Thanks for the help LOL...

I have managed to work out the problem myself

[mteicher]

I received the same error, and just backed out PDFOrderCenter for the time being, it appears to be something strange in the pdfoc.sql string

[paulm]

Thanks for the help LOL...

I have managed to work out the problem myself

The idea is that you also post *how* you solved it (approx).

[Slash74]

I had accidently removed the sql file. Didn't realize the remove sql removed it when you execute that file. I thought it was required to be executed so you had the option in your phpadmin to remove the contribution if need be.

[paulm]

Thanks :-)

Never thought of it that the remove.sql usage could/would be unclear. Maybe I will change the readme's of some of my own contributions to explain it's usage (better).