Advertisement:

Author Topic: Host not accessible - ID_TOPIC `` should not be part of both a unique key  (Read 3289 times)

Offline leami

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Female
  • FotoGraph
    • Pixelartese
Hello

The site has cut 5 a 6 fois / days

Loss of data tables

I do not know what to do
Thanks for your help

error mysql
table smf_messages
-----------------------

The column ID_TOPIC `` should not be part of both a unique key and a key index
The column ID_MEMBER `` should not be part of both a unique key and a key index
More than one type INDEX index exists for the column `` ID_MEMBER

--------------------------------------



Buzy serveur

messages :
----------------------------------------
: Lost connection to MySQL server during query
/mounted-storage/home28a/sub002/sc25512-KYSD/www/p/forum/Sources/Load.php
390: MySQL server has gone away
/mounted-storage/home28a/sub002/sc25512-KYSD/www/p/forum/Sources/Load.php
2005

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
----------------------------------------

? thank for assistance

best regard

leami

http://p.artese.eu

french
SMF version 2.0 RC3  -  http://www.pixelartese.com  Forum des Arts plastiques et Photographies



Site Perso : http://www.photomaltese.com

Offline Ben_S

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,702
  • xxx
1> Thats just phpMyAdmin being stupid, you can ignore it.

2> Mysql going away is something you will need to ask your host about.
Liverpool FC Forum with 14 million+ posts.

Offline leami

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Female
  • FotoGraph
    • Pixelartese
the host 2 posts : oki
forum admin maintenance oki

But the site buzy 5  :(

--------------------------------------
Hello ,

I have checked and found that the url at http://p.artese.eu/forum/ is loading fine without any error.
Kind regards,
Servage - Support
Servage Hosting
---------------------------------------

Hello ,


This forum website http://p.artese.eu/forum/ is working fine without any error returning. It seems to be intermittent though. Kindly optimize the database tables associated with it from phpmyadmin. It is advisable to optimize the database tables periodically whenever the website appears to be slow or error crops up.

Thank you :)

Kind regards,
Support Team Member
SMF version 2.0 RC3  -  http://www.pixelartese.com  Forum des Arts plastiques et Photographies



Site Perso : http://www.photomaltese.com

Offline 青山 素子

  • Server Team
  • SMF Super Hero
  • *
  • Posts: 17,022
  • 戦場ヶ原、蕩れ!
    • srvrguy on GitHub
    • @motokochan on Twitter
    • Nekomusume Moe
What version of MySQL is the host running?
Motoko-chan
Director, Simple Machines

Just because it's pouring down doesn't mean we're gonna drown. There's a time when all you can say is let it rain - Mat Kearney (Let It Rain)

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.