what is in sql.log?
On Jun 23, 11:53 am, Alexei Vinidiktov <alexei.vinidik...@gmail.com>
wrote:
> Hello,
>
> After successfully connecting to the database I tried altering the
> definition of a table from this:
>
> db.define_table('todo'', db.Field('task'))
>
> to this:
>
> db.define_table('todo', db.Field('task', type='string', length='256'))
>
> Then I refreshed the page, and I got this error:
>
> Traceback (most recent call last):
> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/restricted.py",
> line 107, in restricted
> exec ccode in environment\n File
> "/var/www/alvinru/data/www/bilingsoft.ru/applications/pyjamas/models/db.py",
> line 17, in <module>
> db.define_table(\'todo\', db.Field(\'task\', type=\'string\',
> length=\'256\'))
> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line
> 993, in define_table
> query = t._create(migrate=migrate)\n File
> "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line 1344, in
> _create
> sql_fields_aux, logfile)\n File
> "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line 1392, in
> _migrate
> self._db._execute(sub_query)\n File
> "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line 864, in
> <lambda>
> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> ProgrammingError: (-206, \'isc_dsql_prepare: \
> Dynamic SQL Error\
> SQL error code = -206\
> Column unknown\
> TASK__TMP\
> At line 1, column 17\')'
>
> Am I doing anything wrong?
>
> Thanks.
>
> --
> Alexei Vinidiktov
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
