Help - Live Store

[scorpio33]

I just had my store rebuilt because my host Server crashed and he did not have my store backed up. He said that he had my store backed up on the same Server that crashed. So i lost everything. The store worked fine until he installed the tracking module. Now whenever i go to customers orders page and clikck on Details, Orders or packing slip. I get the error below. I think the error was caused becaused he installed the tracking module on top of the one that was already in the store.

 

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

 

select customers_name, 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_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, fedex_track_num, ups_track_num, usps_track_num, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '309'

 

[TEP STOP]

 

Can anyone shed some light on what could be causing this, and how to fix it. Because of this i have only made one sale since January.

 

Thanks

[davidinottawa]

I just had my store rebuilt because my host Server crashed and he did not have my store backed up. He said that he had my store backed up on the same Server that crashed.

 

Brilliant!!

 

Did you not have it backed up locally ? There are many many free scripts out there that can cron this for you :

http://www.dagondesign.com/articles/automa...comment-page-3/

 

Back up your file, and delete the bold text :

select customers_name, 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_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, fedex_track_num, ups_track_num, usps_track_num ,currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '309'

 

david

[scorpio33]

Brilliant!!

 

Did you not have it backed up locally ? There are many many free scripts out there that can cron this for you :

http://www.dagondesign.com/articles/automa...comment-page-3/

 

Back up your file, and delete the bold text :

select customers_name, 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_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, fedex_track_num, ups_track_num, usps_track_num ,currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '309'

 

david

 

Thank you David,

No, i did not back up my store because my host told me that he was doing the backup. Guess i learnt something there.

 

Where are the files located that i should delete?

[davidinottawa]

Thank you David,

No, i did not back up my store because my host told me that he was doing the backup. Guess i learnt something there.

 

Where are the files located that i should delete?

 

catalog/includes/classes/order.php and catalog/admin/includes/classes/order.php and removing the words

if you are still using the tracking stuff - then just delete :

,comments

 

d

[scorpio33]

catalog/includes/classes/order.php and catalog/admin/includes/classes/order.php and removing the words

if you are still using the tracking stuff - then just delete :

,comments

 

d

ok,

I am going to back up those two files and then delete the words in "bold" from both files. I will let you know the outcome, if not later then tomorrow.

 

Thanks again

[scorpio33]

:rolleyes:

catalog/includes/classes/order.php and catalog/admin/includes/classes/order.php and removing the words

if you are still using the tracking stuff - then just delete :

,comments

 

d

I did exactly what you told me to do. It worked. You are the greatest.

 

Thank You Again, and again