Just wanted to add more information. I run the exact same script on my local development machine (Win 7 x64) and it executes just fine. However when I run it within my production environment (Win Server 2008 x64), i get this error.
On Friday, November 6, 2015 at 4:31:59 PM UTC-5, Benson Myrtil wrote: > > I am attempting to run the following within executesql on a MySQL database: > > LOAD DATA LOCAL INFILE '[path]' > INTO TABLE ps_cc > CHARACTER SET UTF8 > FIELDS TERMINATED BY ',' ENCLOSED BY '"' > LINES TERMINATED BY '\r\n' > ( > fk_ps_server_id > ,fk_school_number > ,term_id > ,section_id > ,@date_enrolled > ,@date_left > ,teacher_number > ,section_number > ,course_number > ,course_name > ,expression > ,student_number > ) > SET date_enrolled = STR_TO_DATE(@date_enrolled, '%m/%d/%Y'), > date_left = STR_TO_DATE(@date_left, '%m/%d/%Y') > > However I am getting the following error: 1148 The used command is not > allowed with this MySQL version > > When I paste that same line of code inside of Workbench it executes just > fine. > > Any ideas why? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
