Update: I've tried SQLite and it's the same problem:
<class 'sqlite3.OperationalError'>(near ")": syntax error)
> locals
> query : 'INSERT INTO my_table() VALUES ();'
Any kind of help will be appreciated.
Joaquin.
On Sat, Mar 5, 2011 at 3:09 PM, Joaquin Orbe <joaquino...@gmail.com> wrote:
> Hi all,
>
> I have a strange behaviour in appadmin trying to insert a record. It
> happens with all my tables except for auth's (auth_user, auth_group,
> etc). This is the error message:
>
> <class 'pyodbc.ProgrammingError'>(('42000', "[42000] [Microsoft][ODBC
> SQL Server Driver][SQL Server]Incorrect syntax near ')'. (102)
> (SQLExecDirectW)"))
>
> I tried to understand the ticket created and could find this at
> gluon\dal.py in insert at line 717:
> locals
> query : 'INSERT INTO my_table() VALUES ();'
>
> Does it means it created an empty query?
>
> I'm on win7, python 2.6, web2py 1.92.1 from sources.
>
> Thanks in advance,
> Joaquin.
>
