[web2py] Problem mit db Feld. DataError: String or BLOB exceeded size limit

2010-05-18 Thread Berti
Ich versuche das Body einer Email Nachricht in ein SQLite3 Datenbank Feld einzufügen. Jedoch kommt die Meldung DataError: String or BLOB exceeded size limit Ich habe den Datentyp im Feld als text deklariert. Wenn ich mit string deklariere, wird der Text der Nachricht eingefügt, aber abgeschnitte

[web2py] Problem with inserting a text in a database field

2010-05-18 Thread Berti
I am trying to insert the body of an email message in a SQLite3 databse. But I get the error message: DataError: String or BLOB exceeded size limit I have declared the database field as text. If i declare it as string, the body of the messsage is going to be inserted, but no in full length. How

[web2py] Re: Problem with inserting a text in a database field

2010-05-18 Thread Berti
is the next message that causes the error. On 18 Mai, 16:16, mdipierro wrote: > How big is the text? > > On May 18, 5:34 am, Berti wrote: > > > I am trying to insert the body of an email message in a SQLite3 > > databse. > > > But I get the error message: > &g

[web2py] Re: Problem with inserting a text in a database field

2010-05-24 Thread Berti
Thanks, but db.commit() didnt help.

[web2py] Re: Problem mit db Feld. DataError: String or BLOB exceeded size limit

2010-05-25 Thread Berti
I do not think this problem is a local one. The text size that actually causes the error is 1078 characters. I am running a loop and inserting the whole mailbox with about 400 messages into a database. At a specific number, in this case it is 97, the loop stops by producing the error. I can delete

[web2py] Re: Problem with inserting a text in a database field

2010-05-25 Thread Berti
I think there is a limit to the whole database. Do you have information about that?

[web2py] Re: Problem with inserting a text in a database field

2010-06-14 Thread Berti
I tried to cut the string to insert for 10 characters. Now it stops at an other point, about 400 messages later and I get the following error. I cannot sort that out. Traceback (most recent call last): File "/Applications/web2py/gluon/restricted.py", line 178, in restricted exec ccode in env