Here goes:
timestamp: 2009-06-23T20:07:10.834950
CREATE TABLE todo(
id INTEGER PRIMARY KEY,
task VARCHAR(32)
);
success!
timestamp: 2009-06-23T20:46:15.842106
ALTER TABLE todo ADD task__tmp VARCHAR(256);
success!
UPDATE todo SET task__tmp=task;
timestamp: 2009-06-23T20:54:33.738081
ALTER TABLE todo ADD task__tmp VARCHAR(256);
success!
UPDATE todo SET task__tmp=task;
On Wed, Jun 24, 2009 at 1:05 AM, mdipierro<[email protected]> wrote:
>
> what is in sql.log?
>
>
> On Jun 23, 11:53 am, Alexei Vinidiktov <[email protected]>
> 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
> >
>
--
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
-~----------~----~----~----~------~----~------~--~---
