Massimo, the db is MySQL, not SQLITE. I think this is going to be more complicated than what you suggest. I am going to do a wipe and clean install. It's been awhile since I upgraded my server's version of web2py. I honestly do not like the install mechanism behind web2py. Seems error prone, as measured by the many times I've had trouble with it. - RG
On Jan 26, 9:54 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > 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- Hide quoted text - > > - Show quoted text - -- 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.
