J-BusinessDirectory - Issue adding new listing without address

Support Forum

 
 

 

Hello,
I try to install a new directory related only to "website",
then I don't need the address-related fields and all related fields are then disabled.
When I try to insert a new website I have the following error (in frontend and in backend) :

Save failed with the following error: Incorrect decimal value: '' for column `data_site02`.`joss_jbusinessdirectory_companies`.`activity_radius` at row 1

 

For Business type, when I try to save: "Save failed with the following error: Incorrect integer value: '' for column `data_site02`.`joss_jbusinessdirectory_company_types`.`company_view` at row 1"

New installation
Joomla: 4.2.6
Version J-BusinessDirectory: 5.8.1
PHP : 7.4.33
Enable offers: No
Enable events: No
Business Listing Attributes:
website, type, slogan, description, category, logo: Mandatory
keywords, custom_tab, Facebook, Twiter: optional
Other fields: address, street_number, city,... Not show

Best Regards,

Renato

7 replies

Have you tried to make a support ticket for this?

Hi ssnobben,

Thank You for your answer.
An update :
When in "General Settings" -> attribute configuration -> Business Listing Attributes

I made this: Country: "Mandatory" and "Radius" Mandatory (in place of Not Shown)
When I submit a listing, if Radius=0, I have the error code, if I insert a number all is OK.
I guess that there is a problem with the code.

Best Regards,

Renato

This issue has been fixed since version 5.8.1.
We have also released v5.8.2 yesterday. You can download the latest version from your account.

Did the last update solved this problem Renato?

Hello Hi ssnobben,

Thank you for your help, and the update.

With the new version 5.8.2 I don't have the error with the listing.


But with "Business type", when
- I add a new type it's ok
- I want to make an update: changing the name or changing "only for admin", I have still:
"Save failed with the following error: Incorrect integer value: '' for column `data_site02`.`joss_jbusinessdirectory_company_types`.`company_view` at row 1"

 

Best Regards,

Renato

 

Do a new support ticket for this I think is best and explain well what you want to do...

We could not reproduce the issue on our servers. Please create a ticket for this.

 
 
 

8 Item(s)

Show per page