Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: leami on February 12, 2008, 01:32:23 PM

Title: Host not accessible - ID_TOPIC `` should not be part of both a unique key
Post by: leami on February 12, 2008, 01:32:23 PM
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
Title: Re: Host not accessible - ID_TOPIC `` should not be part of both a unique key
Post by: Ben_S on February 12, 2008, 01:53:40 PM
1> Thats just phpMyAdmin being stupid, you can ignore it.

2> Mysql going away is something you will need to ask your host about.
Title: Re: Host not accessible - ID_TOPIC `` should not be part of both a unique key
Post by: leami on February 12, 2008, 05:07:35 PM
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
Title: Re: Host not accessible - ID_TOPIC `` should not be part of both a unique key
Post by: 青山 素子 on February 12, 2008, 06:51:29 PM
What version of MySQL is the host running?