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

Who's Online

358 user(s) are online (276 user(s) are browsing Support Forums)


Members: 0


Guests: 358


more...

Donat-O-Meter

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

Latest GitHub Commits