Logical IT Posted August 13, 2014 Share Posted August 13, 2014 Today, I upgraded a clients site from 1.6.0.8 -> 1.6.0.9 and after the upgrade I discovered this error when trying to upload a product image - 'an error occurred while creating an additional image'This what I did to debug and fix the issue:1. I Turned on PrestaShop developer mode - To put PrestaShop in development mode open /config/defines.inc.php file - Find the line of code that reads "define('_PS_MODE_DEV_', false);" - and change it to read "define('_PS_MODE_DEV_', true);"3. in Chrome browser I opened the javascript console (f12) and discovered the following error:<div class="alert alert-danger"> <button type="button" class="close" data-dismiss="alert">×</button> Unknown column 'hover' in 'field list'<br /><br /><pre>INSERT INTO `ps_image` (`id_product`, `position`, `cover`, `hover`) VALUES ('15', '3', '1', '0')</pre></div>4. It appears the field 'hover' is missing from the ps_image table in the database. To fix this I simply created a new field called 'hover' to both ps_image and ps_image_shop tables. I copied the same field definitions from the 'cover' field. 1 Link to comment Share on other sites More sharing options...
The Owl Posted August 19, 2015 Share Posted August 19, 2015 Did this resolve the issue completely? Also, your post looks like its missing a #2. Was there another step? Link to comment Share on other sites More sharing options...
Logical IT Posted August 19, 2015 Author Share Posted August 19, 2015 Yes, it fixed the issue, however since working with the latest prestashop versions, I have not seen this bug, so I guess it's been fixed in the latest releases. Sorry, looks like I can't count, step 2 is not missing. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now