Resolved: Had a Field named "Array" modified the name of the field for
"array1" and solved.
Ovidio Marinho Falcao Neto
ITJP.NET.BR
[email protected]
Brasil
2013/10/15 Vinicius Assef <[email protected]>
> Could you paste your entire define_table() for this table?
>
>
> On Tue, Oct 15, 2013 at 9:23 PM, Ovidio Marinho <[email protected]>wrote:
>
>>
>>
>> Error ticket for "sisventi" Ticket ID
>>
>> I'm not managing to identify if there is a mistake in the DAL or is
>> postgres??? help me
>>
>>
>> 127.0.0.1.2013-10-15.21-20-42.332763ea-1f12-4d73-8379-2e0364347acf
>> <class 'psycopg2.ProgrammingError'> ERRO: erro de sintaxe em ou próximo a
>> "array" LINE 10: array VARCHAR(512), ^ Versão web2py™Version
>> 2.6.4-stable+timestamp.2013.09.22.01.43.37PythonPython 2.7.5:
>> c:\python27\python.exe (prefix: c:\python27) Traceback
>>
>>
>>
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>> 10.
>> 11.
>> 12.
>> 13.
>> 14.
>> 15.
>> 16.
>> 17.
>> 18.
>> 19.
>> 20.
>> 21.
>> 22.
>>
>>
>>
>>
>> Traceback (most recent call last):
>> File "C:\web2py264\gluon\restricted.py", line 217, in restricted
>>
>>
>>
>>
>>
>> exec ccode in environment
>> File "C:/web2py264/applications/sisventi/models/db.py"
>> <http://localhost:8000/admin/default/edit/sisventi/models/db.py>, line 1328,
>> in <module>
>>
>>
>>
>>
>>
>> Field('posicion', type='integer', default=0, notnull=False)
>>
>>
>>
>>
>>
>> File "C:\web2py264\gluon\dal.py", line 7895, in define_table
>>
>>
>>
>>
>>
>> table = self.lazy_define_table(tablename,*fields,**args)
>>
>>
>>
>>
>>
>> File "C:\web2py264\gluon\dal.py", line 7932, in lazy_define_table
>>
>>
>>
>>
>>
>> polymodel=polymodel)
>> File "C:\web2py264\gluon\dal.py", line 1002, in create_table
>>
>>
>>
>>
>>
>> self.create_sequence_and_triggers(query,table)
>>
>>
>>
>>
>>
>> File "C:\web2py264\gluon\dal.py", line 2657, in
>> create_sequence_and_triggers
>>
>>
>>
>>
>>
>> self.execute(query)
>> File "C:\web2py264\gluon\dal.py", line 1833, in execute
>>
>>
>>
>>
>>
>> return self.log_execute(*a, **b)
>>
>>
>>
>>
>>
>> File "C:\web2py264\gluon\dal.py", line 1827, in log_execute
>>
>>
>>
>>
>>
>> ret = self.cursor.execute(command, *a[1:], **b)
>>
>>
>>
>>
>> ProgrammingError: ERRO: erro de sintaxe em ou próximo a "array"
>> LINE 10: array VARCHAR(512),
>>
>>
>>
>>
>>
>> ^
>>
>> Error snapshot [image:
>> help]<http://localhost:8000/admin/default/ticket/sisventi/127.0.0.1.2013-10-15.21-20-42.332763ea-1f12-4d73-8379-2e0364347acf#>
>>
>> <class 'psycopg2.ProgrammingError'>(ERRO: erro de sintaxe em ou próximo a
>> "array" LINE 10: array VARCHAR(512), ^ )
>>
>>
>>
>> Ovidio Marinho Falcao Neto
>> ITJP.NET.BR
>> [email protected]
>> Brasil
>>
>>
>> --
>> 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/groups/opt_out.
>>
>
> --
> 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/groups/opt_out.
>
--
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/groups/opt_out.
