There are settings that could probably fix the problem then but I would need
to RTFM.
----- Original Message -----
From: "Aldo Spano" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 0:03
Subject: Re: MYSQL error
> 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