Problem z baza danych.

[ankoupl]

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 29 Dec 2012 20:06:13 +0000
 Error: 144 - Table './pawlo123_forumipb/posts' is marked as crashed and last (automatic?) repair failed
 IP Address: 88.199.129.102 - /
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT COUNT(*) as tpost, p.author_id FROM posts p  LEFT JOIN topics t ON ( t.tid=p.topic_id )   WHERE p.post_date > 1356725173 AND t.forum_id IN(9,43,278,36,10,11,153,13,15,14,16,47,94,126,79,86,341,101,155,190,133,327,285,111,112,122,107,309,38,417,44,55,56,221,57,168,24,20,28,179,32,39,310,170,25,21,29,181,33,40,92,312,169,26,22,30,180,34,41,311,171,27,23,31,182,35,42,152,214,313,161,164,163,162,408,386,387,388,389,390,391,393,394,395,396,397,398,399,400,401,385,211,212,48,50,167,51,52,340,283,269,58,65,66,67,68,69,198,237,76,77,78,173,81,80,82,184,83,84,132,217,315,174,88,87,89,185,90,91,279,316,172,96,95,97,183,98,99,100,213,314,176,103,102,104,187,105,106,249,317,108,109,110,117,118,119,120,113,114,115,116,121,250,141,139,142,148,143,145,146,151,149,150,144,147,123,124,125,175,128,127,129,186,130,265,216,266,272,273,178,135,134,136,189,137,138,154,275,276,277,177,157,156,158,188,159,160,208,280,191,192,193,194,195,196,270,268,251,252,303,286,364,365,287,288,407,318,328,329,330,331,332,366,333,334,335,336,406,342,343,344,345,346,347,348,349,350,351,409,410,375,376,377,378,381,382,383,384,380,369,374,370,372,379,412,413,414,415,416,418,419,420,421) GROUP BY p.author_id ORDER BY tpost DESC LIMIT 0,9
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/output/publicOutput.php                              | [boardIndexTopPosters].getOutput                                              | 3462              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/output/publicOutput.php                              | [output].templateHooks                                                        | 2724              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/boards.php                 | [output].sendOutput                                                           | 124               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_boards].doExecute                                       | 306               |

Witam.

Od jakiegos czasu na forum wyskakują bledy z baza danych. Wcześniej pomagał ich naprawa w penelu, jednak dzisiaj bez rezulatów.

Proszę o pomoc.

Działa sb, profile, panel. Tylko wszysto co związane z postami leży.

Edytowane 29 Grudnia 2012 przez ankoupl

[Saygon]

O to wycinek z PA:

 

http://i47.tinypic.com/dned6r.jpg

 

I od razu mowie tabela posts została optymalizowana i naprawiana co nic nie dało. Raczej nie dało jej się naprawić.

 

A tu pełne logi z ftp: http://www.sendspace.pl/file/429d7460c7d679abadd5f42

 

Prosimy o pomoc.

[DawPi]

Lepiej niech się da naprawić tę tabelę, bo się możesz z postami pożegnać. Jak przez PMA nie idzie to napisz do admina serwera, niech zrobią przez SSH np.

[dudeka]

Forum działa.

 

 

Do zamknięcia

[Arek88]

Napisz jak to naprawiłeś dla potomnych.

[DawPi]

Co pomogło?

[dudeka]

Co pomogło ? 

Zaznaczenie tabeli posts i naprawienie jej przez PMA

 

Czyli to co zwykle

Edytowane 29 Grudnia 2012 przez dudeka