Sorry to the group. I had to rereate my account so the earlier
messages in this thread got deleted.
Massimo, when I upgrade and restart, I'm now getting these errors:
web2py Enterprise Web Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.95.1 (2011-04-25 15:04:14)
Database drivers available: SQLite3, pymysql
Traceback (most recent call last):
File "/web2py/web2py/gluon/restricted.py", line 181, in
restricted
exec ccode in environment
File "applications/phones/models/db.py", line 13, in <module>
db.define_table('idsChecked',SQLField('idChecked'))
File "/web2py/web2py/gluon/dal.py", line 4028, in define_table
polymodel=polymodel)
File "/web2py/web2py/gluon/dal.py", line 613, in create_table
fake_migrate=fake_migrate)
File "/web2py/web2py/gluon/dal.py", line 657, in migrate_table
and not isinstance(table[key].type, SQLCustomType) \
File "/web2py/web2py/gluon/dal.py", line 4378, in __getitem__
return dict.__getitem__(self, str(key))
KeyError: 'idchecked'
On May 5, 2:46 pm, Massimo Di Pierro <[email protected]>
wrote:
> You should upgrade. That version is more than one year old. That
> problem has been fixed.
>
> Massimo
>
> On May 5, 2:43 pm, dsa42 <[email protected]> wrote:
>
>
>
>
>
>
>
> > I think it's 1.76.5
>
> > web2py Enterprise Web Framework
> > Created by Massimo Di Pierro, Copyright 2007-2010
> > Version 1.76.5 (2010-03-11 15:19:08)
> > Database drivers available: SQLite3
>
> > I also think that the probley is that Ubuntu 10.04 installed pythin
> > 2.6. Somehow, that installation ruined the MySQLdb module for python
> > 2.6. I can't even "inport MySQLdb" in either python 2.5 or 2.6, so
> > I'm working on solving that first.
>
> > On May 5, 1:16 pm, Massimo Di Pierro <[email protected]>
> > wrote:
>
> > > Which web2py version? the latest web2py should be using pymysql and
> > > not mysqldb.
>
> > > On May 5, 11:41 am, dsa42 <[email protected]> wrote:
>
> > > > I am a noob to web2py. I am working on a previously installed system
> > > > at a client site (not installed by me).
>
> > > > I upgraded the system from Ubuntu server 9.10 (karmic) to 10.04
> > > > (lucid). After reboot, I'm getting the following traceback from the
> > > > web2py server:
>
> > > > Error traceback
>
> > > > 1.Traceback (most recent call last):
> > > > 2. File "/web2py/web2py/gluon/restricted.py", line 173, in restricted
> > > > 3. exec ccode in environment
> > > > 4. File "/web2py/web2py/applications/MyAppName/models/db.py", line 9,
> > > > in <module>
> > > > 5. db = DAL('mysql://user:password@localhost/DBname')
> > > > 6. File "/web2py/web2py/gluon/sql.py", line 3783, in DAL
> > > > 7. db_codec=db_codec, check_reserved=check_reserved)
> > > > 8. File "/web2py/web2py/gluon/sql.py", line 919, in __init__
> > > > 9. self._pool_connection(lambda : MySQLdb.Connection(
> > > > 10. File "/web2py/web2py/gluon/sql.py", line 829, in _pool_connection
> > > > 11. self._connection = f()
> > > > 12. File "/web2py/web2py/gluon/sql.py", line 919, in <lambda>
> > > > 13. self._pool_connection(lambda : MySQLdb.Connection(
> > > > 14.NameError: global name 'MySQLdb' is not defined
> > > > 15.
>
> > > > The mysql daemon is running. The username, password, and DBname are
> > > > correct. Any ideas on where to look?