I think I fixed the problem with sequence name. Please check.
On Dec 6, 8:45 pm, ron_m <ron.mco...@gmail.com> wrote:
> That above patch prevents the old sql.py DAL from working with
> sqlhtml.py because old dal does have a field attribute
> field._tablename which sqlhtml.py was looking for before the patch.
>
> I get the login form posted, fill it in but submit on the form to
> complete the login gets a ticket. I tried to follow it but got lost, I
> need a multi-threaded debugger such as winpdb. The one on Komodo IDE
> 6.0 doesn't seem to follow spawned threads OR I don't know how to use
> it properly yet, Here is the traceback after the login form submit
> (PostgreSQL database). It is inserting into the auth_event table the
> fact that I logged in when it fails.
>
> I went back to 1.89.5 and the application runs fine so the database
> isn't damaged.
>
> Traceback (most recent call last):
> File "/home/camcentral/Dev/web2py_hg/gluon/restricted.py", line 188,
> in restricted
> exec ccode in environment
> File "/home/camcentral/Dev/web2py_hg/applications/ccims/controllers/
> default.py", line 70, in <module>
> File "/home/camcentral/Dev/web2py_hg/gluon/globals.py", line 95, in
> <lambda>
> self._caller = lambda f: f()
> File "/home/camcentral/Dev/web2py_hg/applications/ccims/controllers/
> default.py", line 44, in user
> return dict(form=auth())
> File "/home/camcentral/Dev/web2py_hg/gluon/tools.py", line 1025, in
> __call__
> return self.login()
> File "/home/camcentral/Dev/web2py_hg/gluon/tools.py", line 1516, in
> login
> self.log_event(log % self.user)
> File "/home/camcentral/Dev/web2py_hg/gluon/tools.py", line 1268, in
> log_event
> origin=origin, user_id=user_id)
> File "/home/camcentral/Dev/web2py_hg/gluon/sql.py", line 3540, in
> insert
> return self._db._adapter.insert(self, fields)
> File "/home/camcentral/Dev/web2py_hg/gluon/sql.py", line 673, in
> insert
> id = self.lastrowid(table)
> File "/home/camcentral/Dev/web2py_hg/gluon/sql.py", line 1500, in
> lastrowid
> self.execute("select currval('%s')" % table._sequence_name)
> File "/home/camcentral/Dev/web2py_hg/gluon/sql.py", line 1017, in
> execute
> return self.log_execute(*a, **b)
> File "/home/camcentral/Dev/web2py_hg/gluon/sql.py", line 1014, in
> log_execute
> return self.cursor.execute(*a,**b)
> ProgrammingError: relation "none" does not exist
> LINE 1: select currval('None')
>
> On Dec 6, 6:04 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > fixed in trunk. Thanks.
>
> > On Dec 6, 7:31 pm, ron_m <ron.mco...@gmail.com> wrote:
>
> > > Another patch
>
> > > Hit login form getting a ticket.
>
> > > sqlhtml.py
>
> > > line 62 and line 216
>
> > > field._tablename should be field.tablename
>
> > > Ron
>
>
