Topic: Îøèáêà: mySQL error: Table 'p' is marked as crashed and should be repaired (Read 13554 times)

raz77 · « **on:** May 11, 2008, 02:13:30 pm »

Âñåì ïðèâåò!
Çàõîæó ñåãîäíÿ íà ñàéò è âèæó ñëåä. êàðòèíó.

Ïðîèçîøëà îøèáêà ïðè îáðàùåíèè ê áàçå äàííûõ.

Âîò òî ÷òî ÿ óâèäåë

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

Ïðîøó óâàæàåìûõ çíàòîêîâ Êîïïåðìàéíà ïåðåâåñòè ýòî íà ïîíÿòíûé ÿçûê!

Alex Revo · « **Reply #1 on:** May 11, 2008, 08:04:32 pm »

Откройте базу сайта в PhpMyAdmin и выполните восстановление (repair) таблиц.

raz77 · « **Reply #2 on:** May 11, 2008, 11:00:46 pm »

Îòêðîéòå áàçó ñàéòà â 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 ïîëíûé íóëü....

raz77 · « **Reply #3 on:** May 12, 2008, 06:47:23 pm »

Óâàæàåìûå ôîðóì÷àíå!!!
Íåóæåëè íèêòî íå ìîæåò áîëüøå äàòü ìíå äåëüíûé ñîâåò - â êàêîì íàïðàâëåíèè èäòè ÷òîáû ïîïûòàòüñÿ âîññòàíîâèòü ôîòîãàëåðåþ.
Ãàëåðåþ ñîçäàâàë áåç ãëóáîêèõ ïîçíàíèé è áåç Âàøåé ïîìîùè ÿ ê ñîæàëåíèþ íå ðàçáåðóñü.
Åñëè åñòü ó êîãî-òî êàêèå òî îòâåòû áóäüòå ëþáåçíû ïîìîãèòå!!!
Î÷åíü íå õî÷åòñÿ òåðÿòü òî ÷òî ñîçäàíî - ïî÷òè 1000 ôîòîãðàôèé!

Makc666 · « **Reply #4 on:** May 13, 2008, 01:36:43 am »

Quote from: raz77 on May 12, 2008, 06:47:23 pm

Óâàæàåìûå ôîðóì÷àíå!!!
Íåóæåëè íèêòî íå ìîæåò áîëüøå äàòü ìíå äåëüíûé ñîâåò - â êàêîì íàïðàâëåíèè èäòè ÷òîáû ïîïûòàòüñÿ âîññòàíîâèòü ôîòîãàëåðåþ.
Ãàëåðåþ ñîçäàâàë áåç ãëóáîêèõ ïîçíàíèé è áåç Âàøåé ïîìîùè ÿ ê ñîæàëåíèþ íå ðàçáåðóñü.
Åñëè åñòü ó êîãî-òî êàêèå òî îòâåòû áóäüòå ëþáåçíû ïîìîãèòå!!!
Î÷åíü íå õî÷åòñÿ òåðÿòü òî ÷òî ñîçäàíî - ïî÷òè 1000 ôîòîãðàôèé!

Ñåðâåð âàø?
Äà - Îñòàíîâèòå Apache. Îñòàíîâèòå áàçó äàííûõ. Çàïóñòèòå áàçó äàííûõ. Çàïóñòèòå Apache. Âûïîëíèòå ïðîâåðêó òàáëèö â phpMyAdmin åù¸ ðàç.
Íåò - Âûïîëíèòå ïðîâåðêó òàáëèö â phpMyAdmin åù¸ ðàç.

È ñêàæèòå íàì (ñêîïèðóéòå) îòâåò, êîòîðûé Âû ïîëó÷èòå â phpMyAdmin ïîñëå äàííîé îïåðàöèè..

P.S. Íàçûâàéòå òåìû ïî ÷åëîâå÷åñêè, à òî áóäåì óäàëÿòü!

GeXu3 · « **Reply #5 on:** May 13, 2008, 02:04:02 pm »

Я в своё время проблему падающих индексов решил хитрым индексфайлом. Мож немного грубовато, зато за 1.5 года работы небыло ни одного "галерея не работает - таблицы упали", хотя до этого стабильно 3-4 раза в неделю сыпались.

Code: [Select]

<?php

/* &#1053;&#1072;&#1089;&#1090;&#1088;&#1086;&#1081;&#1082;&#1080; */
$db_server = 'localhost';
$db_login = '&#1083;&#1086;&#1075;&#1080;&#1085;';
$db_password = '&#1087;&#1072;&#1088;&#1086;&#1083;&#1100;';
$db_base = '&#1080;&#1084;&#1103; &#1073;&#1072;&#1079;&#1099;';
$db_prefix = '&#1087;&#1088;&#1077;&#1092;&#1080;&#1082;&#1089;_';

$site_destination = 'index.php'; # &#1082;&#1091;&#1076;&#1072; &#1087;&#1086;&#1089;&#1083;&#1077; &#1074;&#1086;&#1089;&#1089;&#1090;&#1072;&#1085;&#1086;&#1074;&#1083;&#1077;&#1085;&#1080;&#1103; &#1086;&#1090;&#1087;&#1088;&#1072;&#1074;&#1083;&#1103;&#1090;&#1100;

/* &#1044;&#1074;&#1080;&#1078;&#1086;&#1082;. &#1058;&#1091;&#1090; &#1085;&#1080;&#1095;&#1077; &#1085;&#1077; &#1090;&#1088;&#1086;&#1075;&#1072;&#1090;&#1100; */
mysql_connect($db_server,$db_login,$db_password);
#mysql_query('SET NAMES utf8'); # &#1084;&#1072;&#1083;&#1086; &#1083;&#1080;, &#1084;&#1086;&#1078; &#1073;&#1072;&#1079;&#1072; &#1085;&#1077;&#1087;&#1086;&#1085;&#1103;&#1090;&#1085;&#1086; &#1074; &#1095;&#1077;&#1084; &#1073;&#1077;&#1075;&#1072;&#1077;&#1090;
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 - скрипт-лечильник.

Почему вместо чека выбран селект первой строки по всей базе? Потому что делать полный чек - сильно тяжело, а быстрый чек многого не ловит. А вот в этом случае всё делаеццо на реальной задаче - смогло выбрать первую строку - молодец.

Скрипт старый - если кто оптимизирует и напишет об этом то только хорошо будет. Тут главное - идея.

raz77 · « **Reply #6 on:** May 13, 2008, 07:15:29 pm »

Quote

È ñêàæèòå íàì (ñêîïèðóéòå) îòâåò, êîòîðûé Âû ïîëó÷èòå â phpMyAdmin ïîñëå äàííîé îïåðàöèè..

Òàáëèöû ïðîâåðèë - âåçäå íàïèñàíî ÎÊ
Íî íèæå âûäàåò âîò òàêîå ñîîáùåíèå

Code: [Select]

 Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `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`

Â êàêîì íàïðàâëåíèè äâèãàòüñÿ äàëüøå?
Çàðàíåå ñïàñèáî çà ëþáîé îòâåò

Makc666 · « **Reply #7 on:** May 16, 2008, 11:28:15 am »

Quote from: raz77 on May 13, 2008, 07:15:29 pm

Òàáëèöû ïðîâåðèë - âåçäå íàïèñàíî ÎÊ
Íî íèæå âûäàåò âîò òàêîå ñîîáùåíèå

Code: [Select]
Ïðîáëåìû ñ èíäåêñàìè òàáëèöû `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

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

->> FROM cpg1410_albums

Âû æå äåëàëè ïðîâåðêó íà òàáëèöå -> cpg140_pictures

Ñäåëàéòå ïðîâåðêó äëÿ cpg1410_albums

News:

Author Topic: Îøèáêà: mySQL error: Table 'p' is marked as crashed and should be repaired (Read 13554 times)

raz77

Îøèáêà: mySQL error: Table 'p' is marked as crashed and should be repaired

Alex Revo

Re: И снова об ошибках!

raz77

Re: È ñíîâà îá îøèáêàõ!

raz77

Re: È ñíîâà îá îøèáêàõ!

Makc666

Re: È ñíîâà îá îøèáêàõ!

GeXu3

Re: Îøèáêà: mySQL error: Table 'p' is marked as crashed and should be repaired

raz77

Re: Îøèáêà: mySQL error: Table 'p' is marked as crashed and should be repaired

Makc666

Re: Îøèáêà: mySQL error: Table 'p' is marked as crashed and should be repaired