Massimo, I checked all the fields with IS_DATE or IS_DATETIME validators and all are correctly declared either 'date' or 'datetime'. However, some of the validators are IS_NULL_OR(IS_DATE()) and IS_NULL_OR(IS_DATETIME()). Might this cause the ticket, if a field were None instead of a date/time?
On Jan 26, 1:19 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > 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 -- 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.
