Welcome to Geeklog, Anonymous Thursday, June 13 2024 @ 07:19 am EDT

Geeklog Forums

MySQL Error

Status: offline


Forum User
Registered: 10/18/06
Posts: 21
Looking in phpMyAdmin trying to resolve problems with phpBB and have noticed that in some of the tables, including gl_users, there is the following

Text Formatted Code
PRIMARY and INDEX keys should not both be set for column `uid`
in a red box under Indexes:

Text Formatted Code
PRIMARY  PRIMARY 121       uid  
LOGIN  INDEX 121       uid  
users_username  INDEX 121       username  
users_fullname  INDEX 121       fullname  
users_email  INDEX 121       email  
users_passwd  INDEX 121       passwd  
users_pwrequestid  INDEX 121       pwrequestid  

I haven't changed anything in the database and this was a fresh install, therefore not sure if a server setting has done this or something in the MySQL install file?

Do I need to make any changes?

Many thanks


All times are EDT. The time is now 07:19 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content