SQl error after updating to version
SQl error after updating to version
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
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
Re: SQl error after updating to version
I will be re-issuing 4.1.13 soon with a fix - just need to do a bit more testing.
Andrew998
Developer
Developer
Re: SQl error after updating to version
Thanks for your quick reply! And I will wait a while before updating again 

-
- Posts: 3
- Joined: Fri Feb 28, 2020 11:20 am
Re: SQl error after updating to version
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?
Can you help with that as soon as possible?
Re: SQl error after updating to version
Go back to 4.1.12 for now. 4.1.13 will be re-issued shortly.
Andrew998
Developer
Developer
-
- Posts: 3
- Joined: Fri Feb 28, 2020 11:20 am
Re: SQl error after updating to version
Where can I download thatolder version? I can't find it.
Re: SQl error after updating to version
https://www.inchhosting.co.uk/releases/flexbanner/com_flexbanners_4.1.12.zip
Andrew998
Developer
Developer
-
- Posts: 3
- Joined: Fri Feb 28, 2020 11:20 am
Re: SQl error after updating to version
It works. Thank you
-
- Posts: 1
- Joined: Wed Mar 18, 2020 7:08 am
Re: SQl error after updating to version
After updating to new version my problem solved.
best regards
christon
best regards
christon