Перейти к контенту
  • 0

[IPB 3.4] Ошибки БД и тормоза


Leo_Skywalker

Вопрос

Приветствую!

 

Следующая проблема - имеется форум IPB 3.4.3, со вчерашнего дня неожиданно начались необъяснимые тормоза движка и появляются ошибки БД следующего типа:

 

 

 mySQL query error: SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.moved_to, t.views, t.posts, t.topic_answered_pid,m.*,pp.* FROM ibf_topics t  LEFT JOIN ibf_members m ON ( m.member_id=t.starter_id )
 LEFT JOIN ibf_profile_portal pp ON ( m.member_id=pp.pp_member_id )   WHERE t.tid IN (16228,16227,16226,16225,16224,16223,16222,16221,16220,16219)

 

 

 mySQL query error: SELECT p.pid as id, p.post_date, p.topic_id,t.title, t.posts, t.views FROM ibf_posts p  LEFT JOIN ibf_topics t ON ( t.tid=p.topic_id )   WHERE t.forum_id IN (222,6,66,7,876,1698,1717,903,594,19,22,2351,380,20,8,15,433,386,432,428,79,210,228,21,550,592,671,711,781,907,991,1077,1201,1338,1489,1552,1613,1723,1767,1922,1949,2266,2469,2470,2471,2352,195,196,197,198,199,271,377,378,25,2324,266,537,27,35,262,29,56,53,158,159,274,499,32,150,86,318,1660,1661,1662,1663,654,534,655,240,138,647,48,51,299,232,55,57,54,186,339,412,236,164,357,353,300,50,301,302,303,376,286,278,285,282,902,1234,1383,1384,1385,1744,280,283,284,157,1359,1345,1340,1043,510,446,1561,2394,1291,1292,1293,1294,1323,1324,201,1775,96,97,413,414,1102,223,103,407,1575,105,294,231,104,2235,361,436,605,116,108,2134,109,205,106,131,1087,126,1214,964,1021,1022,1026,1589,127,1935,1937,1942,1941,1938,1940,1939,1936,1632,2314,810,2441,264,2464,683,806,2542,2435,135,908,154,1822,1736,220,212,168,2,747,1543,1168,1167,1166,272,1792,2566,1980,1216,1261,1624,1541,1542,1376,1944,1657,1658,1461,813,717,489,648,1563,1564,1569,214,215,297,2079,1652,1653,1654,166,167,329,176,326,288,381,360,182,183,330,336,384,187,188,189,281,191,192,193,194,200,208,267,268,269,257,202,2122,2126,2188,2127,2129,160,221,672,970,390,349,382,139,101,123,224,277,87,327,16,389,275,305,165,80,162,163,185,289,290,291,292,293,551,566,567,801,952,1061,1244,1427,2223,2434,2538,247,320,244,254,308,239,368,967,843,681,227,472,473,535,888,1366,128,2121,298,1777,2238,2029,2030,1743,2031,1963,1955,1738,1739,1740,276,385,373,306,307,374,356,961,1361,152,153,111,112,211,219,344,226,230,296,98,190,334,366,309,310,311,319,911,1979,422,321,322,323,324,325,332,633,1379,1720,335,358,337,338,351,340,2167,2242,2168,971,972,354,359,367,1000,1082,2239,1850,95,115,1186,2521,363,730,107,5,14,13,375,36,47,58,28,38,650,649,426,651,693,449,498,395,699,835,623,626,91,369,370,371,372,1659,169,207,596,383,213,217,218,348,2463,352,462,598,393,394,400,401,437,601,408,517,409,1399,487,564,777,1066,1258,507,508,509,958,963,427,423,695,696,697,698,1053,216,581,582,583,1796,295,2008,477,478,448,479,415,102,689,691,1627,1666,2303,529,424,635,724,726,464,465,466,467,468,469,470,619,620,622,676,632,471,450,451,562,556,532,530,563,565,531,845,765,26,1570,1571,1572,1014,497,494,527,834,493,523,522,919,500,1685,503,1254,1093,1005,670,571,846,364,1386,1538,134,2148,701,703,23,705,331,155,704,41,304,30,40,248,511,512,513,514,714,2052,2053,2054,2055,2056,515,516,611,545,718,538,539,1997,2000,2001,612,2004,2006,2007,518,2185,2186,2540,520,521,265,541,542,543,544,1665,1994,1995,411,475,536,554,2289,1619,1276,1761,716,624,405,1002,1017,2539,789,615,614,646,652,2003,2100,659,1576,663,660,604,625,2405,677,678,1055,1057,679,1058,548,627,631,629,957,634,641,643,645,637,644,256,175,114,751,753,755,739,741,258,829,392,397,402,421,657,658,661,662,836,664,682,686,680,720,438,555,700,784,783,673,785,819,1056,715,687,260,702,712,710,1582,1583,1626,1722,2016,2021,2070,2169,480,731,736,732,733,943,759,1733,735,1064,1059,758,1250,804,944,918,737,738,767,2461,910,1577,938,939,778,883,1009,909,1019,1259,2050,889,1183,1202,1236,1238,1247,1467,740,742,1643,1246,814,1297,1298,831,2113,1299,749,750,752,754,953,1060,1179,1180,1181,782,779,796,2544,798,800,1076,1080,1603,1675,1051,133,812,1045,1759,1749,1773,2049,816,817,818,824,977,821,822,823,985,986,950,825,826,827,828,830,838,839,840,841,837,842,844,847,854,855,858,863,864,865,866,869,870,848,849,850,878,851,852,853,856,857,859,860,861,862,893,894,895,896,884,885,867,868,879,871,872,992,2203,2206,917,881,882,805,901,2028,1052,2256,915,2037,1590,1553,1754,1945,1981,2067,1991,1988,2027,920,923,925,926,949,921,922,940,931,987,932,929,930,962,933,942,954,1046,934,935,936,945,946,947,948,937,1560,1587,1348,1011,1012,1016,951,1184,1142,1040,973,1033,1044,1086,955,974,975,1042,1015,968,965,988,989,1593,978,990,1600,993,994,979,980,996,982,1010,1274,997,995,1030,984,1006,927,1001,959,941,1007,1008,924,1065,1078,1079,956,1041,1708,1712,1713,429,526,552,553,1013,897,2571,2563,2304,2570,1400,1100,279,2554,983,2299,1409,976,966,1031,1307,1605,1604,1257,557,1296,1325,1038,1267,1024,1025,1615,558,1295,1631,1309,1578,1614,559,1084,1085,1483,1620,255,1621,1622,1592,1623,1606,1607,1608,1609,1610,1028,1029,2247,2248,1169,1070,1071,1072,1704,1705,1349,1706,1308,1067,37,621,2406,425,2408,410,492,491,748,743,653,1588,1068,1069,1073,1094,1095,1096,1097,1098,1099,1115,1131,1132,1300,1301,1219,1304,1110,1111,1158,1255,1343,1233,1546,1387,1105,1133,1107,1672,1104,1113,1673,1674,1545,1103,1601,1135,609,603,606,916,1204,1207,1235,2033,1117,1148,1127,1128,1129,1130,1160,1125,1126,1161,1162,1112,1106,1143,1145,1136,1139,1178,1177,1175,1176,2177,1157,1263,1264,1265,1266,1118,1119,1120,1174,1108,1122,1326,1123,1485,1121,1329,1170,1171,1172,1406,1159,1256,1535,1537,1251,1302,1303,1116,1153,1154,1155,1156,1149,1150,1151,1152,1147,1245,1137,1138,1230,1140,1318,1319,1144,1146,1124,1163,1203,1357,1356,1978,483,313,1544,1895,2074,1403,1404,1986,1330,1346,1347,1194,1187,1193,1195,2362,2440,1199,2387,2472,1196,1197,2371,1288,1243,1210,1225,2292,2293,2296,2297,2357,1260,2335,2334,1205,2369,1277,1200,2462,2503,2504,1287,1221,1209,2306,1215,1312,1226,1220,1222,2341,2342,1224,1185,1231,1252,1364,1365,1310,1333,1278,1279,1280,1273,981,1286,1331,1289,2376,2568,1281,1306,1271,1284,1351,1285,2375,2484,1268,1283,1369,1465,1269,1316,1360,1270,1275,1305,1533,1377,1313,1317,1372,1321,1322,1334,1335,1336,1337,1282,1405,1173,1637,1339,2178,2179,1628,1629,1630,1923,1924,1925,2572,2379,1667,2381,2026,1344,1370,1371,1441,1378,1374,1640,1487,1443,1445,1447,246,457,1027,243,1262,877,1725,2515,1388,1389,1390,1391,1228,1375,1402,1047,1429,1481,1594,1703,2333,1253,1411,1413,1415,1417,1419,1423,1425,1368,1020,482,1469,1088,2260,2261,1511,1517,1493,1495,1497,1499,1513,1519,1521,1523,1525,1527,1529,1531,1540,1539,2279,2280,2281,2230,913,912,2302,2505,1547,1548,1549,1550,2093,132,1950,1645,1646,1715,1989,1714,1716,1983,706,484,707,560,416,418,728,1242,1362,1217,1565,1573,1566,1567,1039,1568,2023,447,786,1350,618,549,341,685,2187,2236,2237,1581,1591,1616,1617,1584,833,1595,1642,2045,2084,1596,1597,1618,1602,445,476,1625,1647,1633,1634,2269,2316,2317,1598,1599,1676,1648,1649,1650,887,794,2398,2399,2400,1664,2397,2378,1668,1670,1669,2403,1821,1686,1687,1688,1689,1690,1691,1700,1702,1696,1701,1721,1707,1692,1693,1694,1718,1697,333,1709,1710,1711,540,1018,431,533,756,891,892,1719,1762,1763,1764,1054,2298,1760,1757,1758,1750,1751,1752,1779,1753,2044,1769,745,1772,1987,1951,744,799,1109,757,890,2010,2011,2012,2013,2014,2015,1768,1770,1771,2551,2114,1774,1776,2063,2064,2065,2066,1780,1793,1795,1902,1824,1827,1828,2567,1782,1919,1920,1921,1790,1805,1794,1823,1797,1798,1799,1801,1802,1819,2046,2061,2068,1800,1815,2060,1808,1809,1907,1918,1785,1784,1842,1836,1833,1786,1787,1843,1825,1826,1897,1832,1834,1835,1829,1830,1831,1837,1838,1848,1849,1898,1856,1851,1858,2104,2108,1855,2111,1867,1868,1869,1870,1871,2119,1865,1859,1862,2545,1896,1861,1864,2501,2107,1877,1878,2077,2088,1880,1881,1882,1883,1884,1927,1888,1926,1931,1930,2149,2227,1886,2071,2082,2115,2094,1875,2095,2270,2183,1901,2062,2543,2089,2265,1889,2087,2075,2086,1899,1900,1904,2058,2069,2076,2109,2110,2112,2166,2353,1893,1933,2072,2078,2294,2295,1905,1906,1811,1813,1840,1841,1839,1803,1791,1817,1818,1812,1810,1788,1814,1804,1928,1984,2101,2323,1863,1872,1934,2130,1932,2244,2283,2243,2287,1948,2284,2307,2425,2426,2427,2231,2232,2233,2234,2041,2042,1964,1551,1965,2355,2354,803,2043,1956,1957,1958,1966,1967,1968,1969,1976,2264,2207,2229,2384,2057,1953,1952,1063,1164,746,797,820,1959,1960,1961,1962,1977,2092,1970,1971,1972,1973,1974,1975,2326,2391,1982,2564,2080,1990,2522,1993,1996,1998,2038,2039,1559,580,613,2002,2048,2005,546,1558,1756,2009,2017,2018,2020,2019,2022,1437,1367,1435,1382,1381,1380,1741,1742,2032,1737,2257,2313,2047,1891,2051,2228,2059,2073,2081,2202,2085,2103,2090,2091,2096,2097,2098,2099,2105,2159,2205,2300,2301,2106,1852,1853,1854,1929,2518,2519,2520,2170,2171,2116,2117,2118,668,665,1463,666,667,2396,2123,2124,2125,2494,2164,2492,2136,2155,2156,2157,2506,2428,2135,2137,2222,2132,2488,2153,2128,2497,342,2498,2499,2221,2131,2490,2491,2133,2418,2419,2420,2421,2422,2423,2495,2138,2370,2140,2141,2142,2165,2224,2444,2144,2145,2146,2147,2325,2537,2150,2151,2152,2285,2286,2225,2158,2485,2249,2173,2161,2252,2253,2184,2189,2172,2251,2163,2195,2198,347,346,406,2245,2204,2552,2174,2250,1354,1353,1049,1352,1727,2180,2181,2182,2193,2240,2241,2194,2216,628,519,404,776,815,1373,2476,969,2196,2197,2199,2200,2201,2213,2214,2215,2212,2288,2208,2209,2217,2218,2219,2523,2220,761,880,250,1491,420,2262,561,2336,2254,2162,2278,273,2263,2267,2268,2277,2271,2272,2273,2274,2318,2319,2320,2321,2322,2291,2290,2483,2541,2359,2372,1229,1249,1208,1223,2358,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2548,2308,2311,2312,2517,2481,2327,2328,2329,2330,2331,2332,441,442,1034,2305,1211,1212,1290,2309,2310,2315,2340,2343,2344,2337,2338,2339,2373,2345,2346,2348,2349,2350,2356,2282,2360,2361,2477,2478,2479,2480,2364,2365,2367,2368,2401,2402,2417,2559,2560,2411,2412,2415,2374,2475,2377,2024,2025,1198,2385,2388,2392,2393,1766,1992,2424,1655,1035,444,443,2407,2409,2410,2404,2413,2414,2416,2139,2143,2553,2154,2429,2430,2436,2437,2438,2439,2433,2432,2431,2486,2487,1755,1728,252,2442,2443,2120,2474,2192,2458,2459,2460,2546,2465,2466,2467,2468,2496,2489,2493,2500,2255,2502,2525,2527,2530,2531,2569,2524,2573,2574,2575,2576,2577,2578,2579,2580,2528,2529,2532,2533,2534,2535,2536,2555,2585,2589,2596,2561,2562,2565,2547,2550,2558,2556,2557,2581,2582,2583,2584,2586,2587,2588,2594,2590,2592,2593,2591,2595) AND  p.queued IN (0,1,2)  AND  t.approved IN (1,0,-1)  AND  t.topic_archive_status IN (0,3)  AND ( p.pid IN (0,171531,172092,172424,172066,172046,171902,172443,172752,174298,174104,174097,172866,171789,171770,171532,171543,171530,171528,171544,171545,171768,171553,171550,171548,174299,174303,179777,179892,179750,179743,179269,179902,181034,181175,181174,181139,181101,179268,178771,176096,175647,175132,174306,176816,176833,178300,177879,177864,177697,171521,171518,153513,154618,153459,153435,149488,154936,155868,160852,158917,158832,158650,148605,148312,139261,139252,139246,139237,142128,142197,147272,144798,143640,142213,161246,161376,169429,170773,168074,166817,166813,171107,171111,171506,171480,171419,171116,166603,166600,164032,162412,162276,161858,164165,164181,166521,166042,165679,164665,181925,181945,377653,377670,377621,377620,377609,377683,377828,378409,378228,378227,378018,377441,377281,375615,375493,375446,375191,376023,376505,377275,377188,377169,376726,378438,378465,381369,381928,381224,380743,380650,383862,384662,387945,387780,384940,384779,379993,379837,379409,379379,378959,378762,379414,379421,379779,379736,379448,379439,367492,366864,273695,274067,272792,247747,247152,282596,282651,291371,291358,290355,289937,246851,246240,197591,197587,197214,196929,197709,232270,246238,246137,245817,245689,291375,291377,343067,343076,342830,342821,342811,343089,343136,349082,347829,344955,344781,342783,342778,292851,292339,291382,291380,293173,295814,342745,342735,340321,298927,390435) ) AND t.state != 'link' AND p.author_id = 718 ORDER BY post_date desc LIMIT 0,201

 

 

 

 

Никаких дополнительных модификаций и хуков не устанавливал еще с того года. Проблема появилась внезапно.

 

Сами по себе ошибки появляются не постоянно, а через раз. Сначала думал, что DDOS, т.к. на форуме все действия стали совершаться вдвойне более медленно, чем обычно. Но техподдержка хостинга ответила, что никакой DDOS активности не обнаружено. Вместе с тем, сказали, что на index.php приходится большая нагрузка (там как раз форум и установлен).

 

Прошу помочь, кто чем может.

Ссылка на комментарий
Поделиться на других сайтах

Рекомендуемые сообщения

  • 0

WHERE t.forum_id IN (222,6,66,7,876,1698,1717,903,594,19,22,2351,380,20,8,15,433,386,432,428,79,210,228,21,550,592,671,711,781,907,991,1077,1201,1338,1489,1552,1613,1723,1767,1922,1949,2266,2469,2470,2471,2352,195,196,197,198,199,271,377,378,25,2324,266,537,27,35,262,29,56,53,158,159,274,499,32,150,86,318,1660,1661,1662,1663,654,534,655,240,138,647,48,51,299,232,55,57,54,186,339,412,236,164,357,353,300,50,301,302,303,376,286,278,285,282,902,1234,1383,1384,1385,1744,280,283,284,157,1359,1345,1340,1043,510,446,1561,2394,1291,1292,1293,1294,1323,1324,201,1775,96,97,413,414,1102,223,103,407,1575,105,294,231,104,2235,361,436,605,116,108,2134,109,205,106,131,1087,126,1214,964,1021,1022,1026,1589,127,1935,1937,1942,1941,1938,1940,1939,1936,1632,2314,810,2441,264,2464,683,806,2542,2435,135,908,154,1822,1736,220,212,168,2,747,1543,1168,1167,1166,272,1792,2566,1980,1216,1261,1624,1541,1542,1376,1944,1657,1658,1461,813,717,489,648,1563,1564,1569,214,215,297,2079,1652,1653,1654,166,167,329,176,326,288,381,360,182,183,330,336,384,187,188,189,281,191,192,193,194,200,208,267,268,269,257,202,2122,2126,2188,2127,2129,160,221,672,970,390,349,382,139,101,123,224,277,87,327,16,389,275,305,165,80,162,163,185,289,290,291,292,293,551,566,567,801,952,1061,1244,1427,2223,2434,2538,247,320,244,254,308,239,368,967,843,681,227,472,473,535,888,1366,128,2121,298,1777,2238,2029,2030,1743,2031,1963,1955,1738,1739,1740,276,385,373,306,307,374,356,961,1361,152,153,111,112,211,219,344,226,230,296,98,190,334,366,309,310,311,319,911,1979,422,321,322,323,324,325,332,633,1379,1720,335,358,337,338,351,340,2167,2242,2168,971,972,354,359,367,1000,1082,2239,1850,95,115,1186,2521,363,730,107,5,14,13,375,36,47,58,28,38,650,649,426,651,693,449,498,395,699,835,623,626,91,369,370,371,372,1659,169,207,596,383,213,217,218,348,2463,352,462,598,393,394,400,401,437,601,408,517,409,1399,487,564,777,1066,1258,507,508,509,958,963,427,423,695,696,697,698,1053,216,581,582,583,1796,295,2008,477,478,448,479,415,102,689,691,1627,1666,2303,529,424,635,724,726,464,465,466,467,468,469,470,619,620,622,676,632,471,450,451,562,556,532,530,563,565,531,845,765,26,1570,1571,1572,1014,497,494,527,834,493,523,522,919,500,1685,503,1254,1093,1005,670,571,846,364,1386,1538,134,2148,701,703,23,705,331,155,704,41,304,30,40,248,511,512,513,514,714,2052,2053,2054,2055,2056,515,516,611,545,718,538,539,1997,2000,2001,612,2004,2006,2007,518,2185,2186,2540,520,521,265,541,542,543,544,1665,1994,1995,411,475,536,554,2289,1619,1276,1761,716,624,405,1002,1017,2539,789,615,614,646,652,2003,2100,659,1576,663,660,604,625,2405,677,678,1055,1057,679,1058,548,627,631,629,957,634,641,643,645,637,644,256,175,114,751,753,755,739,741,258,829,392,397,402,421,657,658,661,662,836,664,682,686,680,720,438,555,700,784,783,673,785,819,1056,715,687,260,702,712,710,1582,1583,1626,1722,2016,2021,2070,2169,480,731,736,732,733,943,759,1733,735,1064,1059,758,1250,804,944,918,737,738,767,2461,910,1577,938,939,778,883,1009,909,1019,1259,2050,889,1183,1202,1236,1238,1247,1467,740,742,1643,1246,814,1297,1298,831,2113,1299,749,750,752,754,953,1060,1179,1180,1181,782,779,796,2544,798,800,1076,1080,1603,1675,1051,133,812,1045,1759,1749,1773,2049,816,817,818,824,977,821,822,823,985,986,950,825,826,827,828,830,838,839,840,841,837,842,844,847,854,855,858,863,864,865,866,869,870,848,849,850,878,851,852,853,856,857,859,860,861,862,893,894,895,896,884,885,867,868,879,871,872,992,2203,2206,917,881,882,805,901,2028,1052,2256,915,2037,1590,1553,1754,1945,1981,2067,1991,1988,2027,920,923,925,926,949,921,922,940,931,987,932,929,930,962,933,942,954,1046,934,935,936,945,946,947,948,937,1560,1587,1348,1011,1012,1016,951,1184,1142,1040,973,1033,1044,1086,955,974,975,1042,1015,968,965,988,989,1593,978,990,1600,993,994,979,980,996,982,1010,1274,997,995,1030,984,1006,927,1001,959,941,1007,1008,924,1065,1078,1079,956,1041,1708,1712,1713,429,526,552,553,1013,897,2571,2563,2304,2570,1400,1100,279,2554,983,2299,1409,976,966,1031,1307,1605,1604,1257,557,1296,1325,1038,1267,1024,1025,1615,558,1295,1631,1309,1578,1614,559,1084,1085,1483,1620,255,1621,1622,1592,1623,1606,1607,1608,1609,1610,1028,1029,2247,2248,1169,1070,1071,1072,1704,1705,1349,1706,1308,1067,37,621,2406,425,2408,410,492,491,748,743,653,1588,1068,1069,1073,1094,1095,1096,1097,1098,1099,1115,1131,1132,1300,1301,1219,1304,1110,1111,1158,1255,1343,1233,1546,1387,1105,1133,1107,1672,1104,1113,1673,1674,1545,1103,1601,1135,609,603,606,916,1204,1207,1235,2033,1117,1148,1127,1128,1129,1130,1160,1125,1126,1161,1162,1112,1106,1143,1145,1136,1139,1178,1177,1175,1176,2177,1157,1263,1264,1265,1266,1118,1119,1120,1174,1108,1122,1326,1123,1485,1121,1329,1170,1171,1172,1406,1159,1256,1535,1537,1251,1302,1303,1116,1153,1154,1155,1156,1149,1150,1151,1152,1147,1245,1137,1138,1230,1140,1318,1319,1144,1146,1124,1163,1203,1357,1356,1978,483,313,1544,1895,2074,1403,1404,1986,1330,1346,1347,1194,1187,1193,1195,2362,2440,1199,2387,2472,1196,1197,2371,1288,1243,1210,1225,2292,2293,2296,2297,2357,1260,2335,2334,1205,2369,1277,1200,2462,2503,2504,1287,1221,1209,2306,1215,1312,1226,1220,1222,2341,2342,1224,1185,1231,1252,1364,1365,1310,1333,1278,1279,1280,1273,981,1286,1331,1289,2376,2568,1281,1306,1271,1284,1351,1285,2375,2484,1268,1283,1369,1465,1269,1316,1360,1270,1275,1305,1533,1377,1313,1317,1372,1321,1322,1334,1335,1336,1337,1282,1405,1173,1637,1339,2178,2179,1628,1629,1630,1923,1924,1925,2572,2379,1667,2381,2026,1344,1370,1371,1441,1378,1374,1640,1487,1443,1445,1447,246,457,1027,243,1262,877,1725,2515,1388,1389,1390,1391,1228,1375,1402,1047,1429,1481,1594,1703,2333,1253,1411,1413,1415,1417,1419,1423,1425,1368,1020,482,1469,1088,2260,2261,1511,1517,1493,1495,1497,1499,1513,1519,1521,1523,1525,1527,1529,1531,1540,1539,2279,2280,2281,2230,913,912,2302,2505,1547,1548,1549,1550,2093,132,1950,1645,1646,1715,1989,1714,1716,1983,706,484,707,560,416,418,728,1242,1362,1217,1565,1573,1566,1567,1039,1568,2023,447,786,1350,618,549,341,685,2187,2236,2237,1581,1591,1616,1617,1584,833,1595,1642,2045,2084,1596,1597,1618,1602,445,476,1625,1647,1633,1634,2269,2316,2317,1598,1599,1676,1648,1649,1650,887,794,2398,2399,2400,1664,2397,2378,1668,1670,1669,2403,1821,1686,1687,1688,1689,1690,1691,1700,1702,1696,1701,1721,1707,1692,1693,1694,1718,1697,333,1709,1710,1711,540,1018,431,533,756,891,892,1719,1762,1763,1764,1054,2298,1760,1757,1758,1750,1751,1752,1779,1753,2044,1769,745,1772,1987,1951,744,799,1109,757,890,2010,2011,2012,2013,2014,2015,1768,1770,1771,2551,2114,1774,1776,2063,2064,2065,2066,1780,1793,1795,1902,1824,1827,1828,2567,1782,1919,1920,1921,1790,1805,1794,1823,1797,1798,1799,1801,1802,1819,2046,2061,2068,1800,1815,2060,1808,1809,1907,1918,1785,1784,1842,1836,1833,1786,1787,1843,1825,1826,1897,1832,1834,1835,1829,1830,1831,1837,1838,1848,1849,1898,1856,1851,1858,2104,2108,1855,2111,1867,1868,1869,1870,1871,2119,1865,1859,1862,2545,1896,1861,1864,2501,2107,1877,1878,2077,2088,1880,1881,1882,1883,1884,1927,1888,1926,1931,1930,2149,2227,1886,2071,2082,2115,2094,1875,2095,2270,2183,1901,2062,2543,2089,2265,1889,2087,2075,2086,1899,1900,1904,2058,2069,2076,2109,2110,2112,2166,2353,1893,1933,2072,2078,2294,2295,1905,1906,1811,1813,1840,1841,1839,1803,1791,1817,1818,1812,1810,1788,1814,1804,1928,1984,2101,2323,1863,1872,1934,2130,1932,2244,2283,2243,2287,1948,2284,2307,2425,2426,2427,2231,2232,2233,2234,2041,2042,1964,1551,1965,2355,2354,803,2043,1956,1957,1958,1966,1967,1968,1969,1976,2264,2207,2229,2384,2057,1953,1952,1063,1164,746,797,820,1959,1960,1961,1962,1977,2092,1970,1971,1972,1973,1974,1975,2326,2391,1982,2564,2080,1990,2522,1993,1996,1998,2038,2039,1559,580,613,2002,2048,2005,546,1558,1756,2009,2017,2018,2020,2019,2022,1437,1367,1435,1382,1381,1380,1741,1742,2032,1737,2257,2313,2047,1891,2051,2228,2059,2073,2081,2202,2085,2103,2090,2091,2096,2097,2098,2099,2105,2159,2205,2300,2301,2106,1852,1853,1854,1929,2518,2519,2520,2170,2171,2116,2117,2118,668,665,1463,666,667,2396,2123,2124,2125,2494,2164,2492,2136,2155,2156,2157,2506,2428,2135,2137,2222,2132,2488,2153,2128,2497,342,2498,2499,2221,2131,2490,2491,2133,2418,2419,2420,2421,2422,2423,2495,2138,2370,2140,2141,2142,2165,2224,2444,2144,2145,2146,2147,2325,2537,2150,2151,2152,2285,2286,2225,2158,2485,2249,2173,2161,2252,2253,2184,2189,2172,2251,2163,2195,2198,347,346,406,2245,2204,2552,2174,2250,1354,1353,1049,1352,1727,2180,2181,2182,2193,2240,2241,2194,2216,628,519,404,776,815,1373,2476,969,2196,2197,2199,2200,2201,2213,2214,2215,2212,2288,2208,2209,2217,2218,2219,2523,2220,761,880,250,1491,420,2262,561,2336,2254,2162,2278,273,2263,2267,2268,2277,2271,2272,2273,2274,2318,2319,2320,2321,2322,2291,2290,2483,2541,2359,2372,1229,1249,1208,1223,2358,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2548,2308,2311,2312,2517,2481,2327,2328,2329,2330,2331,2332,441,442,1034,2305,1211,1212,1290,2309,2310,2315,2340,2343,2344,2337,2338,2339,2373,2345,2346,2348,2349,2350,2356,2282,2360,2361,2477,2478,2479,2480,2364,2365,2367,2368,2401,2402,2417,2559,2560,2411,2412,2415,2374,2475,2377,2024,2025,1198,2385,2388,2392,2393,1766,1992,2424,1655,1035,444,443,2407,2409,2410,2404,2413,2414,2416,2139,2143,2553,2154,2429,2430,2436,2437,2438,2439,2433,2432,2431,2486,2487,1755,1728,252,2442,2443,2120,2474,2192,2458,2459,2460,2546,2465,2466,2467,2468,2496,2489,2493,2500,2255,2502,2525,2527,2530,2531,2569,2524,2573,2574,2575,2576,2577,2578,2579,2580,2528,2529,2532,2533,2534,2535,2536,2555,2585,2589,2596,2561,2562,2565,2547,2550,2558,2556,2557,2581,2582,2583,2584,2586,2587,2588,2594,2590,2592,2593,2591,2595)

В самом деле 2057 подфорумов? Мне странно, что этот мастодонт вообще ползает даже под одиноким посетителем...

Ссылка на комментарий
Поделиться на других сайтах

  • 0

В ваших данных нет ничего об ошибке. Возьмите файл /cache/sql_errors_дата.cgi с вашего форума на дату проявления ошибки и скажите оттуда ответ sql-сервера.

Ссылка на комментарий
Поделиться на других сайтах

  • 0

Всем привет. Спрошу тут.

 

Присоздании подфорума вылетает ошибка:
 

There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again. 

You can try to refresh the page by clicking here

При нажатии кнопки назад получаем это: 

 

 

 

Системная ошибка

[#2100] Проблема безопасности - пожалуйста вернитесь назад обновите форму и попытайтесь отправить ее снова.

 

 

Базу прочекали - все ок. Загрузка сервера 35%.

 

Пробовал создавать в других подфорумах - тоже самое. 

Ссылка на комментарий
Поделиться на других сайтах

  • 0

В ваших данных нет ничего об ошибке. Возьмите файл /cache/sql_errors_дата.cgi с вашего форума на дату проявления ошибки и скажите оттуда ответ sql-сервера.

Ссылка на комментарий
Поделиться на других сайтах

  • 0

 Date: Wed, 09 Sep 2015 08:29:55 +0000
 Error: 2013 - Lost connection to MySQL server during query
 mySQL query error: UPDATE ibf_sessions SET search_thread_id=0,search_thread_time=0 WHERE id='ded7953fac65e759c95384e55e91b60b'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Wed, 09 Sep 2015 08:31:34 +0000
 Error: 144 - Table './c1bmwclub/ibf_search_keywords' is marked as crashed and last (automatic?) repair failed
 mySQL query error: INSERT INTO ibf_search_keywords (keyword, count) VALUES ('тойота 2,5 ремонт ваноса', 1) ON DUPLICATE KEY UPDATE count = count + 1

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Wed, 09 Sep 2015 08:58:18 +0000
 Error: 1054 - Unknown column 'tag_mode' in 'field list'
 IP Address: 213.159.57.231 - /forum/admin/index.php?adsess=59bf743419a6604ca8348436ce87e0df&app=forums&&module=forums&section=forums&&do=donew&f=0&name=%D0%9D%D0%BE%D0%B2%D1%8B%D0%B9+%D1%84%D0%BE%D1%80%D1%83%D0%BC
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO ibf_forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`password`,`password_override`,`sort_key`,`sort_order`,`prune`,`topicfilter`,`preview_posts`,`allow_poll`,`allow_pollbump`,`forum_allow_rating`,`inc_postcount`,`parent_id`,`sub_can_post`,`redirect_on`,`redirect_hits`,`redirect_url`,`notify_modq_emails`,`permission_showtopic`,`min_posts_post`,`min_posts_view`,`can_view_others`,`hide_last_info`,`disable_sharelinks`,`tag_predefined`,`forums_bitoptions`,`permission_custom_error`,`ipseo_priority`,`viglink`,`default_prefix`,`default_tags`,`require_prefix`,`tag_mode`,`show_prefix_in_desc`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('IT','it','',1,0,'','','last_post','Z-A',100,'all',0,1,0,0,1,8,1,0,0,'',0,0,0,0,1,0,0,'',0,'','',0,'','',0,'inherit',0,121,0,0,0,0,'')

Видим 3 разные ошибки, остальное повторяется.

1. Сервер базы данных перезагрузился, завис или оборвал соединение по таймауту во время обновления таблицы сессий.

2. Таблица ibf_search_keywords повреждена. Нужно попробовать восстановить, если не выйдет - пересоздать. 

3. В таблице ibf_forums нет поля tag_mode , которое нужно какому-то хуку. Эта та самая ошибка, которая появляется при отправке. Лечение - отключить хук или добавить поле в таблицу. Данные для добавления поля есть в дистрибутиве хука(в его xml-файле). Если это приложение, то изменения в бд там лежат в admin/applications_addon/ИМЯПРИЛОЖЕНИЯ/setup/install

 

Ссылка на комментарий
Поделиться на других сайтах

  • 0
 

Видим 3 разные ошибки, остальное повторяется.

1. Сервер базы данных перезагрузился, завис или оборвал соединение по таймауту во время обновления таблицы сессий.

2. Таблица ibf_search_keywords повреждена. Нужно попробовать восстановить, если не выйдет - пересоздать. 

3. В таблице ibf_forums нет поля tag_mode , которое нужно какому-то хуку. Эта та самая ошибка, которая появляется при отправке. Лечение - отключить хук или добавить поле в таблицу. Данные для добавления поля есть в дистрибутиве хука(в его xml-файле). Если это приложение, то изменения в бд там лежат в admin/applications_addon/ИМЯПРИЛОЖЕНИЯ/setup/install

 

 

 

Спасибо, будем работать над этим

Ссылка на комментарий
Поделиться на других сайтах

Присоединиться к обсуждению

Вы можете ответить сейчас, а зарегистрироваться позже. Если у вас уже есть аккаунт, войдите, чтобы ответить от своего имени.

Гость
Ответить на вопрос...

×   Вы вставили отформатированный текст.   Удалить форматирование

  Допустимо не более 75 смайлов.

×   Ваша ссылка была автоматически заменена на медиа-контент.   Отображать как ссылку

×   Ваши публикации восстановлены.   Очистить редактор

×   Вы не можете вставить изображения напрямую. Загрузите или вставьте изображения по ссылке.

Зарузка...
×
×
  • Создать...

Важная информация

Находясь на нашем сайте, вы соглашаетесь на использование файлов cookie, а также с нашим положением о конфиденциальности Политика конфиденциальности и пользовательским соглашением Условия использования.