View Issue Details

IDProjectCategoryView StatusLast Update
0008748mantisbtdb mysqlpublic2008-04-19 04:10
Reporterdosenberg Assigned Tothraxisp  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
PlatformLinuxOSSuSE LinuxOS Version10.2
Product Version1.1.0 
Fixed in Version1.2.0a1 
Summary0008748: phpMyAdmin reports a warning message
Description

phpMyAdmin reports a warning message on mantis_project_table:

PRIMARY and INDEX keys should not both be set for column id

Related to issue 0007712 (same message, other table, other mantis version).

Additional Information

phpMyAdmin Version: 2.9.1.1
MySQL Version: 5.0.26

TagsNo tags attached.

Activities

PatPowerMan

PatPowerMan

2008-01-20 04:51

reporter   ~0016726

The same message appears for the table: 'mantis_news_table'
PRIMARY and INDEX keys should not both be set for column id

MySQL 5.0.51
phpMyAdmin 2.11.3
Mantis 1.1.1

thraxisp

thraxisp

2008-01-20 21:34

reporter   ~0016738

fixed in SVN r4922

The extra indexes on mantis_news_table aren't in the current code base. I suspect that they may have been added manually, or as a result of a recommendation in the forums.