Forums | Mahara Community
ERROR 1064 MYSQL
22 July 2019, 9:19 PM
I have a problem when I execute this command to upload users a new institution:
php sync users.php --institution='uvic prova'
This is message error:
Failed to get a recordset: mysqli error: [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 '? LIMIT 2' at line 1] in EXECUTE("SELECT * FROM "usr" WHERE "id" = ? LIMIT 2")Command was: SELECT * FROM "usr" WHERE "id" = ?
23 July 2019, 7:48 AM
Are you able to provide some more detail about the error? Some backtrace about what file / line that error comes from would help track down the problem
23 July 2019, 6:26 PM
I only have this backtrace error that after i apply this command: php sync_users.php --institution='uvicprova'
24 July 2019, 7:04 PM
Definetly, this was a problem. I've implemented your solution and it's ok.
Thank you very much.
Have a nice day.
26 July 2019, 4:14 AM
Thanks for having tested the change so quickly.