XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / Primary and Index key table warnings
Register
1
Stewdio
Primary and Index key table warnings

  • 2006/1/24 5:18

  • Stewdio

  • Community Support Member

  • Posts: 1560

  • Since: 2003/5/7 1


Can anyone tell me if this is signifigant or not. I have been troubleshooting some module errors and my knowledge in sql queries is less then spectactular.

I ran a query in phpMyAdmin and here are the results.

Problems with indexes of table `xoops_banner`
Warning PRIMARY and INDEX keys should not both be set for column `bid`
Problems with indexes of table `xoops_bb_posts`
Warning More than one INDEX key was created for column `topic_id`
Problems with indexes of table `xoops_bb_topics`
Warning PRIMARY and INDEX keys should not both be set for column `topic_id`
Problems with indexes of table `xoops_block_instance`
Warning PRIMARY and INDEX keys should not both be set for column `instanceid`
Problems with indexes of table `xoops_newblocks`
Warning PRIMARY and INDEX keys should not both be set for column `bid`
Problems with indexes of table `xoops_priv_msgs`
Warning More than one INDEX key was created for column `to_userid`
Problems with indexes of table `xoops_ranks`
Warning More than one INDEX key was created for column `rank_min`
Problems with indexes of table `xoops_users`
Warning PRIMARY and INDEX keys should not both be set for column `uid`
Warning More than one INDEX key was created for column `uname`
Problems with indexes of table `xoops_xcgal_pictures`
Warning More than one INDEX key was created for column `aid`
Problems with indexes of table `xoops_xoopspoll_log`
Warning More than one INDEX key was created for column `poll_id`
XOOPS Community Support
2
leseci
Re: Primary and Index key table warnings

  • 2006/1/30 1:57

  • leseci

  • Just popping in

  • Posts: 9

  • Since: 2005/3/5 2


Se nota que nadie sabe nada o no tienen ganas de contestar.

El mismo problema pero nadie contesta
3
Stewdio
Re: Primary and Index key table warnings

  • 2006/1/30 3:10

  • Stewdio

  • Community Support Member

  • Posts: 1560

  • Since: 2003/5/7 1


Uhm yeah sure, thanks!
XOOPS Community Support
4
Quest
Re: Primary and Index key table warnings

  • 2006/7/10 1:11

  • Quest

  • Friend of XOOPS

  • Posts: 1034

  • Since: 2005/11/19


Are stewdio and I like the only ones with this problem? Can't someone help us out? Please?
He posted it back in January and I posted similiar today. Did searches and found nothing. Finally snaged one and it was this post by stewdio reaching out too.

And there's another one by zagreb too, from back in Sep of 2005.
https://xoops.org/modules/newbb/viewtopic.php?topic_id=48780&forum=1&post_id=214095#forumpost214095

Gosh I hate sobbing almost as much as begging.

Quest
5
Dave_L
Re: Primary and Index key table warnings

  • 2006/7/10 2:31

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


I don't think it's important, but you could remove the extra index if you want.

Here's some more info:
http://community.postnuke.com/module-Forum-viewtopic-topic-45004.htm

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

102 user(s) are online (57 user(s) are browsing Support Forums)

Members: 0

Guests: 102

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits