OLD Super Orders 2.0 (See v3.0 thread instead)

Eh, i still need help to edit the super_upgrade.php file :wacko:

SO2 does still not supports multiple currencies or am i doing something wrong:wacko: .

Se Picture:

DrByte:

Blindside's right ... however ... how would "you" determine which customers can use that option?

This technically isn't a question isolated to Super Orders directly, and so a separate topic is likely more appropriate for discussing this. If you can explain in more detail exactly the "what, how, who, and why" behind your question, then post it in the payment modules area for some possible ideas on how to rewrite the code... in the meantime, dig up your PHP books and cap and your favorite text editor ...

I would think that it would be the same type of setup, under customers, just like the invoicing option or the tax exempt option... where you have a dropdown box for the customer.

ex.

under customers, there is 2 options:

1. Discount Pricing Group
2. Tax Exempt Group

With a dropdown box in the customers profile, I could specify that a customer could use the purchase order option. This way every person placing an order would not have the option to use the purchase order option if they are not eligible for that option with us...

You **do not **need to edit the upgrade php script, it already uses the table defines so it will properly pick up your table prefix. Simply go into the SQL file, make sure that you change all DB names to include your "zen_" prefix, and run the script again.

Note that you should probably revert to your database backup in this case, since running the script more than once will create duplicate entries in some cases (i.e. the Admin configuration defines).

PeterBKK:

Eh, i still need help to edit the super_upgrade.php file :wacko:

SO2 does still not supports multiple currencies or am i doing something wrong. :wacko:
One step at a time, Peter. You haven't even done a full, proper installation yet. Do that properly, then test the currencies.

What tables in the sql file do i have to add the zen_ prefix??

ALL of them.

Like this?? But MySQL does still not like it .

-- EDIT EXISTING TABLES
ALTER TABLE orders ADD date_completed datetime default NULL;
ALTER TABLE orders ADD date_cancelled datetime default NULL;
ALTER TABLE orders ADD balance_due decimal(14,2) default NULL;

-- NEW TABLES

CREATE TABLE zen_customers_admin_notes (
admin_notes_id int(12) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
date_added datetime NOT NULL default '0000-00-00 00:00:00',
admin_id int(11) NOT NULL default '0',
admin_notes text NOT NULL,
rating tinyint(1) NOT NULL default '0',
PRIMARY KEY (admin_notes_id),
KEY customers_id (customers_id)
) TYPE=MyISAM ;

CREATE TABLE zen_so_payments (
payment_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
payment_number varchar(32) NOT NULL default '',
payment_name varchar(40) NOT NULL default '',
payment_amount decimal(14,2) NOT NULL default '0.00',
payment_type varchar(20) NOT NULL default '',
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
purchase_order_id int(11) NOT NULL default '0',
PRIMARY KEY (payment_id)
) TYPE=MyISAM ;

CREATE TABLE zen_so_payment_types (
payment_type_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
payment_type_code varchar(4) NOT NULL default '',
payment_type_full varchar(20) NOT NULL default '',
PRIMARY KEY (payment_type_id),
UNIQUE KEY type_code (payment_type_code),
KEY type_code_2 (payment_type_code)
) TYPE=MyISAM;

-- Some good default payment types
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CK', 'Check');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'MO', 'Money Order');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'ADJ', 'Adjustment');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CC', 'Credit Card');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'MC', 'Master Card');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'VISA', 'Visa');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'AMEX', 'American Express');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');

CREATE TABLE zen_so_purchase_orders (
purchase_order_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
po_number varchar(32) default NULL,
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (purchase_order_id)
) TYPE=MyISAM ;

CREATE TABLE zen_so_refunds (
refund_id int(11) NOT NULL auto_increment,
payment_id int(11) NOT NULL default '0',
orders_id int(11) NOT NULL default '0',
refund_number varchar(32) NOT NULL default '',
refund_name varchar(40) NOT NULL default '',
refund_amount decimal(14,2) NOT NULL default '0.00',
refund_type varchar(4) NOT NULL default 'CK',
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (refund_id),
KEY refund_id (refund_id)
) TYPE=MyISAM ;

-- Store Phone and Fax numbers
INSERT INTO configuration VALUES ('', 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.<br>You can call upon this by using the define <strong>STORE_FAX</strong>.', 1, 4, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Store Phone', 'STORE_PHONE', '', 'Enter the phone number for your store.<br>You can call upon this by using the define <strong>STORE_PHONE</strong>.', 1, 4, now(), now(), NULL, NULL);

-- Purchase Order payment module configs
INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');
INSERT INTO configuration VALUES (NULL, 'Make payable to:', 'MODULE_PAYMENT_PURCHASE_ORDER_PAYTO', 'Destination ImagiNation, Inc.', 'Who should payments be made payable to?', 6, 2, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Sort order of display.', 'MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 4, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Payment Zone', 'MODULE_PAYMENT_PURCHASE_ORDER_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 5, now(), now(), 'zen_get_zone_class_title', 'zen_cfg_pull_down_zone_classes(');
INSERT INTO configuration VALUES (NULL, 'Set Order Status', 'MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID', '2', 'Set the status of orders made with this payment module to this value', 6, 6, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');

-- Super Orders configuration group
INSERT INTO configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);

-- Super Orders configs (Admin > Configuration > Super Orders)
-- Automatic Status Updating
INSERT INTO configuration VALUES (NULL, 'Auto Status - Purchase Order', 'AUTO_STATUS_PO', '2', 'Number of the status assigned to an order when a purchase order is added to the payment data.', 28, 11, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Status - Payment', 'AUTO_STATUS_PAYMENT', '2', 'Number of the order status assigned when a payment (<B>not</B> attached to a purchase order) is added to the payment data.', 28, 10, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Status - P.O. Payment', 'AUTO_STATUS_PO_PAYMENT', '2', 'Number of the order status assigned when a payment <B>attached to a purchase order</B> is added to the payment data.', 28, 10, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Status - Refund', 'AUTO_STATUS_REFUND', '2', 'Number of the order status assigned when a refund is added to the payment data.', 28, 13, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Comments - Payment', 'AUTO_COMMENTS_PAYMENT', 'Payment received in our office. Payment ID: %s', 'You''ll have the option of adding these pre-configured comments to an order when a payment is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', 28, 14, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Auto Comments - P.O. Payment', 'AUTO_COMMENTS_PO_PAYMENT', 'Payment on purchase order received in our office. Payment ID: %s', 'You will have the option of adding these pre-configured comments to an order when a purchase order payment is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', 28, 14, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Auto Comments - Purchase Order', 'AUTO_COMMENTS_PO', 'Purchase Order #%s received in our office', 'You will have the option of adding these pre-configured comments to an order when a purchase order is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', 28, 15, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Auto Comments - Refund', 'AUTO_COMMENTS_REFUND', 'Refund #%s has been issued from our office.', 'You will have the option of adding these pre-configured comments to an order when a refund is entered. You can attach the refund number to the comments by typing <strong>%s</strong>.', 28, 17, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Federal Tax Exempt Number', 'FED_TAX_ID_NUMBER', '00-000000', 'If your tax exempt, then you should have a federal tax ID number. Enter the number here and the tax columns will not appear on the invoice. The number will also be displayed at the top of the invoice.', 28, 50, now(), now(), NULL , NULL);
INSERT INTO configuration VALUES (NULL, 'Closed Status - "Cancelled"', 'STATUS_ORDER_CANCELLED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Cancelled!" button on super_orders.php.<p>If you do not have a "cancel" status, or do not want assign one automatically, choose <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Closed Status - "Completed"', 'STATUS_ORDER_COMPLETED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Completed!" button on super_orders.php.<p>If you do not have a "complete" status, or do not want assign one automatically, choose <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Closed Status - "Reopened"', 'STATUS_ORDER_REOPEN', '0', 'Insert the order status ID # you would like to assign to an order when you undo the cancelled/completed status of an order.<p>If you do not have a "reopened" status, or do not want assign one automatically, choose <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');

-- Following is for a future release
-- Bar code display
--INSERT INTO configuration VALUES (NULL, 'Display bar codes', 'BC_ENABLE', 'true', 'If enabled, a bar code of the order number will appear on invoices and packing slips.', 28, 99, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
--INSERT INTO configuration VALUES (NULL, 'Bar Code Height', 'BC_HEIGHT', '60', 'Height of image in pixels.', 28, 99, now(), now(), NULL, NULL);
--INSERT INTO configuration VALUES (NULL, 'Bar Code Width', 'BC_WIDTH', '300', 'Width of image in pixels. The image MUST be wide enough to handle the length of the given value. The default value will probably be able to display about 11 digits. If you get an error message, make it wider!', 28, 99, now(), now(), NULL, NULL);
--INSERT INTO configuration VALUES (NULL, 'Bar Code Quality', 'BC_QUALITY', '100', 'For JPEG only: ranges from 0-100.', 28, 99, now(), now(), NULL, NULL);
--INSERT INTO configuration VALUES (NULL, 'Bar Code Output Format', 'BC_OUTTYPE', 'PNG', 'The graphic format for the barcode.<br />TIP: JPEG is usually the best option. PNG normally dosen''t print well, and GIF is very low-res.', 28, 99, now(), now(), NULL, 'zen_cfg_select_option(array('JPEG', 'PNG', 'GIF'),');
--INSERT INTO configuration VALUES (NULL, 'Display text of bar code contents', 'BC_TEXTSHOW', 'true', 'To disable text below barcode = 0. To enable text below barcode = 1.', 28, 99, now(), now(), NULL, 'zen_cfg_select_option(array('true', 'false'),');

I only gets timeout error when running this content in phpMyAdmin...

But everything else seems to work with SO2....

Peter

I forgott to tell that i do not have any Admin > Configuration > Super Orders as mentioned in

5. Customize Super Order Payment System
   If you used the old version of Super Orders, you'll recall all the little
   configurations I had stored as defines. Well that crap is out the window!
   Go to Admin > Configuration > Super Orders, you'll find all the configurable
   options in there, with explanations and instructions.

Peter :cry:

Peter,

You completely forgot to add the prefix to the insert statements for existing tables, i.e. configuration and orders. If you have the "zen_" prefix on your database, it's going to apply to every table.

Again, add "zen_" to every single table name, restore your DB backup, and try again.

The problem is that i dont know what is what.... i have to compare every word in this text with the 105 tables names in my mysql...:cry:

ALTER TABLE orders 

orders is a table

INSERT INTO configuration

configuration is a table

That's all your missing, you're so close! Look for those two words in the file.

Still time out :cry:

-- EDIT EXISTING TABLES
ALTER TABLE zen_orders ADD date_completed datetime default NULL;
ALTER TABLE zen_orders ADD date_cancelled datetime default NULL;
ALTER TABLE zen_orders ADD balance_due decimal(14,2) default NULL;

-- NEW TABLES

CREATE TABLE zen_customers_admin_notes (
admin_notes_id int(12) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
date_added datetime NOT NULL default '0000-00-00 00:00:00',
admin_id int(11) NOT NULL default '0',
admin_notes text NOT NULL,
rating tinyint(1) NOT NULL default '0',
PRIMARY KEY (admin_notes_id),
KEY customers_id (customers_id)
) TYPE=MyISAM ;

CREATE TABLE zen_so_payments (
payment_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
payment_number varchar(32) NOT NULL default '',
payment_name varchar(40) NOT NULL default '',
payment_amount decimal(14,2) NOT NULL default '0.00',
payment_type varchar(20) NOT NULL default '',
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
purchase_order_id int(11) NOT NULL default '0',
PRIMARY KEY (payment_id)
) TYPE=MyISAM ;

CREATE TABLE zen_so_payment_types (
payment_type_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
payment_type_code varchar(4) NOT NULL default '',
payment_type_full varchar(20) NOT NULL default '',
PRIMARY KEY (payment_type_id),
UNIQUE KEY type_code (payment_type_code),
KEY type_code_2 (payment_type_code)
) TYPE=MyISAM;

-- Some good default payment types
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CK', 'Check');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'MO', 'Money Order');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'ADJ', 'Adjustment');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CC', 'Credit Card');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'MC', 'Master Card');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'VISA', 'Visa');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'AMEX', 'American Express');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');

CREATE TABLE zen_so_purchase_orders (
purchase_order_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
po_number varchar(32) default NULL,
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (purchase_order_id)
) TYPE=MyISAM ;

CREATE TABLE zen_so_refunds (
refund_id int(11) NOT NULL auto_increment,
payment_id int(11) NOT NULL default '0',
orders_id int(11) NOT NULL default '0',
refund_number varchar(32) NOT NULL default '',
refund_name varchar(40) NOT NULL default '',
refund_amount decimal(14,2) NOT NULL default '0.00',
refund_type varchar(4) NOT NULL default 'CK',
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (refund_id),
KEY refund_id (refund_id)
) TYPE=MyISAM ;

-- Store Phone and Fax numbers
INSERT INTO zen_configuration VALUES ('', 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.<br>You can call upon this by using the define <strong>STORE_FAX</strong>.', 1, 4, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES ('', 'Store Phone', 'STORE_PHONE', '', 'Enter the phone number for your store.<br>You can call upon this by using the define <strong>STORE_PHONE</strong>.', 1, 4, now(), now(), NULL, NULL);

-- Purchase Order payment module configs
INSERT INTO zen_configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');
INSERT INTO zen_configuration VALUES (NULL, 'Make payable to:', 'MODULE_PAYMENT_PURCHASE_ORDER_PAYTO', 'Destination ImagiNation, Inc.', 'Who should payments be made payable to?', 6, 2, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Sort order of display.', 'MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 4, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Payment Zone', 'MODULE_PAYMENT_PURCHASE_ORDER_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 5, now(), now(), 'zen_get_zone_class_title', 'zen_cfg_pull_down_zone_classes(');
INSERT INTO zen_configuration VALUES (NULL, 'Set Order Status', 'MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID', '2', 'Set the status of orders made with this payment module to this value', 6, 6, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');

-- Super Orders configuration group
INSERT INTO zen_configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);

-- Super Orders configs (Admin > Configuration > Super Orders)
-- Automatic Status Updating
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - Purchase Order', 'AUTO_STATUS_PO', '2', 'Number of the status assigned to an order when a purchase order is added to the payment data.', 28, 11, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - Payment', 'AUTO_STATUS_PAYMENT', '2', 'Number of the order status assigned when a payment (<B>not</B> attached to a purchase order) is added to the payment data.', 28, 10, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - P.O. Payment', 'AUTO_STATUS_PO_PAYMENT', '2', 'Number of the order status assigned when a payment <B>attached to a purchase order</B> is added to the payment data.', 28, 10, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - Refund', 'AUTO_STATUS_REFUND', '2', 'Number of the order status assigned when a refund is added to the payment data.', 28, 13, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - Payment', 'AUTO_COMMENTS_PAYMENT', 'Payment received in our office. Payment ID: %s', 'You''ll have the option of adding these pre-configured comments to an order when a payment is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', 28, 14, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - P.O. Payment', 'AUTO_COMMENTS_PO_PAYMENT', 'Payment on purchase order received in our office. Payment ID: %s', 'You will have the option of adding these pre-configured comments to an order when a purchase order payment is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', 28, 14, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - Purchase Order', 'AUTO_COMMENTS_PO', 'Purchase Order #%s received in our office', 'You will have the option of adding these pre-configured comments to an order when a purchase order is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', 28, 15, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - Refund', 'AUTO_COMMENTS_REFUND', 'Refund #%s has been issued from our office.', 'You will have the option of adding these pre-configured comments to an order when a refund is entered. You can attach the refund number to the comments by typing <strong>%s</strong>.', 28, 17, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Federal Tax Exempt Number', 'FED_TAX_ID_NUMBER', '00-000000', 'If your tax exempt, then you should have a federal tax ID number. Enter the number here and the tax columns will not appear on the invoice. The number will also be displayed at the top of the invoice.', 28, 50, now(), now(), NULL , NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Closed Status - "Cancelled"', 'STATUS_ORDER_CANCELLED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Cancelled!" button on super_orders.php.<p>If you do not have a "cancel" status, or do not want assign one automatically, choose <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Closed Status - "Completed"', 'STATUS_ORDER_COMPLETED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Completed!" button on super_orders.php.<p>If you do not have a "complete" status, or do not want assign one automatically, choose <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Closed Status - "Reopened"', 'STATUS_ORDER_REOPEN', '0', 'Insert the order status ID # you would like to assign to an order when you undo the cancelled/completed status of an order.<p>If you do not have a "reopened" status, or do not want assign one automatically, choose <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');

-- Following is for a future release
-- Bar code display
--INSERT INTO zen_configuration VALUES (NULL, 'Display bar codes', 'BC_ENABLE', 'true', 'If enabled, a bar code of the order number will appear on invoices and packing slips.', 28, 99, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
--INSERT INTO zen_configuration VALUES (NULL, 'Bar Code Height', 'BC_HEIGHT', '60', 'Height of image in pixels.', 28, 99, now(), now(), NULL, NULL);
--INSERT INTO zen_configuration VALUES (NULL, 'Bar Code Width', 'BC_WIDTH', '300', 'Width of image in pixels. The image MUST be wide enough to handle the length of the given value. The default value will probably be able to display about 11 digits. If you get an error message, make it wider!', 28, 99, now(), now(), NULL, NULL);
--INSERT INTO zen_configuration VALUES (NULL, 'Bar Code Quality', 'BC_QUALITY', '100', 'For JPEG only: ranges from 0-100.', 28, 99, now(), now(), NULL, NULL);
--INSERT INTO zen_configuration VALUES (NULL, 'Bar Code Output Format', 'BC_OUTTYPE', 'PNG', 'The graphic format for the barcode.<br />TIP: JPEG is usually the best option. PNG normally dosen''t print well, and GIF is very low-res.', 28, 99, now(), now(), NULL, 'zen_cfg_select_option(array('JPEG', 'PNG', 'GIF'),');
--INSERT INTO zen_configuration VALUES (NULL, 'Display text of bar code contents', 'BC_TEXTSHOW', 'true', 'To disable text below barcode = 0. To enable text below barcode = 1.', 28, 99, now(), now(), NULL, 'zen_cfg_select_option(array('true', 'false'),');

Are you running this SQL using the "Install SQL Patches" tool in the admin, or are you using phpMyAdmin? If you're using phpMyAdmin, you should get an error message, not just a straight timeout. Is there something else on the screen? Did you restore your database from a backup before running it again?

Give me a reminder here.. why do some people have to add zen_ to the tables and others don't? I know I've read that caution a lot, but I've never had to do it.

With regards to your timeouts, perhaps you can break the SQL Query into sections and do it one by one? It sounds like you don't know much about SQL... it is confusing at first but not hard. Search on Google for "mysql tutorial" and spend some time reading to you have a better understanding of this. I know its frustrating at first, but it is worth it.

Good luck with it!

• Steven

Im using phpMyAdmin as install SQL patches in admin from a file does almost never works. I have to paste it in.... but that did not seems work with the SO2 sql-file

This is the message:
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/sql.php on line 48

Aha, so your having some upload issues. The speed of the script is not really determined by the file (I can run this file in under 10 sec), but by your sever setup and specs. The fact that you have to paste it in may be part of the problem too, as it's quite long. Why can't you use phpMyAdmin's ability to read from a file?

Search the forums for other posts concerning speed issues, obviously looking for ones dealing with SQL patches. You should also look around for threads concerning CPanel (note: I would avoid those 3rd party web interfaces as much as possible. It's almost always better to do it "yourself" via SSH).

Beyond that, you'll need to contact your hosting company and explain what your doing, the error you get, and see what advice they have for you.

Just DL and installed.
With limited testing everything seems to working fine, however,
Super orders does appear in the Admin> Configure menu.

Any clue.

Great Addition to ZenCart!

Now i have run the original sql file (no prefix in the DB) to my localy installed clean ZC-shop. I still have problems with phpmyadmin (WAMP5):

This message when importing the file:

Error
SQL query:
-- Following is for a future release
-- Bar code display

• • INSERT INTO configuration
    VALUES (
    NULL , 'Display bar codes', 'BC_ENABLE', 'true', 'If enabled, a bar code of the order number will appear on invoices and packing slips.', 28, 99, now( ) , now( ) , NULL , 'zen_cfg_select_option(array(''true'', ''false''),'
    );
    MySQL said:
    #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 '--INSERT INTO configuration VALUES (NULL, 'Display bar codes', 'BC_ENABLE', 'tru' at line 1

This message when pasted the contents:

Error
SQL query:
-- EDIT EXISTING TABLES
ALTER TABLE orders ADD date_completed datetime default NULL ;
MySQL said:
#1060 - Duplicate column name 'date_completed'

I installed a brand new shop www.siamon.net/test2 and run the zen_ modified sql file... still get Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/sql.php on line 160.

But now i can see the super order in admin/configuration. :smile:

See by your self.

User: test2
password: test2

Peter:cry: