Mysql error sending messages to the teachers

Suggestions, General Discussion and Feature Requests about eFront

Mysql error sending messages to the teachers

Postby jorgivi92 » Fri Nov 27, 2015 12:08 pm

Hello, I have a problem sending messages as a student to the teachers in a lesson, It throws this error:

mysql 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 '' at line 1] in EXECUTE("SELECT login FROM users,users_to_lessons,lessons WHERE users_to_lessons.archive=0 and lessons.archive=0 and AND AND users_to_lessons.user_type = 'professor' AND users.login=users_to_lessons.users_LOGIN AND AND users_to_lessons.lessons_ID=")

What can I do? Thanks
Posts: 2
Joined: Mon Jun 06, 2011 10:15 am

Re: Mysql error sending messages to the teachers

Postby vprountzos » Wed Dec 16, 2015 9:34 am


What version of eFront do you have installed? Could you please send me your eFront url and some users credentials in order to reproduce this?

Kind regards

V. Prountzos
Posts: 589
Joined: Tue Feb 19, 2013 11:06 am

Return to eFront

Who is online

Users browsing this forum: No registered users and 1 guest