Hello,
I'm testing web2py with firebird 2.1 and I get the following error
when I try to connect:
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 173, in restricted
exec ccode in environment
File "C:/web2py/applications/init/models/db.py", line 34, in
<module>
auth.define_tables() # creates all needed
tables
File "C:\web2py\gluon\tools.py", line 797, in define_tables
format='%(first_name)s %(last_name)s (%(id)s)')
File "C:\web2py\gluon\sql.py", line 1275, in define_table
t._create(migrate=migrate, fake_migrate=fake_migrate)
File "C:\web2py\gluon\sql.py", line 1694, in _create
self._db._execute(query)
File "C:\web2py\gluon\sql.py", line 1067, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n
SQL error code = -104\n Token unknown - line 6, column 5\n
password')
The problem comes with auth.define_tables(). If I comment this line,
web2py connects fine to firebird but it do not creates the necessary
tables to perform auth control.
In my case, the connection string is as follows: db = DAL('firebird://
SYSDBA:master...@localhost/c:\programas\ctodb.fdb')
I'm using web2py 1.76.3 on windows and kinterbasdb 3.3.0-win32-py2.6.
I do not if its a bug or if I'm doing something wrong.
Thanks
--
You received this message because you are subscribed to the Google Groups
"web2py-users" 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.
