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

[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 abgeschnitten.

Wie bekomme ich die ganze Nachricht in das Feld? Was ist das Limit für
text?

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

[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 can I insert the full text. What is the size limit for a text?

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

[Berti]

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 that message from the
mailbox but than it 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:
>
> > 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 can I insert the full text. What is the size limit for a text?

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

[Berti]

Thanks, but db.commit() didnt help.

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

[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 that message from the
mailbox but than it is the next message that causes the error.

I just tried your suggestion, to see what comes out, and set the
length to a higher value. But, as expected, this did not help.

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

[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

[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 environment
  File "/Applications/web2py/applications/pyMantis/controllers/
plugin_mailinglist.py", line 139, in 
  File "/Applications/web2py/gluon/globals.py", line 96, in 
self._caller = lambda f: f()
  File "/Applications/web2py/applications/pyMantis/controllers/
plugin_mailinglist.py", line 106, in mails_check
typ, data = server.fetch(uid, '(RFC822)')
  File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/imaplib.py", line 437, in fetch
typ, dat = self._simple_command(name, message_set, message_parts)
  File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/imaplib.py", line 1055, in _simple_command
return self._command_complete(name, self._command(name, *args))
  File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/imaplib.py", line 885, in _command_complete
typ, data = self._get_tagged_response(tag)
  File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/imaplib.py", line 986, in _get_tagged_response
self._get_response()
  File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/imaplib.py", line 948, in _get_response
data = self.read(size)
  File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/imaplib.py", line 1150, in read
data = self.sslobj.read(size-read)
MemoryError