[web2py] MySQL Error 1148 The used command is not allowed with this MySQL version

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' (

[web2py] MySQL Error

I have this action that verify is a group exist, if not, it create this group: verify_install = db(db.auth_group.role == 'admin').select() if not verify_install: auth.add_group('admin', 'Administrative Group') redirect

Re: [web2py] MySQL Error

Hi, order is sql keyword too. This might be helpful to you: http://web2py.com/books/default/chapter/29/6?search=check#Reserved-keywords Regards, Marin On Tue, Aug 7, 2012 at 3:05 PM, Hassan Alnatour wrote: > Dear Marin, > > I change Like To Likes but i still get errors , the traceback is : >

Re: [web2py] MySQL Error

Dear Marin, I change Like To Likes but i still get errors , the traceback is : (1064, u"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 'Order VARCHAR(255),\n SEO_Keywords LONGTEXT,\n SEO_Description LONG

Re: [web2py] MySQL Error

'Like' is an sql keyword. On Tue, Aug 7, 2012 at 1:13 PM, Hassan Alnatour wrote: > Dear ALL , > > I am trying to connect to mysql database and i keep getting this error : > > > * (1064, u"You have > an error in your SQL syntax; check the manual that corresponds to your > MySQL server version for

[web2py] MySQL Error

Dear ALL , I am trying to connect to mysql database and i keep getting this error : * (1064, u"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 'Like INT,\n Sidebar CHAR(1),\n Homepage CHAR(1),\n Order VARCH

[web2py] MySQL ERROR

Hi guys iam new to using web2py framework and iam getting this error Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/gluon/restricted.py", line 192, in restricted exec ccode in environment File "/home/oluwaseun/web2py/applications/mySQLsbApp/models/db.py", line 18, i