It's happening to me again:
On Wednesday, February 7, 2018 at 1:00:19 AM UTC-8, Dave S wrote:
>
> Copying an app from 2.14.6 to 2.16.1, including copying the database file
> (storage.sqlite because, well, I'm using sqlite on this machine).
>
> appconfig.ini has migrations off, and db.py has
>
> db = DAL(myconf.get('db.uri'),
> pool_size=myconf.get('db.pool_size'),
> migrate_enabled=myconf.get('db.migrate'),
> check_reserved=['all'],
> fake_migrate_all=True)
>
>
> Because of fake_migrate_all, I expect the table files to be created, but
> they aren't.
>
[...]
>
This time I'm getting
>
> 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.
> 31.
> 32.
>
> Traceback (most recent call last):
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\restricted.py", line
> 219, in restricted
> exec(ccode, environment)
> File
> "C:/Users/Dave/web2py_win/web2py_win-2.17.2/web2py/applications/short2/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/short2/controllers/default.py>,
> line 173, in <module>
> File "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\globals.py",
> line 421, in <lambda>
> self._caller = lambda f: f()
> File
> "C:/Users/Dave/web2py_win/web2py_win-2.17.2/web2py/applications/short2/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/short2/controllers/default.py>,
> line 57, in showrun
> run = db(db.run.id == request.vars.id).select().first()
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\objects.py",
> line 2275, in select
> return adapter.select(self.query, fields, attributes)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\adapters\sqlite.py",
> line 82, in select
> return super(SQLite, self).select(query, fields, attributes)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\adapters\base.py",
> line 763, in select
> return self._select_aux(sql, fields, attributes, colnames)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\adapters\base.py",
> line 742, in _select_aux
> return processor(rows, fields, colnames, cacheable=cacheable)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\adapters\base.py",
> line 306, in parse
> for row in rows
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\adapters\base.py",
> line 232, in _parse
> value = self.parse_value(value, fit, ft, blob_decode)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\adapters\base.py",
> line 199, in parse_value
> return self.parser.parse(value, field_itype, field_type)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\parsers\__init__.py",
> line 101, in parse
> return self.registered[field_itype](value, field_type)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\parsers\__init__.py",
> line 76, in __call__
> return self.call(value, field_type)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\parsers\__init__.py",
> line 70, in _call_with_extras
> return self.f(self.parser, value, **extras)
> File
> "C:\Users\Dave\web2py_win\web2py_win-2.17.2\web2py\gluon\packages\dal\pydal\parsers\sqlite.py",
> line 19, in _decimal
> value = ('%.' + decimals + 'f') % value
> ValueError: unsupported format character ' ' (0x20) at index 2
>
>
but I think the culprit is that the *.table files aren't being created.
Once again, I'm copying the storage.sqlite from the 2.14.6 application, so
there are tables.in the database. which I've verified with a command-line
sqlite3.
What am I doing wrong with 'fake_migrate_all' ?
/dps
--
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.
