[imp] IMP/database problem

[Iceman]

Hi,

in ct_sql.inc (either in phplib directory or horde directory) , search for
"insert" , and replace it with "replace".

Then it will work :-)

Notice that this question was already asked, and the problem has been solved
(see the archive).


----- Original Message -----
From: "Ed McMan" <EdMcMan@Yahoo.com>
To: <imp@lists.horde.org>
Sent: Wednesday, August 29, 2001 9:39 PM
Subject: [imp] IMP/database problem


>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi everyone.  I running IMP at home for my family and a few friends.
> It works great, except for one problem.  I am using slackware 8, and
> the provided apache, with a php I compiled with ldap and imap
> support.  It works, but I get strange errors sometimes after logging
> in, only in the 3 smaller frames though.  Here is a sample of one of
> the errors:
> Database error: Invalid SQL: insert into active_sessions ( sid, name,
> val, changed ) values ('82b0225d962bf8b7bf845de40fc1438d',
> 'HordeSession',
> 'base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5wdF
> snaW1wJ10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXSA9IG5ldyBJbXBTZXNzaW9uOyAkR0xP
> QkFMU1snaW1wJ10tPmRhdGEgPSBhcnJheSgpOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ3
> NlcnZlciddID0gJ2xvY2FsaG9zdCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncG9ydCdd
> ID0gJzE0Myc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnc2VydnR5cGUnXSA9ICdpbWFwJz
> sgJEdMT0JBTFNbJ2ltcCddLT5kYXRhWyd1c2VyJ10gPSAnZWQnOyAkR0xPQkFMU1snaW1w
> J10tPmRhdGFbJ3Bhc3MnXSA9ICdtMDBtMDAyJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRhWy
> dtYWlsYm94J10gPSAnSU5CT1gnOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ2tleSddID0g
> Jyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnbXNnbCddID0gJyc7ICRHTE9CQUxTWydpbX
> AnXS0+ZGF0YVsnZm9sZGVycyddID0gJyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnc29y
> dGJ5J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnc29ydGRpciddID0gJzAnOy
> AkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ2RlbGhpZGUnXSA9ICcnOyAkR0xPQkFMU1snaW1w
> J10tPmRhdGFbJ29mZnNldCddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ2Zyb2
> 1fc2VydmVyJ10gPSAnbG9jYWxob3N0Jzsg', '20010829153341')
> MySQL Error: 1062 (Duplicate entry
> 'HordeSession-82b0225d962bf8b7bf845de40fc1438d' for key 1)
> Session halted.
>
> Horde and phplib are set up correctly and work, except for this
> error.  Refreshing the frame works fine.  Does anyone have an idea
> what the problem is?  TIA.
>
> - -------------------------------------------------------------
> |   Eddie J Schwartz <EdMcMan@m00.net> http://www.m00.net   |
> |     AIM: The Cypher ICQ: 35576339 PGP ID: 0x96CDDED4      |
> | "We Trills have an expression--at forty, you think you    |
> | know everything.  At four hundred, you realize you know   |
> |         nothing." - Dax, Star Trek Deep Space 9           |
> - -------------------------------------------------------------
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
> Comment: m00
>
> iQA/AwUBO41E9S6XaAWWzd7UEQINfwCgnnMGqDCgk9vcTi0zGj4vhdkSAJIAn1uN
> atW7k7jwp/Sf7otgdniKxeJr
> =aGhN
> -----END PGP SIGNATURE-----
>
>
> --
> IMP mailing list: http://horde.org/imp/
> Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>
>