- Posts: 11
Joomdle 2.x Installation
SQL Error when I click on User in the joomdle component.
- Kevin
- Topic Author
- Offline
- New Member
-
Less
More
2 years 4 months ago #1
by Kevin
SQL Error when I click on User in the joomdle component. was created 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.
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.
- Kevin
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
2 years 3 months ago #2
by Kevin
Replied by Kevin on topic SQL Error when I click on User in the joomdle component.
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');
$query->from('`#__users` AS a');
Please Log in or Create an account to join the conversation.
- Antonio Durán
-
- Offline
- Moderator
-
Less
More
- Posts: 7926
2 years 3 months ago #3
by Antonio Durán
Replied by Antonio Durán on topic SQL Error when I click on User in the joomdle component.
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.
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.
- Kevin
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
2 years 3 months ago #4
by Kevin
Replied by Kevin on topic SQL Error when I click on User in the joomdle component.
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.
- Antonio Durán
-
- Offline
- Moderator
-
Less
More
- Posts: 7926
2 years 3 months ago #5
by Antonio Durán
Replied by Antonio Durán on topic SQL Error when I click on User in the joomdle component.
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.