Upgrading 1.6.0.9 to 1.6.1.1 Database

[treyj45]

Hi, I updated from 1.6.0.9 to 1.6.1.1.  All the code is up to date, but the datebase is the 1.6.0.9 version.  Is there somewhere I can see what code to run to update the tables to have proper content?  Also when I go to the products tab it says 

• Bad SQL query
  Unknown column 'image_shop.id_product' in 'on clause'

 

 

It is missing the ps_ which is what I have set as _DB_PREFIX_ in settings.inc.php file  Thank you

Edited September 2, 2015 by treyj45 (see edit history)

[musicmaster]

This is not about the prefix.

 

Prestashop added some fields with the 1.6.1 update for the purpose of optimizing speed. One of those fields is an id_product field in the (ps_)image_shop table. 

 

You can find the generators of those database changes in the install directory of a new installation in the subdirectory /install/upgrade/sql.

 

It goes step by step. So to upgrade the database from 1.6.0.9 to 1.6.1.1 you would first apply 1.6.0.10.sql, then 1.6.0.11.sql, etc. Please note that you can't use those files as they are. They use some shortcut with the prefixes.

Edited September 5, 2015 by musicmaster (see edit history)