Thanks for the responses.
It doesn't seem to be the case with different case. Sorry, I didn't
write this app. Here is what I get on a find:
12255433 128 -rw-r--r-- 1 root root 125292 Apr 6 2010 ./
controllers/test.py.1
> find . -not -name "*.pyc" -not -name "*.py" -not -name "*.JPG" -not -name
> "*.html" -not -name "*.gif" -not -name "67*" -not -name "68*" -not -name
> "99*" -not -name "127*" -not -name "*.bak" -not -name "*.db" -not -name
> "*.table" -not -name "*.js" -not -name "*.jpg" -not -name "*.pdf" -not -name
> "*.txt" -not -name "*.css" -not -name "*.csv" -not -name "75*" -exec grep -i
> idchecked {} \; -ls
idChecked CHAR(32)
idChecked VARCHAR(32),
ALTER TABLE idsChecked ADD idChecked__tmp VARCHAR(512);
UPDATE idsChecked SET idChecked__tmp=idChecked;
ALTER TABLE idsChecked DROP COLUMN idChecked;
ALTER TABLE idsChecked ADD idChecked VARCHAR(512);
UPDATE idsChecked SET idChecked=idChecked__tmp;
ALTER TABLE idsChecked DROP COLUMN idChecked__tmp;
idChecked CHAR(512)
idChecked CHAR(512)
idChecked VARCHAR(512),
idChecked VARCHAR(512),
idChecked VARCHAR(512),
idChecked VARCHAR(512),
12255494 196 -rw-r--r-- 1 root root 194993 Jul 15 2010 ./
databases/sql.log
db(db.idsChecked.idChecked==item.id).delete()
db.idsChecked.insert(idChecked=id)
db.idsChecked.insert(idChecked=id)
db.idsChecked.insert(idChecked=id)
db.idsChecked.insert(idChecked=id)
12255433 128 -rw-r--r-- 1 root root 125292 Apr 6 2010 ./
controllers/test.py.1
>
Is there something else I could check?
On May 5, 4:58 pm, Massimo Di Pierro <[email protected]>
wrote:
> 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?
