Component ignores groups access level

This is the place to post questions and comments about the FlexBanner component
macstalker
Posts: 10
Joined: Sat Feb 15, 2020 7:23 pm

Re: Component ignores groups access level

Post by macstalker » Fri Feb 28, 2020 3:50 pm

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


And upload still does not work. I sent you recently by PM access credentials to check uploading.

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

Re: Component ignores groups access level

Post by Andrew998 » Fri Feb 28, 2020 3:55 pm

When did you download it, I only uploaded it in the last few minutes?

I can't access your site because it says my IP address is blocked.
Andrew998
Developer

macstalker
Posts: 10
Joined: Sat Feb 15, 2020 7:23 pm

Re: Component ignores groups access level

Post by macstalker » Fri Feb 28, 2020 4:02 pm

Sorry for that, now you should have access.
I just tried one more time, same thing:

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

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

Re: Component ignores groups access level

Post by Andrew998 » Fri Feb 28, 2020 4:15 pm

You have not got the latest version there. Try downloading it again.
Andrew998
Developer

macstalker
Posts: 10
Joined: Sat Feb 15, 2020 7:23 pm

Re: Component ignores groups access level

Post by macstalker » Fri Feb 28, 2020 4:25 pm

Same thing. Can not upload. I'm trying on another website with active banners also and get same error, all banners gone from frontend

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

Re: Component ignores groups access level

Post by Andrew998 » Fri Feb 28, 2020 5:22 pm

I had no problem on your demo site.

What error are you seeing?
Andrew998
Developer

macstalker
Posts: 10
Joined: Sat Feb 15, 2020 7:23 pm

Re: Component ignores groups access level

Post by macstalker » Fri Feb 28, 2020 8:27 pm

BTW, uploading starts working after removing this code from edit.php

&&
(
document.adminForm.jform_imageurl.value.test(/gif/g)
||document.adminForm.jform_imageurl.value.test(/png/g)
||document.adminForm.jform_imageurl.value.test(/jpg/g)
)

I think the problem with ...test. I scanned whole FlexBanner installation package and there is no "test" function at all :(

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

Re: Component ignores groups access level

Post by Andrew998 » Sat Feb 29, 2020 11:22 am

I think it is all working now.
Andrew998
Developer

macstalker
Posts: 10
Joined: Sat Feb 15, 2020 7:23 pm

Re: Component ignores groups access level

Post by macstalker » Sun Mar 01, 2020 9:13 pm

Great, thanks a lot!

BTW, I managed to fix image selecting issue by replacing this code in edit.php:

document.adminForm.jform_imageurl.value.test(/gif/g)
||document.adminForm.jform_imageurl.value.test(/png/g)
||document.adminForm.jform_imageurl.value.test(/jpg/g)

with:

document.adminForm.jform_imageurl.value.match(/(gif|png|jpg|jpeg)$/)

macstalker
Posts: 10
Joined: Sat Feb 15, 2020 7:23 pm

Re: Component ignores groups access level

Post by macstalker » Mon Mar 02, 2020 5:38 am

Sorry Andrew, there is another issues. Banners can not be published/unpublished thru checkboxes nor status buttons in the banner list view. The only way is to open each banner individually and using dropdown menu.

Console shows warnings on changing status in the list view:

window.listItemTask() is deprecated use Joomla.listItemTask() instead
window.submitform() is deprecated use Joomla.submitform() instead


Another minor issue is "Save as Copy" in Edit Banner has different behavior than other joomla components. It would be great if it kept current banner open instead of closing it and did not add "Copy " in front of the name if name was already modified after previous save.

Thanks!

Post Reply