Than it bust be an application bug. I think you may have a IS_DATE validator on a 'string' field instead of a 'date' field. You also need to move over the new appadmin(s) into your app. Normally this is not required during upgrades since they become part of your app. Nevertheless there was an issue with very early appadmin that was fixed and may be causing the last one of your problems.
On Jan 26, 12:00 pm, weheh <richard_gor...@verizon.net> wrote: > 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.
