velvetpixel Posted September 14, 2011 Posted September 14, 2011 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? osCommerce 2.3.1 Add-Ons Installed Header Tags SEO Ultimate SEO URLs Google Sitemap SEO Easy Populate QT Pro Margin Report AJAX Attribute Manager Smart Columns CKEditor OSCThumb Select Product Image Directory Category CSS Menu Enable Disable Categories Contact Form Captcha
Hotclutch Posted September 14, 2011 Posted September 14, 2011 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.
velvetpixel Posted September 14, 2011 Author Posted September 14, 2011 Thanks for the info! osCommerce 2.3.1 Add-Ons Installed Header Tags SEO Ultimate SEO URLs Google Sitemap SEO Easy Populate QT Pro Margin Report AJAX Attribute Manager Smart Columns CKEditor OSCThumb Select Product Image Directory Category CSS Menu Enable Disable Categories Contact Form Captcha
Recommended Posts
Archived
This topic is now archived and is closed to further replies.