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

[Greywolf]

I have a problem with the Super Orders V2. I get an error after following the instructions in the readme.txt. Under Super Orders from the Admin->Customers->Super Orders this is the error I get:

1054 Unknown column 'customer_id' in 'field list'
in:
[select cc_cvv, customer_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, coupon_code, payment_method, payment_module_code, shipping_method, shipping_module_code, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified, order_total, order_tax, ip_address from demo_orders where orders_id = '19']
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.

Any info on how to resolve this would be great. BTW, I love this order management mod! Thanks!

[Greywolf]

I Figured it out! My mistake on a file edit. dough!!!

[rkeppert]

Umm, can you specify which customers can use any other payment option?

*whisper*
you can't with this one either.

actually, with the invoice module, i can specify customers that can use the invoicing option... just a little fyi

[DrByte]

How do I specify which customers can use the purchase order option?

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 ...

[PeterBKK]

When running the super_upgrade.php i will get this message:

1146 Table 'xxxxxxx_zc1.payment_purchase_order' doesn't exist
in:
[select * from payment_purchase_order]
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 do have a zen_payment_purchase_order table

Peter

[BlindSide]

1146 Table 'xxxxxxx_zc1.payment_purchase_order' doesn't exist
in:
[select * from payment_purchase_order]
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 do have a zen_payment_purchase_order table

Read that statement a little closer. The SQL file does not include your "zen_" table prefix. You will have to go through the file and add it. I'll add a reminder note to the Readme.

[PeterBKK]

I dont do anything exept following the upgrade.txt...
-------------------------------------------------------------------
The upgrade procedure is simple. All it does is migrate any
payment data you have in the old Super Orders to the new, more
flexible format. It does this via a PHP script which copies
data out of the old tables and inserts it into the new ones.

1. Follow the installation instructions in the readme.

2. Find the "_upgrade" folder from the zip file.

3. Upload "super_upgrade.php" directly to your "/admin" folder

4. Log into your admin and manually type in the filename.
So if the URL for your Admin index looks like this...

http://www.myshop.com/admin/index.php

You would type...

http://www.myshop.com/admin/super_upgrade.php

5. Follow the onscreen instructions.


===========
CLEANUP
===========
6. To check your work, open an order that had previous Super
Order payment data in it. You should now see that data
in the new format.

7. Make a backup copy of the old data, and then you may
remove the old "payment_" tables when you are
comfortable with the new system.

$Id: UPGRADE.txt 42 2006-08-29 14:01:34Z BlindSide $
-------------------------------------------------------------------


So i have to edit the super_upgrade.php file????????

[madk]

So i have to edit the super_upgrade.php file????????

You may have to edit it to change your db prefix.

[PeterBKK]

ok ic......

[PeterBKK]

Ehe...... Where???

My tables starts zen_

"The upgrade procedure is simple."