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 users.active=1 AND users_to_lessons.active=1 AND users_to_lessons.user_type = 'professor' AND users.login=users_to_lessons.users_LOGIN AND users_to_lessons.lessons_ID=lessons.id AND users_to_lessons.lessons_ID=")

What can I do? Thanks
jorgivi92
 
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

Hello,

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
vprountzos
 
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