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

[dealbyethan.com]

Hi,

I installed Super Order module recently. When I ran the SQL file, I received the following error.

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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 did what was suggested in this thread by checking duplicate lines in phpmyadmin. I then ran the lines that don't exist yet in the database. Everything seems to be in the database now except the following one.

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

When I ran this line, I received the following error. I checked the database but this line does not exist. Any suggestion? Thanks in advance.

1062 Duplicate entry '28' for key 1
in:
[INSERT INTO zen_configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 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.

[dealbyethan.com]

For your information, I just found out that I could not find Admin > Configuration > Super Orders in my admin. What did I do wrong?

[dealbyethan.com]

Okay, I found out the reason why I am getting the 1062 duplicate entry '28' for key 1 is because the following SQL line

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

has been inserted into the previously taken id field 28, namely the SEO URL. Should I remove these? Should I change the id field for Super Orders to something new instead of 28?

Any suggestion will be greatly appreciated. Thanks a lot.

[topcat24]

Just change the number 28 in the sql line to the next available number in the configuration group

[dealbyethan.com]

Hi,

Thanks for your response. Do I change the id for Super Order or SEO URL? Would this cause any damage? What about those Super Order stuff that has been inserted into the SEO URL configuration group? How do I remove them?

[topcat24]

If your happy with messing about with your database I would change the id for SEO as this is normally put in the next available slot but with Super orders it is 28 and any changes to Super Orders will be made with this number (otherwise just change the number 28 in the sql for Super Orders from -- Super Orders configuration group onwards (13 lines)

you would have to have a look in configuration (16 entries) and configuration group (1 entry) to change the SEO configuration_group_id

[dealbyethan.com]

Hi,

Thanks for your help.

If worse come to worst, I am thinking to restore my database. Do you know how exactly I can do it? I am concerned that something bad might happen. Please advise. Thanks again.

[dealbyethan.com]

change the number 28 in the sql for Super Orders from -- Super Orders configuration group onwards (13 lines)

If I change the Super Order id to something else, would those Super Order configuration previously inserted into the the SEO URL configuration be automatically removed? Thanks.

[dealbyethan.com]

YAY! I solved the problem. Thanks to topcat24. Based on his suggestion, I first re-ran the following sql line after changing the configuration group id '28' to something else, for example '50'.

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

Then I changed the Super Order configuration id in the configuration table of the database (all 12 entries) to '50' using phpmyadmin.

I hope this is helpful for those who are struggling with the same problem. Good luck everyone. Thanks again.

[jeffwebb]

I have an interesting problem I hope you all can help with. I'm totally sold on Super Orders. However, I'm using both the USPS and UPS shipping modules. When people select overnight shipping, for example, super orders just says "UPS" in the order. If I switch over to the standard order system, the full line "UPS: overnight" (or whatever they selected) is there. So, the information is being captured by the system, but SO is not showing it. So, we have to log into the regular ordering system to see what shipping method they chose.

Anyone have any ideas?

Had the same problem. This worked for me.


For Print Data Sheet (admin/super_data_sheet.php) around line 183:

<?php
// Short shipping display
// Formats shipping entry to remove the TEXT_WAY define
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
// if ($order->totals[$i]['class'] == 'ot_shipping') {
// $format_shipping = explode(" (", $order->totals[$i]['title'], 2);
// $clean_shipping = rtrim($format_shipping[0], ":");
// $display_title = $clean_shipping . ':';
// }
// else {
// $display_title = $order->totals[$i]['title'];
// }
$display_title = $order->totals[$i]['title'];


For Invoice (admin/super_invoice.php) around line 262:

<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
// if ($order->totals[$i]['class'] == 'ot_shipping') {
// $format_shipping = explode(" (", $order->totals[$i]['title'], 2);
// $clean_shipping = rtrim($format_shipping[0], ":");
// $display_title = $clean_shipping . ':';
// }
// else {
// $display_title = $order->totals[$i]['title'];
// }
$display_title = $order->totals[$i]['title'];


For Packing Slip (admin/super_packingslip.php) around line 145:

<?php
// Trim shipping details
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
if ($order->totals[$i]['class'] == 'ot_shipping') {
// $format_shipping = explode(" (", $order->totals[$i]['title'], 2);
// $shipping_method = rtrim($format_shipping[0], ":");
$shipping_method = $order->totals[$i]['title'];

break;
}
}
?>


Hope this helps.