1064 error

News & Announcements directly from the eFront team

1064 error

Postby Loise » Thu Jul 16, 2015 4:38 pm

Am loise and am having this error:
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 'Course')' at line 1] in EXECUTE("insert into events (type,users_LOGIN,users_name,users_surname,lessons_ID,timestamp,lessons_name) values (27,'student','Default','Student','26',1437037318,'Start PDTP Mentors' Course')") (1064);
am using efront version 3.6.14 version;
am also not able to turn the magic quotes off...
please help me.
Loise
 
Posts: 2
Joined: Thu Jul 16, 2015 8:59 am

Re: 1064 error

Postby vprountzos » Fri Jul 17, 2015 9:16 am

Hello Loise,

The issue that you are having is that your course name

Start PDTP Mentors' Course

contains the character ' (meaning the apostrophe). You should change the course name.
Please the this issue has been fixed in later version of eFront and you are advised to upgrade to the latest version.

Also why are you unable to turn the magic quotes off? You should contact your server admin and request this because you are going to have various issues with eFront.

Kind regards

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


Return to News and Announcements

Who is online

Users browsing this forum: No registered users and 4 guests