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.

Reply via email to