On 10 mar, 19:21, Horst <my.list.subscripti...@gmail.com> wrote:
> See error traceback below - the same code, run through sqlite or
> postgres works just fine.
> However, during a transitional period, I have to use an already
> existing firebird database.
> Any idea how this error could be fixed? I have tried with both
> firebird 2.0 and firebird 2.1 servers. Accessing the database with
> python+ kinterbasdb driver works just fine
> The error happens regardless whether I define any tables or not,
> regardless whether I use auth etc. or not - even an empty models/db.py
> excpet for the db=... line) will trigger the error
>
> Traceback (most recent call last):
> File "/home/hherb/src/web2py/gluon/restricted.py", line 98, in
> restricted
> exec ccode in environment
> File "/home/hherb/src/web2py/applications/drugref/models/db.py",
> line 5, in <module>
> db=SQLDB('firebird://dbuser:dbpas...@127.0.0.1:3050/drugref.fdb')
> File "/home/hherb/src/web2py/gluon/sql.py", line 762, in __init__
> self._execute('SET NAMES UTF8;')
> File "/home/hherb/src/web2py/gluon/sql.py", line 761, in <lambda>
> **b)
> OperationalError: (-901, 'begin transaction: \n invalid parameter in
> transaction parameter block')
Hello Horst
In sql.py:
--self._execute('SET NAMES UTF8;')
In tools.py:
--db.Field('password', 'password', readable=False),
++db.Field('passwordf', 'password', readable=False),
--table.password.requires = CRYPT()
++table.passwordf.requires = CRYPT()
Jose
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---