Âñåì ïðèâåò!
Çàõîæó ñåãîäíÿ íà ñàéò è âèæó ñëåä. êàðòèíó.
Ïðîèçîøëà îøèáêà ïðè îáðàùåíèè ê áàçå äàííûõ.
Âîò òî ÷òî ÿ óâèäåë
While executing query "SELECT a.aid, count( p.pid ) AS pic_count, max( p.pid ) AS last_pid, max( p.ctime ) AS last_upload, a.keyword FROM cpg1410_albums AS a LEFT JOIN cpg1410_pictures AS p ON a.aid = p.aid AND p.approved = 'YES' WHERE a.aid IN (10, 54, 43, 12, 2, 39, 36, 37, 47, 46, 44, 4, 52, 40)GROUP BY a.aid" on 0
mySQL error: Table 'p' is marked as crashed and should be repaired
Ïðîøó óâàæàåìûõ çíàòîêîâ Êîïïåðìàéíà ïåðåâåñòè ýòî íà ïîíÿòíûé ÿçûê!
Откройте базу сайта в PhpMyAdmin и выполните восстановление (repair) таблиц.
Îòêðîéòå áàçó ñàéòà â PhpMyAdmin è âûïîëíèòå âîññòàíîâëåíèå (repair) òàáëèö.
Ñäåëàë, íî ïðîáëåìà êàê áûëà òàê è îñòàëàñü :(
Åùå âîò òàêèå ôðàçû âûñêàêèâàþò
Áîëüøå îäíîãî INDEX êëþ÷à ñîçäàíî äëÿ êîëîíêè `aid`
PRIMARY and INDEX keys should not both be set for column `anid`
PRIMARY and INDEX keys should not both be set for column `bid`
È ò.ä. áåñêîíå÷íîå ìíîæåñòâî.....
Ê ñîæàëåíèþ ÿ â PHP ïîëíûé íóëü....
Óâàæàåìûå ôîðóì÷àíå!!!
Íåóæåëè íèêòî íå ìîæåò áîëüøå äàòü ìíå äåëüíûé ñîâåò - â êàêîì íàïðàâëåíèè èäòè ÷òîáû ïîïûòàòüñÿ âîññòàíîâèòü ôîòîãàëåðåþ.
Ãàëåðåþ ñîçäàâàë áåç ãëóáîêèõ ïîçíàíèé è áåç Âàøåé ïîìîùè ÿ ê ñîæàëåíèþ íå ðàçáåðóñü.
Åñëè åñòü ó êîãî-òî êàêèå òî îòâåòû áóäüòå ëþáåçíû ïîìîãèòå!!!
Î÷åíü íå õî÷åòñÿ òåðÿòü òî ÷òî ñîçäàíî - ïî÷òè 1000 ôîòîãðàôèé!
Quote from: raz77 on May 12, 2008, 06:47:23 PM
Óâàæàåìûå ôîðóì÷àíå!!!
Íåóæåëè íèêòî íå ìîæåò áîëüøå äàòü ìíå äåëüíûé ñîâåò - â êàêîì íàïðàâëåíèè èäòè ÷òîáû ïîïûòàòüñÿ âîññòàíîâèòü ôîòîãàëåðåþ.
Ãàëåðåþ ñîçäàâàë áåç ãëóáîêèõ ïîçíàíèé è áåç Âàøåé ïîìîùè ÿ ê ñîæàëåíèþ íå ðàçáåðóñü.
Åñëè åñòü ó êîãî-òî êàêèå òî îòâåòû áóäüòå ëþáåçíû ïîìîãèòå!!!
Î÷åíü íå õî÷åòñÿ òåðÿòü òî ÷òî ñîçäàíî - ïî÷òè 1000 ôîòîãðàôèé!
Ñåðâåð âàø?
Äà - Îñòàíîâèòå Apache. Îñòàíîâèòå áàçó äàííûõ. Çàïóñòèòå áàçó äàííûõ. Çàïóñòèòå Apache. Âûïîëíèòå ïðîâåðêó òàáëèö â phpMyAdmin åù¸ ðàç.
Íåò - Âûïîëíèòå ïðîâåðêó òàáëèö â phpMyAdmin åù¸ ðàç.
È ñêàæèòå íàì (ñêîïèðóéòå) îòâåò, êîòîðûé Âû ïîëó÷èòå â phpMyAdmin ïîñëå äàííîé îïåðàöèè..
P.S. Íàçûâàéòå òåìû ïî ÷åëîâå÷åñêè, à òî áóäåì óäàëÿòü!
Я в своё время проблему падающих индексов решил хитрым индексфайлом. Мож немного грубовато, зато за 1.5 года работы небыло ни одного "галерея не работает - таблицы упали", хотя до этого стабильно 3-4 раза в неделю сыпались.
<?php
/* Настройки */
$db_server = 'localhost';
$db_login = 'логин';
$db_password = 'пароль';
$db_base = 'имя базы';
$db_prefix = 'префикс_';
$site_destination = 'index.php'; # куда после восстановления отправлять
/* Движок. Тут ниче не трогать */
mysql_connect($db_server,$db_login,$db_password);
#mysql_query('SET NAMES utf8'); # мало ли, мож база непонятно в чем бегает
mysql_selectdb($db_base);
$sql_query = "show tables like '$db_prefix%'";
$s_base = mysql_query($sql_query);
$s_size = mysql_num_rows($s_base);
$tables = '';
for($i = 1; $i <= $s_size; $i++) {
$tmp = mysql_fetch_array($s_base);
if ($i != $s_size) {
$tables .= $tmp['Tables_in_' . $db_base] . ',';
} else {
$tables .= $tmp['Tables_in_' . $db_base];
}
}
$sql_query = "Select
*
From
$tables
Limit 0, 1";
@$s_base = mysql_query($sql_query);
@$s_error = mysql_errno();
if ($s_error!=0) {
$sql_query="REPAIR TABLE $tables";
@mysql_query($sql_query);
}
mysql_close();
header("Location: $site_destination");
?>
Единственное че потом надо - в .htaccess вкинуть строку
DirectoryIndex fpage.php index.php index.htm index.html
где fpage.php - скрипт-лечильник.
Почему вместо чека выбран селект первой строки по всей базе? Потому что делать полный чек - сильно тяжело, а быстрый чек многого не ловит. А вот в этом случае всё делаеццо на реальной задаче - смогло выбрать первую строку - молодец.
Скрипт старый - если кто оптимизирует и напишет об этом то только хорошо будет. Тут главное - идея.
QuoteÈ ñêàæèòå íàì (ñêîïèðóéòå) îòâåò, êîòîðûé Âû ïîëó÷èòå â phpMyAdmin ïîñëå äàííîé îïåðàöèè..
Òàáëèöû ïðîâåðèë - âåçäå íàïèñàíî ÎÊ
Íî íèæå âûäàåò âîò òàêîå ñîîáùåíèå
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `cpg140_pictures` Áîëüøå îäíîãî INDEX êëþ÷à ñîçäàíî äëÿ êîëîíêè `aid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_authors` PRIMARY and INDEX keys should not both be set for column `aid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_autonews` PRIMARY and INDEX keys should not both be set for column `anid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_banned_ip` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_banner` PRIMARY and INDEX keys should not both be set for column `bid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_banner_clients` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_bbsessions` PRIMARY and INDEX keys should not both be set for column `session_id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_blocks` PRIMARY and INDEX keys should not both be set for column `bid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_comments` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_comments_moderated` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_categories` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_downloads` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_editorials` PRIMARY and INDEX keys should not both be set for column `downloadid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_modrequest` PRIMARY and INDEX keys should not both be set for column `requestid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_newdownload` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_votedata` PRIMARY and INDEX keys should not both be set for column `ratingdbid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_encyclopedia` PRIMARY and INDEX keys should not both be set for column `eid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_encyclopedia_text` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_faqanswer` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_faqcategories` PRIMARY and INDEX keys should not both be set for column `id_cat`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_headlines` PRIMARY and INDEX keys should not both be set for column `hid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_journal` PRIMARY and INDEX keys should not both be set for column `jid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_journal_comments` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_journal_stats` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_categories` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_editorials` PRIMARY and INDEX keys should not both be set for column `linkid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_links` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_modrequest` PRIMARY and INDEX keys should not both be set for column `requestid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_newlink` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_votedata` PRIMARY and INDEX keys should not both be set for column `ratingdbid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_message` PRIMARY and INDEX keys should not both be set for column `mid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_modules` PRIMARY and INDEX keys should not both be set for column `mid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pages` PRIMARY and INDEX keys should not both be set for column `pid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pages_categories` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pollcomments` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pollcomments_moderated` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_poll_desc` PRIMARY and INDEX keys should not both be set for column `pollID`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_public_messages` PRIMARY and INDEX keys should not both be set for column `mid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_queue` PRIMARY and INDEX keys should not both be set for column `qid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_referer` PRIMARY and INDEX keys should not both be set for column `rid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_related` PRIMARY and INDEX keys should not both be set for column `rid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews_add` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews_comments` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews_comments_moderated` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_stories` PRIMARY and INDEX keys should not both be set for column `sid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_stories_cat` PRIMARY and INDEX keys should not both be set for column `catid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_topics` PRIMARY and INDEX keys should not both be set for column `topicid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_users` PRIMARY and INDEX keys should not both be set for column `user_id`
 êàêîì íàïðàâëåíèè äâèãàòüñÿ äàëüøå?
Çàðàíåå ñïàñèáî çà ëþáîé îòâåò
Quote from: raz77 on May 13, 2008, 07:15:29 PM
Òàáëèöû ïðîâåðèë - âåçäå íàïèñàíî ÎÊ
Íî íèæå âûäàåò âîò òàêîå ñîîáùåíèå
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `cpg140_pictures` Áîëüøå îäíîãî INDEX êëþ÷à ñîçäàíî äëÿ êîëîíêè `aid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_authors` PRIMARY and INDEX keys should not both be set for column `aid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_autonews` PRIMARY and INDEX keys should not both be set for column `anid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_banned_ip` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_banner` PRIMARY and INDEX keys should not both be set for column `bid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_banner_clients` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_bbsessions` PRIMARY and INDEX keys should not both be set for column `session_id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_blocks` PRIMARY and INDEX keys should not both be set for column `bid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_comments` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_comments_moderated` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_categories` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_downloads` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_editorials` PRIMARY and INDEX keys should not both be set for column `downloadid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_modrequest` PRIMARY and INDEX keys should not both be set for column `requestid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_newdownload` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_downloads_votedata` PRIMARY and INDEX keys should not both be set for column `ratingdbid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_encyclopedia` PRIMARY and INDEX keys should not both be set for column `eid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_encyclopedia_text` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_faqanswer` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_faqcategories` PRIMARY and INDEX keys should not both be set for column `id_cat`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_headlines` PRIMARY and INDEX keys should not both be set for column `hid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_journal` PRIMARY and INDEX keys should not both be set for column `jid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_journal_comments` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_journal_stats` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_categories` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_editorials` PRIMARY and INDEX keys should not both be set for column `linkid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_links` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_modrequest` PRIMARY and INDEX keys should not both be set for column `requestid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_newlink` PRIMARY and INDEX keys should not both be set for column `lid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_links_votedata` PRIMARY and INDEX keys should not both be set for column `ratingdbid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_message` PRIMARY and INDEX keys should not both be set for column `mid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_modules` PRIMARY and INDEX keys should not both be set for column `mid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pages` PRIMARY and INDEX keys should not both be set for column `pid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pages_categories` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pollcomments` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_pollcomments_moderated` PRIMARY and INDEX keys should not both be set for column `tid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_poll_desc` PRIMARY and INDEX keys should not both be set for column `pollID`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_public_messages` PRIMARY and INDEX keys should not both be set for column `mid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_queue` PRIMARY and INDEX keys should not both be set for column `qid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_referer` PRIMARY and INDEX keys should not both be set for column `rid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_related` PRIMARY and INDEX keys should not both be set for column `rid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews_add` PRIMARY and INDEX keys should not both be set for column `id`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews_comments` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_reviews_comments_moderated` PRIMARY and INDEX keys should not both be set for column `cid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_stories` PRIMARY and INDEX keys should not both be set for column `sid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_stories_cat` PRIMARY and INDEX keys should not both be set for column `catid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_topics` PRIMARY and INDEX keys should not both be set for column `topicid`
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `nuke_users` PRIMARY and INDEX keys should not both be set for column `user_id`
 êàêîì íàïðàâëåíèè äâèãàòüñÿ äàëüøå?
Çàðàíåå ñïàñèáî çà ëþáîé îòâåò
Ó Âàñ â ïåðâîì ñîîáùåíèè íàïèñàíî:
QuoteWhile executing query "SELECT a.aid, count( p.pid ) AS pic_count, max( p.pid ) AS last_pid, max( p.ctime ) AS last_upload, a.keyword FROM cpg1410_albums AS a LEFT JOIN cpg1410_pictures AS p ON a.aid = p.aid AND p.approved = 'YES' WHERE a.aid IN (10, 54, 43, 12, 2, 39, 36, 37, 47, 46, 44, 4, 52, 40)GROUP BY a.aid" on 0
->> FROM
cpg1410_albumsÂû æå äåëàëè ïðîâåðêó íà òàáëèöå ->
cpg140_picturesÑäåëàéòå ïðîâåðêó äëÿ
cpg1410_albums