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
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
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
> 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]

Reply via email to