Thank you. Will look into these asap.
Massimo
On Mar 26, 9:46 am, SergeyPo <ser...@zarealye.com> wrote:
> Hi all,
>
> these probolems may be caused by unicode support by Oracle DB (or not
> - I don't know). The code works fine with MySQL and SQLite.
>
> 1. DAL migrations do not work if you change length of 'string' field.
> E.g. I have this:
> SQLField('komment', 'string', length=255)
> and I try to change it to
> SQLField('komment', 'string', length=512)
> and I get ORA-00911 error (bad symbol!)
>
> 2. When I try to migrate this field to SQLField('komment', 'text') I
> get same error: ORA-00911
>
> 3. I managed to migrate by removing this field definition, running the
> model (reload db admin page in browser) and pasting back the field
> definition SQLField('komment', 'text')
> Everything looked ok.
> Then I run data import script that inserts data from UTF-8 encoded
> file into this field. Script worked without problems.
> Then I try to see data in db admin page and get this error (the same
> error I get from any scripts that try to read data from this field):
>
> Traceback (most recent call last):
> File "c:\web2py\gluon\restricted.py", line 98, in restricted
> exec ccode in environment
> File "c:/web2py/applications/advantage/controllers/appadmin.py",
> line 196, in <module>
> File "c:\web2py\gluon\globals.py", line 75, in <lambda>
> self._caller = lambda f: f()
> File "c:/web2py/applications/advantage/controllers/appadmin.py",
> line 160, in select
> records=SQLTABLE
> (records,linkto,upload,orderby=True,_class='sortable'))
> File "c:\web2py\gluon\sqlhtml.py", line 634, in __init__
> r = str(field.formatter(r))
> ProgrammingError: LOB variable no longer valid after subsequent fetch
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
