Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Transfer the OSCommerce


oioioioioi

Recommended Posts

Hi,

 

I just transfer the working OsCommerce from 1 server to another one (different websites) ... I'm newbie ... I just download and upload from 1 site to another and then I create and restored a back-up file BUT I guess smthg is wrong as the names of the databases is different ..

 

All seems ok as presentation, surfing the shop, etc...but when I tried to login as a user I get this error message:

 

"1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '3' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]"

 

Wha't wrong? What did I do wrong ?

 

What's the best way to migrate a shop from 1 server to another (different websites)

Link to comment
Share on other sites

I DID THIS AND IT WORKEd! THANKS!

 

QUOTE (phillipsmind @ Feb 6 2008, 07:36 AM) *

Run this SQL statement to fix your issue. This will create the table elements that are missing.

 

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...