open up your dataabses/sql.log to see what command has been issued to
create the tables...
On Saturday, August 31, 2013 5:43:45 PM UTC+2, George Petsagourakis wrote:
>
> Hello everyone,
> I have the following table definitions:
>
> db.define_table('identities',
> Field('name', 'string', required=True),
> Field('profession', 'string', required=True),
> Field('address','text', required=True),
> Field('vat_number',unique=True, required=True, length=9,
> requires=IS_LENGTH(9)),
> Field('tax_office', 'string', required=True),)
>
> db.define_table('items,',
> Field('is_receipt', 'boolean', required=True),
> Field('serial_number','integer', required=True),
> Field('issue_date', 'date', required=True),
> Field('issued_to', 'reference identities', required=True),
> Field('item_value', 'decimal(10,2)', required=True),
> Field('is_vat_liable', 'boolean', required=True),
> Field('vat_percentage', 'decimal(3,2)', required=True),
> Field('net_value', compute=lambda row:
> row['value']/(row['vat_percentage']+1), writable=False),
> Field('is_retained_value', 'boolean', required=True),
> Field('retain_percentage', 'decimal(3,2)', required=True),
> Field('retain_value', compute=lambda row:
> (row['net_value']*row['retain_percentage']), writable=False),
> Field('is_eu_transaction', 'boolean', required=True),)
>
> That produce the following error:
>
> Error ticket for "vivlio_b" Ticket ID
>
> 127.0.0.1.2013-08-31.18-30-38.e65726e8-d6a9-4059-8f43-41a45314340e
> <class 'sqlite3.OperationalError'> near ",": syntax error Version web2py™
> Version
> 2.5.1-stable+timestamp.2013.06.06.15.39.19 Python Python 2.7:
> E:\web2py\web2py_no_console.exe (prefix: E:\web2py) Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
>
> Traceback (most recent call last):
> File "/home/mdipierro/make_web2py/web2py/gluon/restricted.py", line 212, in
> restricted
> File "E:/web2py/applications/vivlio_b/models/db.py"
> <http://127.0.0.1:8000/admin/default/edit/vivlio_b/models/db.py>, line 49, in
> <module>
> File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 7788, in
> define_table
> File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 7825, in
> lazy_define_table
> File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 963, in
> create_table
> File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1767, in
> create_sequence_and_triggers
> File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1784, in
> execute
> File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1778, in
> log_execute
> OperationalError: near ",": syntax error
>
>
>
> Maybe someone can shed some light on this ?
>
--
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
