Вход

Просмотр полной версии : FE ошибки при поиске


Игорь Ф.
09.11.2009, 14:05
Внезапно перестал нормально работать indexed_search

При попытке поиска во FE выдает следующие ошибки:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ...www/t3lib/class.t3lib_db.php on line 783

Warning: Cannot modify header information - headers already sent by (output started at ...www/t3lib/class.t3lib_db.php:1103) in .../www/typo3/sysext/cms/tslib/class.tslib_fe.php on line 2907

Плюс некие результаты поиска все-таки есть.

Поставил галочку в setupe ( [SYS][sqlDebug] = 1 )

Выдается:

caller t3lib_DB::exec_SELECTquery

ERROR The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

lastBuiltQuery SELECT tt_content.header AS tt_content_header,tt_content.bodytext AS tt_content_bodytext,tt_content.imagecaption AS tt_content_imagecaption,pages.uid,pages.title AS pages_title,pages.subtitle AS pages_subtitle,pages.keywords AS pages_keywords,pages.description AS pages_description
FROM tt_content,pages
WHERE
(tt_content.pid=pages.uid OR pages.pid=pages.uid) AND pages.uid IN (1815,1810,1819,1820,1838,1835,1833,1830,1837,1834 ,1832,1831,1829,1828,1827,1826,1825,1821,519,1719, 1720,1808,1647,399,1025,475,1712,1648,398,962,443, 899,900,411,410,408,407,409,984,1725,401,1679,1614 ,1343,979,791,754,755,402,488,1382,576,577,400,138 4,1385,976,977,978,750,752,751,749,493,397,405,919 ,1595,920,921,1151,1149,1150,629,1730,1731,1765,17 74,1773,1772,1771,1770,1769,1768,1767,1766,1764,17 82,1781,1780,1779,1778,1777,1776,1775,1763,1785,17 84,1783,1762,1788,1787,1786,1761,1791,1790,1789,17 60,1759,1341,1272,1218,1153,909,929,990,908,881,87 7,851,831,453,937,1726,1311,1425,1395,1306,1101,90 2,652,633,404,1795,1691,1671,880,887,649,1677,1654 ,1653,1643,1509,1497,1481,1399,1346,1339,1336,1327 ,1314,1312,1307,1297,1265,1259,1221,1201,1199,1188 ,1172,1164,1162,1143,1126,1119,1113,1108,1106,1086 ,1044,1043,1040,987,983,968,969,955,934,953,925,87 0,865,869,866,867,840,810,809,807,806,805,770,769, 768,767,745,730,729,728,726,721,720,719,707,695,70 0,685,684,677,674,672,659,671,661,660,658,617,611, 608,607,605,580,579,603,578,566,564,562,561,523,50 3,499,498,496,403,437,993,898,879,860,854,818,669, 824,835,823,822,816,817,602,445,778,779,777,742,74 0,739,724,679,467,569,474,571,473,471,466,468,715, 1645,1644,1602,1523,1498,1398,1403,1380,1377,1378, 1373,1298,1283,1195,1194,1175,1159,1158,1156,1132, 1127,1052,927,924,917,892,425,426,427,815,787,717, 714,581,504,436,850,1807,1709,1707,1703,1699,1694, 1625,1620,1611,1603,1585,1549,1513,1482,1362,1344, 1273,1249,1184,1129,1000,992,991,985,975,942,940,9 39,931,888,885,876,895,1806,1805,1797,567,1793,172 7,1716,1717,1711,1700,1697,1696,1693,1676,1674,166 8,1664,1650,1649,1623,1621,1618,1616,1597,1596,159 3,1588,1583,1577,1557,1556,1553,1543,1540,1534,153 2,1528,1524,1512,1511,1503,1499,1495,1494,1492,149 0,1487,911,1480,1452,1451,1450,1446,1445,1444,1443 ,1437,1438,1432,1428,1426,1423,1422,1421,1417,1415 ,1414,1410,1409,1397,1393,1394,1392,1391,1390,1387 ,1383,1381,1379,1374,1372,1371,1370,1369,1367,1363 ,1358,1354,1356,1355,1353,1352,1351,1350,1342,1348 ,1332,1333,1335,1334,1330,1325,1321,1313,1303,1293 ,1292,1286,1282,1281,1278,1274,1271,1269,1264,1261 ,1257,1256,1254,1245,1243,1240,1238,1237,1229,1223 ,1217,1216,1214,1212,1211,1198,1193,1186,1182,1181 ,1178,1177,1179,1180,1173,1170,1169,1168,1157,1155 ,1147,1152,1148,1141,1140,1138,1137,1136,1135,1134 ,1131,1130,556,1121,1112,1111,1107,1104,1102,1095, 1079,1073,1072,1068,1067,1062,1047,1046,1041,1036, 1033,1028,1024,1023,1021,1020,1019,1017,972,960,95 7,948,947,913,912,906,905,862,863,856,857,855,951, 449,1802,1800,1796,1714,1705,1702,1690,1688,1684,1 683,1682,1681,1680,1672,1656,1651,1646,1632,1604,1 518,1364,1258,1167,1166,1063,884,836,830,829,820,8 19,803,802,804,801,744,644,1798,1794,1792,1728,171 3,1710,1706,1704,1692,1689,1686,1675,1669,1663,166 2,1657,1635,1631,1630,1627,1613,1612,1605,1586,158 4,1578,1555,1552,1551,1550,1548,1547,1545,1546,154 2,1541,1539,1538,1537,1536,1535,1531,1530,1529,152 6,1525,1521,1520,1519,1517,1515,1514,1510,1508,150 7,1505,1502,1501,1500,1496,1493,1491,1489,1488,148 6,1484,1483,1463,1441,1436,1434,1435,1433,1431,143 0,1429,1424,1427,1420,1419,1413,1412,1411,1408,140 7,1406,1400,1396,1389,1388,1386,1376,1375,1368,136 6,1365,1360,1359,1361,1349,1347,1340,1337,1329,131 5,1302,1309,1310,1299,1294,1296,1295,1291,1284,128 0,1277,1276,1275,1270,1262,1260,1255,1253,1252,125 1,1250,1248,1247,1242,1241,1239,1236,1234,1235,123 0,1228,1225,1226,1222,1219,1215,1213,1205,1202,120 0,1197,1196,1192,1191,1187,1183,1176,1174,1171,116 5,1161,1163,1160,1154,1146,1145,1144,1142,1125,113 9,1124,1120,1118,1117,1116,1115,1114,1110,1098,109 0,1087,1066,1084,1065,1070,1059,1058,1053,1042,103 9,997,998,1001,999,1002,1003,1004,1005,1006,1007,1 008,1009,1010,1011,1012,1013,1014,1015,1016,1038,1 037,1035,1034,1030,1027,1031,1026,1022,1018,995,99 6,994,889,988,989,651,746,785,784,741,732,731,699, 692,638,635,639,636,634,632,630,631,570,524,513,66 2,928,910,894,858,853,821,788,786,780,743,725,697, 696,690,668,642,620,589,573,525,502,495,485,470,46 3,456,982,980,973,967,964,966,965,961,959,946,954, 945,944,943,936,933,932,916,926,923,903,922,915,91 4,907,893,891,890,871,874,864,882,872,839,843,844, 849,848,846,842,838,845,837,834,833,832,826,808,80 0,799,798,797,796,795,794,792,766,765,764,763,762, 761,759,758,757,756,753,738,737,736,735,723,718,71 1,716,709,708,710,693,691,687,686,682,681,680,678, 676,675,664,653,657,656,640,627,628,610,606,451,60 9,585,584,572,565,452,522,520,521,500,489,510,483, 482,481,479,477,476,462,643,497,450,1685,1670,1667 ,1665,1660,1659,1658,1655,1652,1628,971,878,852,85 9,574,647,1554,1544,1533,1522,1516,1464,1449,1448, 1442,1440,1418,1405,1404,1357,1401,1338,1328,1300, 1244,1231,1220,1190,1133,1128,1085,1061,1060,935,9 81,918,904,901,883,875,825,873,868,847,814,783,813 ,812,811,789,776,775,774,773,772,771,734,722,712,6 98,604,706,705,703,702,701,704,683,670,673,655,663 ,637,459,457,460,586,446,616,615,614,613,612,583,5 82,575,563,560,514,509,508,507,506,505,484,480,396 ,1288,1289,1290,747,1801,1701,1695,1589,1204,1203, 1266,1661,1622,1506,1504,1466,1460,1439,1402,952,1 345,1323,748,950,930,1322,1308,949,1287,1279,1267, 1227,1224,1185,1615,1799,1724,1718,1698,1673,1642, 1629,1626,1624,1206,454,1804,1803,1721,1687,1587,1 032,1527,1485,1465,1447,1454,1416,1029,464,713,641 ,465,1045,1069,1263,490,1582,440,694,1305,1304,130 1,1189,665,492,501,491,1207,1208,1209,1210,395,526 ,532,533,534,689,535,461,546,727,559,568,938,688,5 58,557,599,536,537,551,554,555,1091,1092,538,431,5 39,540,541,542,543,430,545,442,544,429,1122,1123,1 232,394,1246,1579,1580,1581,1076,1080,1077,1057,10 75,1081,1049,1050,1055,1105,1082,1083,1088,1089,10 99,1103,1078,1074,1054,1056,1051,1064,1094,1096,10 97,1100,1591,1619,1678,1592,1634,515,1637,596,1633 ,1666,1316,588,587,1320,1319,595,618,1318,593,592, 594,1638,1639,1640,518,1636,597,1641,958,598,444,9 70,469,941,1453,782,781,1233,393,392,391,390)
AND pages.doktype in (1,2,5,7)
AND pages.no_search=0 AND tt_content.deleted=0 AND tt_content.t3ver_state!=1 AND tt_content.hidden=0 AND (tt_content.starttime<=1257760053) AND (tt_content.endtime=0 OR tt_content.endtime>1257760053) AND (tt_content.fe_group='' OR tt_content.fe_group IS NULL OR tt_content.fe_group='0' OR (tt_content.fe_group LIKE '%,0,%' OR tt_content.fe_group LIKE '0,%' OR tt_content.fe_group LIKE '%,0' OR tt_content.fe_group='0') OR (tt_content.fe_group LIKE '%,-1,%' OR tt_content.fe_group LIKE '-1,%' OR tt_content.fe_group LIKE '%,-1' OR tt_content.fe_group='-1')) AND pages.deleted=0 AND pages.t3ver_state!=1 AND pages.hidden=0 AND (pages.starttime<=1257760053) AND (pages.endtime=0 OR pages.endtime>1257760053) AND (pages.fe_group='' OR pages.fe_group IS NULL OR pages.fe_group='0' OR (pages.fe_group LIKE '%,0,%' OR pages.fe_group LIKE '0,%' OR pages.fe_group LIKE '%,0' OR pages.fe_group='0') OR (pages.fe_group LIKE '%,-1,%' OR pages.fe_group LIKE '-1,%' OR pages.fe_group LIKE '%,-1' OR pages.fe_group='-1')) AND tt_content.sys_language_uid = 0 AND ((tt_content.header LIKE '%Петров%' OR tt_content.bodytext LIKE '%Петров%' OR tt_content.imagecaption LIKE '%Петров%'))
GROUP BY pages.uid

debug_backtrace require // include // tspagegen::rendercontent // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->template // tslib_cobj->cobjgetsingle // tslib_cobj->content // tslib_cobj->cobjgetsingle // tslib_cobj->cobjgetsingle // tslib_cobj->casefunc // tslib_cobj->cobjgetsingle // tslib_cobj->cobj_array // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->searchresult // tslib_search->count_query // t3lib_db->exec_selectquery // t3lib_db->debug

Вообще не понимаю, что с этим делать...
Недавно стал активно использовать tt_news, может как-то с ним связано.

Посмотрел куда ссылаются ошибки в исходниках:
В class.t3lib_db.php:
781: function sql_num_rows($res) {
782: $this->debug_check_recordset($res);
783: return mysql_num_rows($res);

В class.tslib_fe.php
2902: function processOutput() {
2903:
2904: // Set header for charset-encoding unless disabled
2905: if (!$this->config['config']['disableCharsetHeader']) {
2906: $headLine = 'Content-Type:text/html;charset='.trim($this->metaCharset);
2907: header($headLine);
...

Честно сказать, не понял, что это вообще может быть...

Pavel Antonov
09.11.2009, 15:24
В ошибе написано:
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay


Подозреваю что это из за огромного IN

Поставьте в конфиге mysql соответствующие параметры... попробуйте.

Игорь Ф.
09.11.2009, 22:38
А где находится конфиг mysql?
Дело в том, что я никогда с mysql не заморачивался.
Зашел в phpMyAdmin, повыполнял запросы в окне SQL-запрос(ы), никакого эффекта. Можете помочь?