Problems with new snapshot, old database...

[tkeats]

Here I am, deciding to upgrade to a 'new' snapshot (old is september 2002) and get everything configured. I use my OLD database in the new snapshot, just a straight 'restore' and the following results

 

Reference

http://test.rainbowcomputers.ca/admin/invoice.php?oID=1



1054 - Unknown column 'customers_company' in 'field list'



select 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, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '1'



[TEP STOP]

 

Is the missing field a result of changes in the TEP database, or is it more to do with the changes/addin that I utilized?

 

Starting to get lost with all the available options.. ;)

 

Thomas

Rainbow Computer Systems. www.rainbowcomputers.ca

:?

[gdfwilliams]

Using PHPAdmin, made these changes to the old database, then try again. I just did this this morning and it went very smoothly.

ALTER TABLE `orders` ADD customers_company varchar(32) AFTER `customers_name`, ADD delivery_company varchar(32) AFTER `delivery_name`, ADD `billing_name` varchar(64) NOT NULL AFTER `delivery_address_format_id`, ADD `billing_company` varchar(32) AFTER `billing_name`, ADD `billing_street_address` varchar(64) NOT NULL AFTER `billing_company`, ADD `billing_suburb` varchar(32) AFTER `billing_street_address`, ADD `billing_city` varchar(32) NOT NULL AFTER `billing_suburb`, ADD `billing_postcode` varchar(10) NOT NULL AFTER `billing_city`, ADD `billing_state` varchar(32) AFTER `billing_postcode`, ADD `billing_country` varchar(32) NOT NULL AFTER `billing_state`, ADD `billing_address_format_id` int(5) NOT NULL AFTER `billing_country`;

 

A good dicussion HERE: http://www.oscommerce.com/forums/viewtopic.php...cedure&start=40

[tkeats]

Attempted that, got this back...

 

 Database OSC22_20030124

Error



SQL-query:



ALTER TABLE `orders` ADD customers_company varchar(32) AFTER `customers_name`, ADD delivery_company varchar(32) AFTER `delivery_name`, ADD `billing_name` varchar(64) NOT NULL AFTER `delivery_address_format_id`, ADD `billing_company` varchar(32) AFTER `billing_name`, ADD `billing_street_address` varchar(64) NOT NULL AFTER `billing_company`, ADD `billing_suburb` varchar(32) AFTER `billing_street_address`, ADD `billing_city` varchar(32) NOT NULL AFTER `billing_suburb`, ADD `billing_postcode` varchar(10) NOT NULL AFTER `billing_city`, ADD `billing_state` varchar(32) AFTER `billing_postcode`, ADD `billing_country` varchar(32) NOT NULL AFTER `billing_state`, ADD `billing_address_format_id` int(5) NOT NULL AFTER `billing_country`;



MySQL said: You have an error in your SQL syntax near '`orders` ADD customers_company varchar(32) AFTER `customers_name`, ADD delivery_' at line 1

Back

[tkeats]

I attempted it in command line form with mysql -uuser -p

 

mysql> use OSC22_20030124;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A



Database changed

mysql> ALTER TABLE `orders` ADD customers_company varchar(32) AFTER `customers_n

ame`, ADD delivery_company varchar(32) AFTER `delivery_name`, ADD `billing_name`

varchar(64) NOT NULL AFTER `delivery_address_format_id`, ADD `billing_company`

varchar(32) AFTER `billing_name`, ADD `billing_street_address` varchar(64) NOT N

ULL AFTER `billing_company`, ADD `billing_suburb` varchar(32) AFTER `billing_str

eet_address`, ADD `billing_city` varchar(32) NOT NULL AFTER `billing_suburb`, AD

D `billing_postcode` varchar(10) NOT NULL AFTER `billing_city`, ADD `billing_sta

te` varchar(32) AFTER `billing_postcode`, ADD `billing_country` varchar(32) NOT

NULL AFTER `billing_state`, ADD `billing_address_format_id` int(5) NOT NULL AFTE

R `billing_country`;

ERROR 1064: You have an error in your SQL syntax near '`orders` ADD customers_co

mpany varchar(32) AFTER `customers_name`, ADD delivery_' at line 1

mysql>

 

Any thoughts?

Me not good with databases when it comes to errors and debugging..

 

 

Thomas

[tkeats]

Has anyone any thoughts on this??

Please?

 

Thomas

[sf7804]

I added all those feilds as well, but I just did it by hand from phpMyAdmin.. has been working fine for me :)

[gdfwilliams]

I used phpMyAdmin as well, without a problem...