J-BusinessDirectory - Category Images Removed when Upgrading to 2.4.1

Upgrade causes loss of all category images.  The main image for the categories is lost, removed from the database, during the upgrade to 2.4.1.  need to prevent / correct this in your SQL file.

Hi,

The location of images changed to media folder. If you already have set some images for categories please use the following sql:

update #__hotelreservation_offers_pictures set imageLocation = REPLACE(imageLocation ,'/upload/images','');

I had the same problem and I tried the SQL query you provided but I received a syntax error. 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

This is my version info: MySQL version 5.1.71-rel14.9-log

Also, I realized your original SQL query includes the wrong table for this extension.  I changed it, but it still didn't work.

Well, I kinda figured it out but it didn't work so...

I used this SQL query

update b6zvo_jbusinessdirectory_companies set logoLocation = {REPLACE(logoLocation ,'/upload/images','')};

It ran but didnt actually fix the problem.

Also, I no longer see any of the "business media" images in the companies (videos are OK) and I lost my category drop down menu.

Hi,

Can you provide us joomla admin acces to check where the problem lies? (use contact form)