Hi,

I'm doing an upgrade on a heavily modified site, from v1.25 to 1.38a.
I started by installing a freash copy of 1.3.8a and then developed a new template based on the old look. However, I'm now at the stage where I'm moving over the data.

I am comparing each table from the database using a combination of mysql query browser and a file comparison tool, and although slow, it's working well so far :)

However, I've hit a small problem with the 'orders_products' table. It has an extra column 'products_prid'. Having placed test orders on the new site, I can see that this value isn't a simple NULL or 0.

How can I populate this field for each record?

So far the only info I can find is from the Zen Cart wiki DB_changelog...

#added for future orders editing
ALTER TABLE orders_products ADD products_prid TINYTEXT NOT NULL;
ALTER TABLE orders_products_attributes ADD products_prid TINYTEXT NOT NULL;
ALTER TABLE orders_products_download ADD products_prid TINYTEXT NOT NULL;

Is it safe to run these statements in this case?

Many Thanks
d.