SQl error after updating to version

This is the place to post questions and comments about the FlexBanner component
Post Reply
fsiteur
Posts: 21
Joined: Mon Aug 11, 2014 3:09 pm

SQl error after updating to version

Post by fsiteur » Fri Feb 28, 2020 10:55 am

After updating to version 4.1.13 of flexbanners the banners are not displayed any more and I do get the following error message on the homepage:

Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `a`.`frontpage` = 1) AND `a`.`restrictbyid' at line 8

On other pages the banners are only showed half. I restored a back-up to go back to version 4.1.12 which solved the issue for now. Any idea what causes this error and how i can safely update to the latest version?

Thanks in advance!
Regards,
Floris

Andrew998
Posts: 1421
Joined: Wed Jan 07, 2009 10:43 am

Re: SQl error after updating to version

Post by Andrew998 » Fri Feb 28, 2020 10:57 am

I will be re-issuing 4.1.13 soon with a fix - just need to do a bit more testing.
Andrew998
Developer

fsiteur
Posts: 21
Joined: Mon Aug 11, 2014 3:09 pm

Re: SQl error after updating to version

Post by fsiteur » Fri Feb 28, 2020 11:01 am

Thanks for your quick reply! And I will wait a while before updating again :)

soundguardian
Posts: 3
Joined: Fri Feb 28, 2020 11:20 am

Re: SQl error after updating to version

Post by soundguardian » Fri Feb 28, 2020 11:22 am

Hi! I've updated component yesterday and since then I got messages on all pages: 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 'IF((select count(distinct id) from `#__flexbannersin` where `#__flexbanner' at line 5

Can you help with that as soon as possible?

Andrew998
Posts: 1421
Joined: Wed Jan 07, 2009 10:43 am

Re: SQl error after updating to version

Post by Andrew998 » Fri Feb 28, 2020 11:43 am

Go back to 4.1.12 for now. 4.1.13 will be re-issued shortly.
Andrew998
Developer

soundguardian
Posts: 3
Joined: Fri Feb 28, 2020 11:20 am

Re: SQl error after updating to version

Post by soundguardian » Fri Feb 28, 2020 12:26 pm

Where can I download thatolder version? I can't find it.

Andrew998
Posts: 1421
Joined: Wed Jan 07, 2009 10:43 am

Re: SQl error after updating to version

Post by Andrew998 » Fri Feb 28, 2020 12:36 pm

https://www.inchhosting.co.uk/releases/flexbanner/com_flexbanners_4.1.12.zip
Andrew998
Developer

soundguardian
Posts: 3
Joined: Fri Feb 28, 2020 11:20 am

Re: SQl error after updating to version

Post by soundguardian » Fri Feb 28, 2020 1:12 pm

It works. Thank you

christon133
Posts: 1
Joined: Wed Mar 18, 2020 7:08 am

Re: SQl error after updating to version

Post by christon133 » Wed Mar 18, 2020 7:11 am

After updating to new version my problem solved.

best regards
christon

Post Reply