The problem is that the code uses (or used) inconsistent case. Old versions
were forgiving about this. New versions are less forgiving because this soon or
later causes problems.
You have
> db.define_table('idsChecked',SQLField('idChecked'))
and somewhere else you use 'idchecked'.
First thing to do is make sure you have consistent case.
Do you have an existing database of does it need to be created?
On May 5, 2011, at 4:52 PM, dsa42 wrote:
> 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?
