Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Upgrading DB only from 2.2RCa to 2.3.1 SQL issue


velvetpixel

Recommended Posts

Posted

I am in the process of upgrading a 2.2RCa database to 2.3.1 and have run into an issue.

 

2.3.1 core handles secondary large images using the products_images table.

 

2.2RCa database does not have a products_images table.

 

The official SQL upgrades listed in the following link do not include any queries to add that table:

http://www.oscommerce.info/confluence/display/OSCOM23/Upgrade+Guides

 

They only cover the following:

(SQL) (UP) Update Database Field Lengths

(A) (SQL) (NEW) Introduce Security Directory Permissions Feature

(AC) (SQL) (NEW) Introduce Action Recorder Feature

(AC) (SQL) (UP) Update Password Hashing to Phpass

 

Child Pages

(SQL) (UP) Update Database Field Lengths

(A) (SQL) (NEW) Introduce Security Directory Permissions Feature

(AC) (SQL) (NEW) Introduce Action Recorder Feature

(AC) (SQL) (UP) Update Password Hashing to Phpass

 

Is this omitted intentionally?

 

Should I just manually create that table based on it's setup from a default 2.3.1 install?

If so are there other SQL steps needed to make this functional?

 

Are there any other things that are known as missing for a DB upgrade to make a 2.2RCa DB compliant and matching with a 2.3.1 install?

Posted

 

Should I just manually create that table based on it's setup from a default 2.3.1 install?

 

 

Yes

 

 

 

 

Are there any other things that are known as missing for a DB upgrade to make a 2.2RCa DB compliant and matching with a 2.3.1 install?

 

You can check the reviews table as well.

Archived

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

×
×
  • Create New...