<class 'sqlite3.OperationalError'> no such table: cp_mods
Versionweb2py™Version 2.9.12-stable+timestamp.2015.01.17.06.11.03PythonPython
2.7.8: 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.
Traceback (most recent call last):
File "C:\web2py-9-12\gluon\restricted.py", line 224, in restricted
exec ccode in environment
File "C:/web2py-9-12/applications/bs3b/models/db.py"
<http://127.0.0.1:8000/admin/default/edit/bs3b/models/db.py>, line 615, in
<module>
if len(db(db.cp_mods).select()) == 0:
File "C:\web2py-9-12\gluon\dal\objects.py", line 2066, in select
return adapter.select(self.query,fields,attributes)
File "C:\web2py-9-12\gluon\dal\adapters\sqlite.py", line 125, in select
return super(SQLiteAdapter, self).select(query, fields, attributes)
File "C:\web2py-9-12\gluon\dal\adapters\base.py", line 1232, in select
return self._select_aux(sql,fields,attributes)
File "C:\web2py-9-12\gluon\dal\adapters\base.py", line 1197, in _select_aux
self.execute(sql)
File "C:\web2py-9-12\gluon\dal\adapters\base.py", line 1319, in execute
return self.log_execute(*a, **b)
File "C:\web2py-9-12\gluon\dal\adapters\base.py", line 1313, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
OperationalError: no such table: cp_mods
code:
db = DAL("sqlite://storage.sqlite", # on PC locals
folder='applications/shop/databases',
pool_size=0,
migrate=True,
fake_migrate=True,
check_reserved=['all'],
)
db.define_table('cp_mods', # вакансии
Field('cms', length=30),
fake_migrate=True,
redefine=True,
)
if len(db(db.cp_mods).select()) == 0:
db.cp_mods.truncate()
db.cp_mods[0] = dict(cms = '_unknown_')
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
