Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 10:51 pm EST
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
12
14
Quote
All times are EST. The time is now 10:51 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