problems installing PDF Order Center

[francocauter]

I would like some help from DrByte Please
I get this error when I try to install the SQL patch:

Errore

query SQL:
#NEXT_X_ROWS_AS_ONE_COMMAND:2
INSERT INTO configuration_group
VALUES ( '', 'PDF Order Center', 'User-customizable defaults for PDF Order Center.', @sortorder +1, 1
);


Messaggio di MySQL:
#1136 - Column count doesn't match value count at row 1

I would really like some help please
Thanks in advance

[DrByte]

I get this error when I try to install the SQL patch:

Errore

query SQL:
#NEXT_X_ROWS_AS_ONE_COMMAND:2
INSERT INTO configuration_group
VALUES ( '', 'PDF Order Center', 'User-customizable defaults for PDF Order Center.', @sortorder +1, 1
);


Messaggio di MySQL:
#1136 - Column count doesn't match value count at row 1

I would really like some help please
Thanks in advance

What version of Zen Cart are you using?
What other addons/contributions have you installed, besides the PDF order center?
What version of Zen Cart was this PDF Order Center contribution written for?

[francocauter]

Version of zen-cart 1.3.7 patch:1
No other invoice modules installed. I have installed other shipping modules and the vat mod for european companies

This is the info on the PDFOC mod:


Download Now!
File size: 257290 bytes
Downloaded: 4331 times
Zen Cart™ Version: v1.3.0
Version: 1.1.1
Last Updated: Jun 12 2006
Author: Grayson

What Is PDF Order Center?
-=-=-=-=-=-=-=-=-=-=-=-=-

PDF Order Center is an alternative to the default ZC order processing setup in Admin::Customer::Orders for people who want to print PDF instead of HTML files. Like the default setup, PDFOC allows you to update order status, optionally including comments, optionally e-mailing the customer; delete an order; and print an invoice or packing slip for an order. But PDFOC also allows you to:

- process multiple orders at a time (batch processing)
- print shipping labels
- print price quotes and credit invoices
- make minor customizations to the invoice format from the PDFOC control panel
- create a unique, sequential invoice number for each order

And as the name implies, PDFOC creates PDF invoices, packing slips, etc. PDFOC works with a template system, which allows you to easily add additional document formats as desired.

For the record: PDFOC is not nearly as comprehensive as the Super Orders contribution from BlindSide (Frank Koehl). PDFOC began as a port of Batch Print Center from osCommerce to Zen Cart. Along the way I spiffed up the interface and gradually expanded it to take over all the functionality of the default Zen Cart orders.php page, and added in a couple of extra features. PDFOC is meant to complement Super Orders, as an alternative for folks who want to be able to batch-print PDF invoices, packing slips, etc. You can use both contributions in your store.

thanks

[DrByte]

well, something has modified the structure of your configuration_group table.

To work around that, you'll need to modify the pdfoc.sql file:

change this:

#NEXT_X_ROWS_AS_ONE_COMMAND:2
INSERT INTO configuration_group
VALUES ('', 'PDF Order Center', 'User-customizable defaults for PDF Order Center.', @sortorder+1, 1);

to this:

#NEXT_X_ROWS_AS_ONE_COMMAND:2
INSERT INTO configuration_group (configuration_group_title, configuration_group_description, sort_order, visible)
VALUES ('PDF Order Center', 'User-customizable defaults for PDF Order Center.', @sortorder+1, 1);

Also, since you've already run the commands earlier in the file, you'll need to REMOVE this part from the top of the file before you run it again to finish installation:

#NEXT_X_ROWS_AS_ONE_COMMAND:
CREATE TABLE orders_invoices (
orders_invoices_id int(11) NOT NULL auto_increment,
invoice_date datetime NOT NULL default '0000-00-00 00:00:00',
order_tax decimal(15,4) NOT NULL default '0.0000',
order_total decimal(15,4) NOT NULL default '0.0000',
invoice_type char(2) NOT NULL default '',
orders_id int(11) NOT NULL default '0',
PRIMARY KEY (orders_invoices_id)
) TYPE=MyISAM ;

[francocauter]

Thanks for your reply DrByte
I now get this error:

1054 Unknown column 'configruation_group_description' in 'field list'
in:
[INSERT INTO configuration_group (configuration_group_title, configruation_group_description, sort_order, visible) VALUES ('PDF Order Center', 'User-customizable defaults for PDF Order Center.', @sortorder+1, 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.

I also deleted the table orders_invoices from the MySQL database

still getting the same error

Best Regards

[DrByte]

oops ... I made a typo ... "configruation_group_description"

[francocauter]

Thanks DrByte for the quick reply
I should have seen that myself
I managed to do the table in the database and I can see the PDFOC
In the end maybe was not worth the effort as I found I can print to PDF from the Orders/Invoice from the zen-cart normal orders module
thanks for your help
best regards