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

[raz77]

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

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

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


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]

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

[raz77]

Îòêðîéòå áàçó ñàéòà â 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]

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

[Makc666]

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

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

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

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

[GeXu3]

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

Code Select Expand


<?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]

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

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

Code Select Expand

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

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

Code Select Expand

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

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

Ó Âàñ â ïåðâîì ñîîáùåíèè íàïèñàíî:

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