WebsiteBaker Support (2.8.x) > Bakery Shop
Upgrading to Bakery 1.7+ : Product images disappear
freeSbee:
Looks like something is missing in your database.
Did you check the Bakery upgrade log and save a copy? Please post.
If the upgrade log is not available any more, please check your database using phpMyAdmin or similar. There must be a table named [PREFIX]mod_bakery_images. If not, create it by running the SQL query below in the SQL tab of phpMyAdmin. Make sure that you have changed the table prefix "wb_" to the one defined in your WB installation.
--- Code: ---CREATE TABLE IF NOT EXISTS `wb_mod_bakery_images` (
`img_id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL DEFAULT '0',
`item_attribute_id` int(11) NOT NULL DEFAULT '0',
`filename` varchar(150) NOT NULL DEFAULT '',
`active` enum('1','0') NOT NULL DEFAULT '1',
`position` int(11) NOT NULL DEFAULT '0',
`alt` varchar(255) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
`caption` text NOT NULL,
PRIMARY KEY (`img_id`)
);
--- End code ---
svsanchez:
Hello freeSbee, I only copied the red text with the instructions to set the image settings that appeared after the upgrade, as the rest seemed ok.
The wb_mod_bakery_image s table DOES exist, but is empty as you can see on the screenshot.
freeSbee:
I see that the table is existing and I assume that the table structure is as described in my last post.
I do not know if you have really checked the php error log. Alternatively add the lines below to the file _sync_img_helper.php right after the opening comment (licence terms and disclaimer) and before the closing php tag (at about line 19).
--- Code: ---<?php
/*
[...]
GNU General Public License for more details.
*/
// Error reporting
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
?>
<!DOCTYPE html>
[...]
--- End code ---
svsanchez:
Hello freeSbee, thank you so much for sending me the code to add to the begining of _sync_img_helper.ph p...
I copied the code, then opened the file via FTP and guess what... the whole code was on line 1. For some reason, when I uploaded the file it kind of got corrupted! I tried uploading a the file twice but each time the file got corrupted showing the whole code on line 1. So I opened the original file that I had downloaded, copied the whole code then pasted it on the uploaded file removing line 1.
After the file's code was correctly on the server, there was no need to add the extra code that you sent me: your original file worked perfectly and 266 files were found. Now all images appear again :)
Again thank you very much for your patience and help!
Navigation
[0] Message Index
[*] Previous page
Go to full version