Did you ever edit appadmin in your app? Please backit up and replace - controllers/appadmin.py - views/appadmin.html with the ones from the new welcome app. This may partially fix your last two problems.
The main problem is either you have an invalid combination of validators OR you have corrupted data in database (I assume you have sqlite) OR you have converted a 'string' field into a 'date' field (or vice versa) with SQLITE. The first error for example arises from an attempt to format a date from the database but it finds a string instead of a datetime.date as it should be. sqlite does not enforce field type (so one can accidentally put a string in place of a date). web2py checks. Yet if you define a field as string, store a date in it, then convert it into a date, sqlite does not support alter table and you end up with corrupted data. A different database would not have permitted you to do such conversion at all. I need to look at the code to help you more. Massimo On Jan 26, 2:31 am, weheh <richard_gor...@verizon.net> wrote: > I just re-downloaded the source > fromhttp://www.web2py.com/examples/default/download > (not the latest dev snapshot) and re-installed it. I couldn't even get > web2py to start. It looked like an incomplete set of files to me. > > So, I installed the Windows version on the server and then restarted > web2py. Now, a lot of stuff does work, including my new app. But a lot > of stuff in my old app is broken now. > > One of my controllers is throwing this error where it used to run > fine: > > Traceback (most recent call last): > File "gluon/restricted.py", line 173, in restricted > File "D:/web2py/applications/myapp/controllers/admin.py", line 962, > in <module> > File "gluon/globals.py", line 96, in <lambda> > File "gluon/tools.py", line 1847, in f > File "D:/web2py/applications/myapp/controllers/admin.py", line 224, > in res > File "gluon/sqlhtml.py", line 992, in __init__ > File "gluon/sql.py", line 2640, in formatter > File "gluon/validators.py", line 2053, in formatter > File "gluon/validators.py", line 1858, in formatter > AttributeError: 'str' object has no attribute 'strftime' > > I looked at all the code that has strftime and all the fields that are > being formatted that way are datetimes, so it shouldn't be a problem. > This app's been running flawlessly for a long time before this new > install. > > Even directly accessing the db via the admin interface doesn't work > well. > > If I look at db.auth_event table I get a ticket: > > Traceback (most recent call last): > File "gluon/restricted.py", line 173, in restricted > File "D:/web2py/applications/myapp/views/appadmin.html", line 156, in > <module> > File "gluon/globals.py", line 105, in write > File "gluon/html.py", line 99, in xmlescape > File "gluon/html.py", line 513, in xml > File "gluon/html.py", line 504, in _xml > File "gluon/html.py", line 99, in xmlescape > File "gluon/html.py", line 513, in xml > File "gluon/html.py", line 504, in _xml > File "gluon/html.py", line 99, in xmlescape > File "gluon/html.py", line 513, in xml > File "gluon/html.py", line 504, in _xml > File "gluon/html.py", line 99, in xmlescape > File "gluon/html.py", line 513, in xml > File "gluon/html.py", line 504, in _xml > File "gluon/html.py", line 99, in xmlescape > File "gluon/sql.py", line 1410, in __getattr__ > File "gluon/sql.py", line 1405, in __allocateException: undefined > record > > If I try to look at another table I get this error: > > Traceback (most recent call last): > File "gluon/restricted.py", line 173, in restricted > File "D:/web2py/applications/myapp/controllers/appadmin.py", line > 270, in <module> > File "gluon/globals.py", line 96, in <lambda> > File "D:/web2py/applications/SPiNup/controllers/appadmin.py", line > 157, in select > TypeError: expected string or buffer -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
