[PHP] Re: Select distinct error!
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]
[PHP] Re: Select distinct error!
Whoops. Hit send too soon. It could just be that your table is too darn big for select distinct on the hardware you have... What's your disk space like on MySQL's "data" drive? df -h You'll need to figure out which partition holds MySQL's data directory, and see how much free space is there. -- 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]