Ok! thanks.
I tried and with the prompt it seems to work. Effectively i have this error
often, but sometime it works correctly.
Maybe the packet it's too big?
A.
Scrive Rolf Hopkins <[EMAIL PROTECTED]>:
> You don't have to join the mailing list to send mail to the list. Send
> it
> to the list anyway and you may get a better response and there may even
> be
> someone who has come across this exact same problem. If you don't think
> it's IMP, are you able to log into the mysql prompt and run that exact
> same
> query from there?
>
> ----- Original Message -----
> From: "Aldo Spano" <[EMAIL PROTECTED]>
> To: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Sent: Monday, June 11, 2001 21:27
> Subject: Re: MYSQL error
>
>
> > Thank you very much for answer. I removed from the list cause I
> received
> too
> > much e-mail and basicly i'm not even on-line, so my mailbox becomes
> full
> in a
> > white.
> > IMP is a package wrote in PHP, for the management of mailbox with IMAP
> > protocoll.
> > I don't think the problem was IMP, cause, like I wrote you in the
> first
> email,
> > with the old version of MYSQL works correctly.
> > The DB's tables has the right fields, this is the making:
> > CREATE TABLE active_sessions (
> > sid varchar(32) NOT NULL,
> > name varchar(32) NOT NULL,
> > val text,
> > changed varchar(14) NOT NULL,
> > PRIMARY KEY (name, sid),
> > KEY changed (changed)
> > );
> > Seems to be a problem for the socket, or maybe for the thread
> definitions.
> > I tried to change the config file my.cnf and it works in a bad way.
> >
> > I really apreciate your interesting
> > Thank you
> > A.
> >
> >
> > Scrive Rolf Hopkins <[EMAIL PROTECTED]>:
> >
> > > Firstly, you should reply to the list as I may not know the answer.
> For
> > > starters I don't know IMP so if it is more of an IMP problem, I
> can't
> > > help
> > > you.
> > >
> > > The only thing I can think of is that your columns aren't defined
> > > properly
> > > to hold your data. For example, without looking at the manual, the
> only
> > > 2
> > > column types I can think of, that would be suitable for the val
> column,
> > > are
> > > text and blob.
> > >
> > > ----- Original Message -----
> > > From: "Aldo Spano" <[EMAIL PROTECTED]>
> > > To: "Rolf Hopkins" <[EMAIL PROTECTED]>
> > > Sent: Friday, June 08, 2001 16:53
> > > Subject: Re: MYSQL error
> > >
> > >
> > > > I saw in the log that there is an error with the communication.
> This
> > > is a
> > > line
> > > > from the log:
> > > >
> > > > 010608 4:30:07 Aborted connection 274940 to db: 'horde' user:
> > > 'hordemgr'
> > > host:
> > > > `localhost' (Got an error reading communication packets)
> > > >
> > > > IMP is wrote with php and for this error in the page appear an
> error
> > > like:
> > > >
> > > > Database error (HordeDB): Invalid SQL: insert into active_sessions
> (
> > > sid,
> > > name,
> > > > val, changed ) values ('62f84000b07f13f8f8da50855c978199',
> > > > 'HordeSession',
> > > >
> > >
> 'base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5wdFsnaW1w
> > >
> J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXSA9IG5ldyBJbXBTZXNzaW9uOyAkR0xPQkFMU1snaW1w
> > >
> J10tPmRhdGEgPSBhcnJheSgpOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ3NlcnZlciddID0gJ2xv
> > >
> Y2FsaG9zdCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncG9ydCddID0gJzE0Myc7ICRHTE9CQUxT
> > >
> WydpbXAnXS0+ZGF0YVsnc2VydnR5cGUnXSA9ICdpbWFwJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRh
> > >
> Wyd1c2VyJ10gPSAnYWxkbyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncGFzcyddID0gJzRtbTFu
> > >
> MXN0cjR0MHIzJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRhWydtYWlsYm94J10gPSAnSU5CT1gnOyAk
> > >
> R0xPQkFMU1snaW1wJ10tPmRhdGFbJ2tleSddID0gJyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsn
> > >
> bXNnbCddID0gJzExMTk6MTMyMToxMzM4OjEzNDU6MTM0NjoxMzc2OjEzODA6MTM4OToxMzkyOjEz
> > >
> OTM6MTM5NToxNDU3OjE0NjM6MTQ4MjoxNDg1OjE1MTE6MTUzNDoxNTU2OjE1NjE6MTU2NDoxNTY1
> > >
> OjE1Njc6MTYxOToxNjIwOjE2NDU6MTY1MToxNjkwOjE2OTI6MTY5MzoxNzQxOjE3NDk6MTc3Njox
> > >
> NzkyOjE3OTM6MTgwMzoxODE0OjE4MTc6MTgyMToxODIyOjE4NDE6MTg2NjoxODY4OjE4NzM6MTkz
> > >
> MzoyMDA1OjIwMzI6MjA2MToyMDc4OjIxNDA6MjE2OToyMTk3OjIyMzc6MjI1ODoyMjY0OjIyNzM6
> > >
> MjI3NDoyMzI1OjIzNTM6MjM1NjoyMzU3OjIzNTk6MjM2MDoyMzYyOjIzNzM6MjM3NToyMzc3OjIz
> > >
> Nzg6MjM4NzoyNDIxOjI0MjY6MjQ2NjoyNjE1OjI2NDg6MjY4ODoyNzk5OjI4MDA6MjgwMToyODAy
> > >
> OjI4MDM6MjgwNCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnZm9sZGVycyddID0gJyc7ICRHTE9C
> > >
> QUxTWydpbXAnXS0+ZGF0YVsnc29ydGJ5J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0
> YVsn
> > >
> c29ydGRpciddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ2RlbGhpZGUnXSA9ICcnOyAk
> > >
> R0xPQkFMU1snaW1wJ10tPmRhdGFbJ29mZnNldCddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRh
> > > dGFbJ2Zyb21fc2VydmVyJ10gPSAnaXRhbGlhbi5pdCc7IA==',
> > > > '20010608105204')
> > > > Database error (HordeDB): Session: freeze() failed.
> > > >
> > > >
> > > > Thanks
> > > > Aldo
> > > >
> > > >
> > > >
> > > > Scrive Rolf Hopkins <[EMAIL PROTECTED]>:
> > > >
> > > > > What is the error?
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Aldo Spano" <[EMAIL PROTECTED]>
> > > > > To: <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, June 07, 2001 21:34
> > > > > Subject: MYSQL error
> > > > >
> > > > >
> > > > > > I use mysql with IMP, a webmail application very nice and
> fast.
> > > Till I
> > > > > used the
> > > > > > old version of Mysql 3.22.xx i had no problem. Now i upgrade
> to
> > > the
> > > > > new
> > > > > one and
> > > > > > often i have problem with mysql cause it doesn't read the
> packet
> > > from
> > > > > the
> > > > > > applicatione and it prints a page error on the web.
> > > > > > Someone can help me.
> > > > > > Thanks
> > > > > >
> > > > > > -----------
> > > > > > Aldo Spanò
> > > > > > www.italian.it
> > > > > >
> > > > > >
> > >
> ---------------------------------------------------------------------
> > > > > > Before posting, please check:
> > > > > > http://www.mysql.com/manual.php (the manual)
> > > > > > http://lists.mysql.com/ (the list archive)
> > > > > >
> > > > > > To request this thread, e-mail
> <[EMAIL PROTECTED]>
> > > > > > To unsubscribe, e-mail
> > > > > <[EMAIL PROTECTED]>
> > > > > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > -----------
> > > > Aldo Spanò
> > > > Cell: 0347/5355413
> > > > www.italian.it
> > >
> > >
> >
> >
> >
> > -----------
> > Aldo Spanò
> > Cell: 0347/5355413
> > www.italian.it
>
>
-----------
Aldo Spanò
Cell: 0347/5355413
www.italian.it
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
