crap! that's what it was :) changed it to 'sender', and much
better! :)
thanks for that!
db.commit() is because here DAL is being used in script
(BTW - running on trunk LATEST, and no issues to report :) )
Mart
On May 4, 11:54 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> I think from is a SQL keyword therefore it cannot be a field name. You
> do not need db.commit() in models.
>
> On May 4, 10:49 pm, mart <msenecal...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Hi,
>
> > I think I may have been looking at this too long... its giving the
> > following error, and I can't see why...
> > (using DAL in script)
>
> > Thanks in advance,
> > Mart :)
>
> > db.define_table('mail',
> > Field('uuid',length=64,default=uuid.uuid4()),
> > Field('recipients','list:string'),Field('From'),
> > Field('password'),Field('smtp_server'),Field('smtp_port'))
> > db.commit()
>
> > Traceback (most recent call last):
> > File "/Users/mart/Applications/Aptana Studio 2.0/plugins/
> > org.python.pydev.debug_1.6.5.2011020317/pysrc/pydevd.py", line 1133,
> > in <module>
> > debugger.run(setup['file'], None, None)
> > File "/Users/mart/Applications/Aptana Studio 2.0/plugins/
> > org.python.pydev.debug_1.6.5.2011020317/pysrc/pydevd.py", line 918, in
> > run
> > execfile(file, globals, locals) #execute the script
> > File "/Users/mart/aptanaApps/src/_purple.py", line 524, in <module>
> > dbBlueObj.defineTables()
> > File "/Users/mart/aptanaApps/src/blueLite/db_storage/db_blue.py",
> > line 278, in defineTables
> > Field('password'),Field('smtp_server'),Field('smtp_port'))
> > File "/Users/mart/aptanaApps/src/blueLite/pyUtils/sql/web2py/
> > dal.py", line 4028, in define_table
> > polymodel=polymodel)
> > File "/Users/mart/aptanaApps/src/blueLite/pyUtils/sql/web2py/
> > dal.py", line 590, in create_table
> > self.create_sequence_and_triggers(query,table)
> > File "/Users/mart/aptanaApps/src/blueLite/pyUtils/sql/web2py/
> > dal.py", line 1142, in create_sequence_and_triggers
> > self.execute(query)
> > File "/Users/mart/aptanaApps/src/blueLite/pyUtils/sql/web2py/
> > dal.py", line 1152, in execute
> > return self.log_execute(*a, **b)
> > File "/Users/mart/aptanaApps/src/blueLite/pyUtils/sql/web2py/
> > dal.py", line 1147, in log_execute
> > ret = self.cursor.execute(*a,**b)
> > sqlite3.OperationalError: near "From": syntax error
