It is Sqlite3 and after following directions in this post to solve the
"pickle issue" I get the following error with username table. Am I missing
something?
<class 'sqlite3.OperationalError'> no such column: auth_user.usernameVersion
web2py™ Version 2.15.3-stable+timestamp.2017.08.07.12.51.45
Python Python 2.7.10: C:\Python27\python.exe (prefix: C:\Python27)Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
Traceback (most recent call last):
File ".\gluon\restricted.py", line 219, in restricted
exec(ccode, environment)
File "C:/inetpub/wwwroot/applications/PEDchangeLog/controllers/default.py"
<https://vmweb2pysql02.gpo.gov/admin/default/edit/PEDchangeLog/controllers/default.py>,
line 90, in <module>
File ".\gluon\globals.py", line 409, in <lambda>
self._caller = lambda f: f()
File "C:/inetpub/wwwroot/applications/PEDchangeLog/controllers/default.py"
<https://vmweb2pysql02.gpo.gov/admin/default/edit/PEDchangeLog/controllers/default.py>,
line 41, in user
return dict(form=auth())
File ".\gluon\tools.py", line 1925, in __call__
return getattr(self, args[0])()
File ".\gluon\tools.py", line 2704, in login
user = table_user(**{username: entered_username})
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\objects.py", line 566, in
__call__
orderby_on_limitby=False).first()
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\objects.py", line 2211, in
select
return adapter.select(self.query, fields, attributes)
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\sqlite.py", line
82, in select
return super(SQLite, self).select(query, fields, attributes)
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line
762, in select
return self._select_aux(sql, fields, attributes, colnames)
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line
718, in _select_aux
rows = self._select_aux_execute(sql)
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line
712, in _select_aux_execute
self.execute(sql)
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\__init__.py", line
67, in wrap
return f(*args, **kwargs)
File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line
412, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
OperationalError: no such column: auth_user.username
Error snapshot [image: help]
<https://vmweb2pysql02.gpo.gov/admin/default/ticket/PEDchangeLog/172.24.216.193.2017-08-07.16-39-27.fc960f63-bfb3-4fd6-9986-becad04c0c46#>
<class 'sqlite3.OperationalError'>(no such column: auth_user.username)
On Monday, August 7, 2017 at 4:31:22 PM UTC-4, Dave S wrote:
>
>
>
> On Monday, August 7, 2017 at 1:08:47 PM UTC-7, Seth J wrote:
>>
>> So, the data in those tables is permanently gone?!
>>
>
> No, no ... "table files" describes the METADATA that PyDal uses to
> interface with the Data Base Engine. Unless you're using Sqlite3, the
> actual data isn't even in the application directory, and (for production)
> not even on the same machine.
>
> /dps
>
>
>
>> On Friday, August 4, 2017 at 12:15:29 PM UTC-4, Leonel Câmara wrote:
>>>
>>> This is weird I would just move all table files to a backup migration
>>> and do a fake migration to recreate them and see if it solves the problem.
>>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
