SQL error seems to be related to user groups

Hi Tomaz,

I've encountered an issue that seems similar to the report in this forum:

www.toolsjx.com/support/help-and-support...-data-displayed#3455

After some testing I am convinced that it is related to these two things:
The menu item of the TableJX view is set up to be accessible only to a registered group of users when logged in;
The user that is viewing the item is assigned to more than one user group.

On my site, the message says (I've changed the table name):

In the part that says "WHERE IN(13, 16)" the numbers correspond with the user groups of the user but obviously the sql is incomplete; it should be stated which variable is in this range of ids. By the way, I have about 5 custom user groups on this site, with increasing access privileges, but I suppose that this happens more often and should not be a problem.

I hope that my observations are helpful to solve this issue. Also I hope that you can fix it soon as my users are very eager to have the functionality that TableJX is going to offer them


Kind regards, Frits

I want someone to help.

The following SQL error comes out and doesn't work at all.

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 'IN(3, 6)' at line 1 SQL=SELECT COUNT(*) FROM `ulj2z_users` WHERE IN(3, 6);

I saw!

Thanks to #3474 message.

'3' of IN ( 3 or 6 ) ' is the ID of the group of the frontend and '6' is the ID of the group in the backend, isn't it?
"usergroups" is missing to SQL.

Therefore, when trying by the ordinary user, logging out, it was possible to display without making an error.

When I try to run a Grid I received this Error

1064 - 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 'IN(2, 6)) AND ( UPPER(`CompanyName`) LIKE ('%AZURE CONDO%') )' at line 1 SQL=SELECT COUNT(*) FROM `grs_Vendors` WHERE (IN(2, 6)) AND ( UPPER(`CompanyName`) LIKE ('%AZURE CONDO%') );

Hi Tomaz,

Any idea when you could have solved this? I do not want to be pushy but as I said, my users are very eager to have this new functionality.


Frits