Re: Select distinct error!
| From: | Richard Lynch | Date: | Sat, 22 Sep 2001 02:57:55 +0000 |
| Subject: | Re: Select distinct error! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-68278@lists.php.net to get a copy of this message | ||
I'm guessing the table is messed up...
Back up your database, and try running those ISAM check utilities that MySQL
provides to verify database integrity.
--
WARNING richard@zend.com address is an endangered species -- Use
ceo@l-i-e.com
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: Sophokles Zafeiris <sofoklis@biznet.gr>
Newsgroups: php.general
To: <php-general@lists.php.net>
Sent: Thursday, September 20, 2001 9:28 AM
Subject: Select distinct error!
> Hi,
> I' m trying to execute a "select distinct" command on a table and I get
the
> following error:
> ERROR 1022: Can't write, duplicate key in table 'pmall'
> My table is about 2,7 MBytes.
> Does anybody knows what's wrong?
> I use MySQL 3.23.40 on a Solaris 7 (intel) machine.
>
> Sofoklis
>