Forums | Mahara Community

Support /
ERROR 1064 MYSQL


Joan Forcada's profile picture
Posts: 35

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

 

Any solution?

Thanks!!

 

Robert Lyon's profile picture
Posts: 511

23 July 2019, 7:48 AM

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

Joan Forcada's profile picture
Posts: 35

23 July 2019, 6:26 PM

Good morning,

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

Captura1.JPG.1

Robert Lyon's profile picture
Posts: 511

24 July 2019, 8:16 AM

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

 

Joan Forcada's profile picture
Posts: 35

24 July 2019, 7:04 PM

Hi Robert,

Definetly, this was a problem. I've implemented your solution and it's ok.

Thank you very much. 

Have a nice day.

Kristina Hoeppner's profile picture
Posts: 3864

26 July 2019, 4:14 AM

Hi Joan,

Thanks for having tested the change so quickly.

Cheers

Kristina

6 results