That is a mysql error, not a web2py error. Does this help? http://forums.kayako.com/f56/steps-fix-sql-error-out-range-value-adjusted-column-mysql-5-a-7604/
On Feb 15, 2:12 pm, Dmitri Zagidulin <[email protected]> wrote: > The db used for sessions is MySQL. > > That is the entirety of the traceback -- it appears not in the error > tickets, but just as a single line of warning in the web2py console > (the shell window where I start web2py for dev purposes). > > To be specific: > > web2py Enterprise Web Framework > Created by Massimo Di Pierro, Copyright 2007-2009 > Version 1.67.2 (2009-09-28 16:29:33) > Database drivers available: pysqlite2, MySQL, PostgreSQL, MSSQL/DB2 > Starting cron... > please visit: > http://127.0.0.1:443 > use "kill -SIGTERM 2607" to shutdown the web2py server > /home/.../gluon/sql.py:739: Warning: Out of range value adjusted for > column 'locked' at row 1 > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > > On Feb 15, 2:05 pm, mdipierro <[email protected]> wrote: > > > This is not a web2py error. It may be a db error. What db? Can we see > > complete traceback? > > > The locked variable is currently not used so in any case should not be > > of concern. The idea was to lock the db record when the session is > > accessed by a client. This function is currently disabled. > > > On Feb 15, 12:45 pm, Dmitri Zagidulin <[email protected]> wrote: > > > > I've started seeing the following warning on the logging console: > > > > /gluon/sql.py:739: Warning: Out of range value adjusted for column > > > 'locked' at row 1 > > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > > > > I'm assuming it's related to the sessions table (since I'm keeping my > > > sessions in db and not on disk), since that's the only column named > > > 'locked' that I know of. > > > > Any idea what could be causing it? (I'm running web2py 1.67.2) -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.

