Joomdle 2.x Installation

SQL Error when I click on User in the joomdle component.

More
2 years 4 months ago #1 by Kevin
When I select Users in the Joomdle component i receive the following error:

An error has occurred.
42601, 7, ERROR: syntax error at or near "`" LINE 2: FROM `ngati_users` AS a ^

User sync/auth seems to be working fine between moodle and joomla aside from this error. Im not sure what the error means or what should be shown in the users screen.

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

More
2 years 3 months ago #2 by Kevin
Disregard, I was able to get it working, i had to modify the users.php file and remove the backticks from several of the following lines:

$query->from('`#__users` AS a');

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

More
2 years 3 months ago #3 by Antonio Durán
Weird, never had a problem with those. Thank you very much for letting me know about the issue.
I am not sure if it is caused by some specific setting that you may have enabled, but I will remove them for next release, as they have no real use.

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

More
2 years 3 months ago #4 by Kevin
Thanks Antonio! I am using a Postgres DB fwiw, in case that had anything to do with it.

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

More
2 years 3 months ago #5 by Antonio Durán
Thanks Kevin, I think that was the key, as not many people that I know are running Joomdle on Postgres.

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