https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


SQL error seems to be related to user groups

  • oorzaak
  • oorzaak's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 6 months ago #3474

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

The following user(s) said Thank You: tomaz, misoda

Please Log in or Create an account to join the conversation.

More
5 years 5 months ago #3476

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);

It set in the simple according to "Quick Start Guide".
It tried with some tables but the same error comes out about any.

This 'IN(3, 6)' can not be understood at all.Nowhere because there is such setting.

Sorry if being odd sentences because English is automatic translation.

Please Log in or Create an account to join the conversation.

More
5 years 5 months ago #3478

Thank you a lot for this detailed description!!! I
think we will finaly be able to reproduce this issue.

Please Log in or Create an account to join the conversation.

More
5 years 5 months ago #3479

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.

Please Log in or Create an account to join the conversation.

More
5 years 5 months ago #3480

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%') );

Please Log in or Create an account to join the conversation.

  • oorzaak
  • oorzaak's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 5 months ago #3481


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

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.323 seconds

Contact Us

Contact us on Facebook