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

[PeterBKK]

RESOLVED - almost But super_upgrade.php still dont work as it should.

I had to paste every sql comand line one by one.
I HAD to edit the super_upgrade.php by adding zen_

// migrate PO's from zen_payment_purchase_order to so_purchase_orders
$po = $db->Execute("select * from zen_payment_purchase_order");
while(!$po->EOF) {
unset($new_po);
$new_po = array();

And:

// migrate PO's from zen_payment_purchase_order to so_purchase_orders
$po = $db->Execute("select * from zen_payment_purchase_order");
while(!$po->EOF) {
unset($new_po);
$new_po = array();

And:

// migrate the data from zen_payment_check to so_payments
$payments = $db->Execute("select * from zen_payment_check");
while (!$payments->EOF) {
unset($new_payment);
$new_payment = array();

And:

// migrate the extra check data from zen_payment_check_balance to zen_so_payments
$extra_checks = $db->Execute("select * from zen_payment_check_balance
where check_direction = 1");


And:

<td><br /><INPUT TYPE="BUTTON" VALUE="SUBMIT" ONCLICK="window.location.href='/babystore/admin/super_upgrade.php?action=upgrade'"></td>
</tr>

Anything else??

Now i got this message:

1062 Duplicate entry '1' for key 1
in:
[insert into zen_so_purchase_orders (purchase_order_id, orders_id, po_number, date_posted, last_modified) values ('1', '21316', '21316', '2006-08-17 19:07:54', '2006-08-17 19:07:54')]
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.

Peter