Forum Moderators: coopster

Message Too Old, No Replies

How in the world did I break this now?

myphpadmin error

         

JackieB

10:30 pm on Apr 4, 2005 (gmt 0)

10+ Year Member



I was trying to discover why links are being clipped so I went snooping in my perfectly running myphpadmin.

I looked at the otions on one file and now I have this:

Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 4 linkid
linkid UNIQUE 4 linkid
PRIMARY and INDEX keys should not both be set for column `linkid

coopster

12:47 am on Apr 13, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I imagine you are getting the warning because you already have a field that is defined as the index therefore it is not necessary to define another index for the same field, but I could be wrong -- I don't use phpMyAdmin so I don't know it's intracacies. Anyone else?