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 [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
Newsgroups: php.general
To: <[EMAIL PROTECTED]>
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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
