22 July 2019, 21:19

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" = ?

Any solution?

Thanks!!

23 July 2019, 7:48

Hi Joan,

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

Cheers

Robert

23 July 2019, 18:26

Good morning,

I only have this backtrace error that after i apply this command: php sync_users.php --institution='uvicprova'

24 July 2019, 8:16

Hi Joan,

Ok there is a bug in the code and I've made a bug report

https://bugs.launchpad.net/mahara/+bug/1837660

and a patch for it

https://reviews.mahara.org/#/c/10221/1

Please try out the fix and let me know if that works for you?

Cheers

Robert

24 July 2019, 19:04

Hi Robert,

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

Hi Joan,

Thanks for having tested the change so quickly.

Cheers

Kristina