Post by vboyz » Thu Mar 19, 2009 7:25 pm

I wish to upgrade my old open cart to new open cart...
so..i have a problem with database ..

i cant find out where the images files details stored in new Opencart database

actually in new database i can see only `product_image`

In old i have ' image ' and ' image_description ' and ' product_to_image '

how i can i transfer those tables in to new database ? what is the modification for them ?


hope you people will help me soon :)

Newbie

Posts

Joined
Sat Feb 14, 2009 10:05 pm

Post by lepe » Wed Mar 25, 2009 9:29 am

(from v. 1.1.x to 1.2.x):
If I remember... you need basically to update your "product" table and set "image" field to the "filename" field in your old database "image" table.

There are several ways to do that... because I didn't have so many products, I did this:

(Execute this query in you old database):

SELECT CONCAT("UPDATE product SET image = '",filename,"' WHERE product_id =",product_id,";") FROM image LEFT JOIN product USING(image_id) WHERE product_id > 0;

Then copy and execute all those resulted querys.

Thats it! Hope it works for you!

New member

Posts

Joined
Thu Mar 19, 2009 2:10 pm
Location - Japan
Who is online

Users browsing this forum: No registered users and 58 guests