'Like' is an sql keyword. On Tue, Aug 7, 2012 at 1:13 PM, Hassan Alnatour <[email protected]>wrote:
> Dear ALL , > > I am trying to connect to mysql database and i keep getting this error : > > > *<class 'gluon.contrib.pymysql.err.ProgrammingError'> (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 VARCHAR(255),\n ' at line 22")* > * > * > Traceback (most recent call last): > File "C:\web2py\gluon\restricted.**py", line 204, in restricted > exec ccode in environment > File > "C:/web2py/applications/**latesti3zif/models/db.py"<http://127.0.0.1:8000/admin/edit/latesti3zif/models/db.py>, > line 298, in <module> > Field('SEO_Description','text'**)) > File "C:\web2py\gluon\dal.py", line 5097, in define_table > polymodel=polymodel) > File "C:\web2py\gluon\dal.py", line 705, in create_table > self.create_sequence_and_**triggers(query,table) > File "C:\web2py\gluon\dal.py", line 1348, in create_sequence_and_triggers > self.execute(query) > File "C:\web2py\gluon\dal.py", line 1359, in execute > return self.log_execute(*a, **b) > File "C:\web2py\gluon\dal.py", line 1353, in log_execute > ret = self.cursor.execute(*a, **b) > File "C:\web2py\gluon\contrib\**pymysql\cursors.py", line 108, in execute > self.errorhandler(self, exc, value) > File "C:\web2py\gluon\contrib\**pymysql\connections.py", line 184, in > defaulterrorhandler > raise errorclass, errorvalue > ProgrammingError: (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 VARCHAR(255),\n ' at line 22") > > *This is the table in the Error :: > * > > * db.define_table('Videos', Field('Title'), Field('Hits','integer',default=1), > Field('Arabic_Title'), Field('Bits_on_The_Run_Script'), > Field('Youtube_Video_Url'), Field('Description','text',length=1000), > Field('Arabic_Description','text',length=1000), > Field('Publish_Date','datetime',default=now), > Field('Teacher',db.Teachers), Field('Instroument',db.Instruments), > Field('Level',requires=IS_IN_SET(Course_level,zero=None)), > Field('Style'), Field('Video_Type',requires=IS_IN_SET(Video_type,zero=None)), > Field('Course_ID'), Field('Song_ID',db.Songs), Field('Price',default=0), > Field('Full_Course_Price',default=0), Field('Cover','upload'), > Field('PDF','upload'), Field('Like','integer',default=1), > Field('Sidebar','boolean'), Field('Homepage','boolean'), Field('Order'), > Field('SEO_Keywords','text'), Field('SEO_Description','text'))* > * > * > * > * > *What do you think is the problem , i tried a lot ?? please Help * > * > * > * > * > *Best Regards,* > > -- > > > > --
