Hi *,
I get this error just in the production server not in the development
one when I try to insert a record to a database table with a json
column/field.
Traceback (most recent call last):
File "/var/www/.../web2py/gluon/restricted.py", line 217, in restricted
exec ccode in environment
File "/var/www/.../web2py/applications/teleservice/controllers/auth.py"
<https://borri2.valis-e.com/admin/default/edit/teleservice/controllers/auth.py>,
line 249, in <module>
File "/var/www/.../web2py/gluon/globals.py", line 385, in <lambda>
self._caller = lambda f: f()
File "/var/www/.../web2py/gluon/tools.py", line 3259, in f
return action(*a, **b)
File "/var/www/.../web2py/applications/teleservice/controllers/auth.py"
<https://borri2.valis-e.com/admin/default/edit/teleservice/controllers/auth.py>,
line 56, in new_user
user_id = db.auth_user.insert(**db.auth_user._filter_fields(form.vars))
File "/var/www/.../web2py/gluon/dal.py", line 9114, in insert
ret = self._db._adapter.insert(self, self._listify(fields))
File "/var/www/.../web2py/gluon/dal.py", line 1360, in insert
raise e
DataError: invalid input syntax for type json
LINE 1: ...assword,registration_key,email,job_title) VALUES ('{''provin...
^
DETAIL: Token "'" is invalid.
CONTEXT: JSON data, line 1: {'...
Where do you think I have to look for what cause the problem?
On both the architectures I have the same psycopg (v. 2.5.3) and
postgreSQL (v. 9.3) versions... but not the same framework version:
* on development server: 2.10.0-beta+timestamp.2014.10.16.15.58.50
(Running on Rocket 1.2.6, Python 2.7.5+)
* on production server: 2.9.4-stable+timestamp.2014.03.04.22.40.54
(Running on Apache/2.2.22 (Debian), Python 2.7.3)
could it be the solution to use an updated web2py version? Is there a
possible patch or different solution for that?
Thank you
Manuele
--
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.
