have you checked the variables content of a failure?
Paolo
On Thursday, November 7, 2013 8:36:52 AM UTC+1, at wrote:
>
> Hi,
>
> Occationally an error is reported stating following problem:
> "/home/www-data/web2py/gluon/dal.py", line 8514, in insert\n ret =
> self._db._adapter.insert(self, self._listify(fields))\n File
> "/home/www-data/web2py/gluon/dal.py", line 1206, in insert\n raise
> e\nProgrammingError: (\'ERROR\', \'08P01\', \'insufficient data left in
> message\')\n'
>
> and Postgresql logs: 'insufficient data left in message'.
>
> Here is the insert command on which we get this err:
> db.my_table.insert(status=status,
> type=type,
> created=datetime.now,
> updated=datetime.now,
> recipient=recipient,
> recipient_username=recipient_username,
> sender_username=sender_username,
> subject=subject,
> message=message,
> admission=admission)
>
>
>
> and table defination:
> db.define_table('my_table',
> Field('status', type='string', length=32),
> Field('type', type='string', length=7),
> Field('admission', type='integer'),
> Field('sender_username', type='string', length=32),
> Field('recipient', type='string', length=64),
> Field('recipient_username', type='string', length=64),
> Field('subject', type='string', length=50),
> Field('message', type='text'),
> Field('created', type='datetime', default=request.now, writable=False
> ),
> Field('updated', type='datetime', default=request.now, writable=False
> ),
> )
>
>
> Any idea what might be the issue?
>
> Thanks a lot.
>
--
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/groups/opt_out.