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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
