Upgrading 1.6.1.0 to 1.6.1.1 issue, no longer able to access my products.

[ebonsiwm]

Hello,

 

Today I tried to upgrade from 1.6.1.0 to 1.6.1.1 from the backup server and this is what happened.

 

1. One click upgrade worked ok this time except that I got the permissions issue in the end.

I was able to fix that by adding this line to my .htaccess file following Apache's configuration for the options directory;

 

Options Indexes FollowSymLinks

 

2. Passing through this point, I was able to login to the admin area and see the new Prestashop configuration and design. On accessing the live shop, the heading and foot of the shop was all ok and showing up fine...

 

3. However, none of my products could be accessed through the live shop and this error showed up in the Admin>Catalog >Products area instead;

----------------------------------------------------------------

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

----------------------------------------------------------------

- Does anyone know how to fix this?

 

Update:

Ps: Things that I already tried;

 

a. Using the PrestaShop Cleaner Module.

I tried the upgrade process twice to confirm this error issue.

 

b. First before upgrading, I update all the modules and then used the Prestashop Cleaner to clean the database from any errors. Finishing cleaning, all was ok.

 

c. After that I performed the upgrade and the same issue happened.

 

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

 

Now, how that could happen if I clean the database and according to the Prestashop Cleaner this issue had been resolved ok?

 

Obs: I tried to link an image but apparently I do not have permission here in this forum to do it.

 

Now I am just imagining someone attempting to upgrade their shop and find out in the end that all their products are out of the air because of a stupid database mistake. I think this is also a problem of structural programming issue. How come a little mistake in the database can take down a whole store?

**** But do not worry, I have backups and I can revert this in 3 minutes.

 

Thanks for your help;

 

E\

Edited August 28, 2015 by ebonsiwm (see edit history)

[tuk66]

Look at the ps_image_shop table schema. You should see four fields: id_product, id_image, id_shop, cover.