Welcome to Geeklog, Anonymous Thursday, April 18 2024 @ 08:53 pm EDT
Geeklog Forums
MySQL Error
Status: offline
Anon
Forum User
Junior
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
in a red box under Indexes:
LOGIN INDEX 121 uid
passwd
username
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
Anon
Text Formatted Code
PRIMARY and INDEX keys should not both be set for column `uid`Text Formatted Code
PRIMARY PRIMARY 121 uid LOGIN INDEX 121 uid
passwd
username
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
Anon
5
8
Quote
All times are EDT. The time is now 08:53 pm.
- 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