Помогите разобраться!!!

01-17-2011, 04:59 PM

Доброго времени суток помогите убрать ошибку, при массовом удалении пользывателей вроде начинает удалять но в один момент после вот таких операций

Удаление подписок Ок

Удаление события Ок

Удаление напоминания о событии Ок

Удаление своего аватара Ок

Удаление фотографий Ок

Удаление уровня доступа пользователя

потом вылазет вот такая ошибка!

Database error in vBulletin 3.8.5:

Invalid SQL:
DELETE FROM access WHERE userid IN(813,945,1259,793,1849,1446,1180,1771,1257,1633, 1192,1254,1535,1699,1167,1620,925,28,1212,1164,874 ,965,1788,1737,1370,1580,1218,1727,1298,1134,1227, 897,1630,1482,1225,1435,1083,1399,835,1594,1217,14 36,1707,1161,960,858,1417,86,1051,1659,1851,843,81 4,1859,1046,1409,1696,1292,809,1834,1055,990,516,6 63,1772,1205,1702,1404,1507,954,1252,1146,1176,156 4,1553,719,1327,675,1416,1143,1346,1129,1285,1159, 1264,1228,1664,1211,1175,790,610,1647,794,1100,690 ,703,1836,1578,777,425,1689,1107,939,583,1729,715, 1536,510,1289,1170,1268,1386,1222,596,1215,1411,12 73,626,1665,483,1149,1243,466,1328,456,1002,1151,8 57,1540,896,1261,467,1174,1543,1385,635,482,1588,1 440,1204,1631,880,959,693,1345,332,887,1336,1775,7 63,579,1457,1118,1708,749,1473,732,1499,1589,1539, 1085,1418,1755,1462,1036,1177,830,1786,1072,1740,1 079,890,992,1766,1063,1193,970,1598,963,1286,1704, 1467,1652,1265,1060,1371,829,862,969,1796,1080,818 ,1344,1130,1537,1197,1597,1725,1352,1881,1065,938, 738,1316,1048,1714,1281,995,1605,1861,1408,1082,12 00,445,1713,851,1743,439,1271,544,927,1392,1050,52 1,1774,1379,1040,1853,617,1554,1045,558,570,1420,3 51,1783,921,1350,1294,1444,1627,1579,742,629,1423, 1008,1805,1763,922,442,1110,1491,781,1303,1738,684 ,1745,1759,612,1651,1839,1269,606,306,1838,1648,58 1,1097,95,821,422,1520,258,1634,603,360,1187,697,1 764,251,509,443,489,861,604,1768,458,190,353,371,1 823,1353,1384,1278,1666,1096,1571,1173,1770,1625,1 027,1194,1454,1587,1576,936,1463,1402,985,1074,110 6,1645,1650,1016,1864,766,1510,1517,889,1581,1584, 1544,1874,1028,1739,1509,244,1033,237,501,56,950,1 201,173,1351,1196,1359,1144,1032,162,21,837,873,93 7,144,987,1795,1007,734,1653,202,926,227,205,1113, 1551,500,1422,1572,361,234,1717,1646,1474,1267,169 5,502,1538,1591,1869,1846,1356,1585,917,795,753,31 8,869,1162,1883,204,882,1505,27,1301,1641,376,1329 ,267,80,1697,497,1469,1841,1025,1891,99,103,1471,6 69,605,1415,194,214,437,1751,688,1749,1512,1308,14 27,1833,1325,1500,900,1121,1138,856,918,1131,1773, 1412,1661,1126,852,1021,1364,955,1078,831,1067,942 ,1765,863,1291,971,1223,1747,1293,1611,798,1604,10 47,977,924,1179,1014,893,1236,1103,1852,1518,1017, 836,1595,935,1541,1623,931,1052,953,1354,1636,1355 ,783,1022,1260,64,1655,1865,615,904,1757,1438,326, 386,261,1011,519,840,1071,842,607,181,418,1062,40, 1407,1453,454,1245,1654,414,507,619,1501,172,1637, 683,157,156,195,1684,957,1464,1372,780,1266,951,16 03,1492,72,98,1070,1549,94,352,998,1624,791,1667,9 83,1277,671,125,1152,499,867,1284,1730,212,102,256 ,105,46,390,67,1043,288,1761,1781,1224,1057,1498,1 828,1892,1307,49,978,1081,354,1406,1506,47,599,107 3,1230,1447,1475,485,1220,1456,598,1521,1671,188,1 249,1282,1677,681,1700,75,976,785,1790,779,1769,17 42,520,379,1863,1216,180,110,1855,292,1660,226,641 ,177,1873,158,152,1258,207,438,1434,988,1235,210,1 206,1490,853,387,239,192,1039,129,112,1586,1599,22 4,323,35,14,342,1426,43,1798,160,1887,1493,141,104 2,564,1358,163,403,586,291,1826,1670,183,303,143,1 003,405,81,1367,1442,1691,1703,1563,1452,1342,1349 ,1612,82,1792,1142,167,137,1116,1443,661,662,316,1 89,161,1472,649,154,1381,962,609,706,1428,866,828, 632,1157,243,691,994,1262,1698,1304,1414,1256,594, 705,253,1877,1596,1669,1618,85,996,1139,517,1632,1 066,273,276,1870,1421,222,1108,206,819,1186,1305,1 867,1340,211,18,1789,83,1601,1574,1888,820,460,461 ,1068,491,769,1814,26,430,1120,487,1466,435,429,14 95,100,1784,1398,940,304,465,470,634,293,1147,803, 1141,1253,302,1004,427,849,289,252,1545,168,179,13 48,1693,229,1679,184,1246,1676,1668,879,1154,1894, 1202,1705,712,1744,417,871,220,257,1450,1044,833,1 6,1019,1020,1397,1461,1609,1709,886,934,42,1178,17 78,812,666,108,972,1458,1577,259,1640,1338,1649,17 56,91,1123,468,33,624,1029,1638,1722,295,1559,495, 76,198,1728,1000,1394,1782,572,1557,881,74,1642,19 01,1879,1716,132,1117,1710,1845,407,1610,1169,865, 899,528,126,774,51,1343,106,280,658,1570,1405,1432 ,966,967,201,284,1326,1035,1153,131,834,989,1451,7 87,1776,116,1896,1694,590,471,166,949,941,1835,325 ,566,752,279,380,1424,309,1226,1376,825,961,37,157 5,464,526,1843,118,228,1459,958,263,79,12,70,1794, 1804,1390,980,1368,1361,1054,1104,1497,1736,1059,3 41,370,1024,1214,1199,930,1733,982,1590,631,1229,2 82,1280,1485,797,1489,1767,1419,1760,948,1425,1189 ,271,402,1481,1165,592,1856,687,1250,1061,522,1550 ,952,1158,1150,84,10,54,176,8,169,73);

MySQL Error : Table 'имя базы.access' doesn't exist
Error Number : 1146
Request Date : Monday, January 17th 2011 @ 04:51:35 AM
Error Date : Monday, January 17th 2011 @ 04:51:35 AM
Script : http://домен/forum/admincp/user.php?do=dopruneusers
Referrer : http://домен/forum/admincp/user.php?do=pruneusers
IP Address : 211,554,656,454
Username : Sound
Classname : vB_Database
MySQL Version : 5.0.91-community .

А когда удаляешь по одному то пишет вот такое:

Database error in vBulletin 3.8.5:

Invalid SQL:

DELETE FROM access
WHERE userid = 2367;

MySQL Error : Table 'имя базы.access' doesn't exist
Error Number : 1146
Request Date : Monday, January 17th 2011 @ 05:08:45 AM
Error Date : Monday, January 17th 2011 @ 05:08:45 AM
Script : http://домен/forum/admincp/user.php?do=kill
Referrer : http://домен/forum/admincp/user.php?do=remove&u=2367
IP Address : 79.155.29.55
Username : Sound
Classname : vB_Database
MySQL Version : 5.0.91-community

Помогите плз.

Да и забыл добавить, во втором случаи пользователь удаляется, а в первом нет!

01-17-2011, 06:47 PM

я за комнату # 54 для этой темы

01-17-2011, 07:16 PM

Quote:

Originally Posted by Klerek

MySQL Error : Table 'имя базы.access' doesn't exist

Отсутствует таблица access.
Выполните SQL-запрос:

Code:

CREATE TABLE access (
	userid INT UNSIGNED NOT NULL DEFAULT '0',
	forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY userid (userid, forumid)
);

01-17-2011, 10:06 PM

Klerek, http://vbsupport.ru/forum/misc.php?do=showrules#2.2.6

01-18-2011, 10:41 AM

Quote:

Originally Posted by AleX

Отсутствует таблица access.
Выполните SQL-запрос:

Code:

CREATE TABLE access (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY userid (userid, forumid)
);

Сделал этот запрос всё заработало спасибо.