[問題]無法刪除會員以及其發表的文章

phpBB Installation & Usage Support
phpBB 3 安裝於各類型作業平台之問題討論;外掛問題,請到相關版面依發問格式發表!
(發表文章請按照公告格式發表,違者砍文)

版主: 版主管理群

版面規則
本區是討論關於 phpBB 3.0.X 架設安裝上的問題,只要有安裝任何外掛,請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表,違者砍文)
主題已鎖定
kerise
星球公民
星球公民
文章: 32
註冊時間: 2004-08-18 23:58

[問題]無法刪除會員以及其發表的文章

文章 kerise »

●架設主機作業系統:Windows 2003 Server sp2
●快速架站程式:無
●免費空間連結:無
●您的上網方式:Hinet ADSL 10M
●您安裝的程式:Apache2.2 + php 5.2.3 + MySql 5.0.37
●您的 phpBB3 版本:3.0.4
●您的 phpBB3 使用風格:subsilver2
●您的 domain(網域名稱) :www.acsl.tw
●您的 phpBB3 連結網址: http://www.acsl.tw/phpBB3/index.php

請教各位大大,小弟的網站最近多了一堆莫名的會員,還發表了一堆廣告回應文章
發現後我欲刪除會員同時刪除所發表的文章可是出現下列錯誤訊息,煩請各位大大
教導以及幫忙,謝謝!

錯誤訊息:
一般性錯誤
SQL ERROR [ mysqli ]

Incorrect key file for table '.\phpbb3test\phpbb3test_posts.MYI'; try to repair it [126]

SQL

DELETE FROM phpbb3test_posts WHERE post_id IN ('417', '418', '420', '434', '454', '487', '488', '491', '492', '493', '495', '496', '497', '499', '500', '501', '502', '503', '507', '508', '510', '512', '513', '514', '515', '516', '518', '519', '520', '524', '525', '526', '529', '531', '532', '534', '537', '538', '539', '541', '545', '548', '551', '554', '556', '559', '566', '567', '568', '569', '571', '572', '573', '574', '575', '576', '577', '578', '579', '581', '582', '583', '584', '585', '586', '587', '588', '589', '590', '592', '593', '594', '595', '596', '597', '598', '599', '600', '601', '602', '603', '604', '606', '607', '608', '609', '610', '611', '612', '613', '614', '615', '616', '617', '618', '619', '620', '621', '622', '623', '624', '625', '626', '627', '628', '630', '631', '632', '633', '634', '635', '636', '637', '639', '640', '642', '643', '644', '645', '646', '647', '648', '649', '650', '651', '652', '653', '654', '655', '656', '657', '658', '659', '660', '661', '662', '663', '664', '665', '666', '667', '668', '669', '670', '671', '672', '673', '674', '675', '676', '677', '679', '680', '681', '682', '683', '684', '685', '686', '687', '688', '689', '690', '691', '692', '694', '695', '696', '697', '698', '699', '700', '701', '702', '704', '705', '706', '707', '708', '709', '710', '711', '712', '713', '714', '715', '716', '717', '718', '720', '721', '722', '723', '724', '726', '727', '728', '729', '730', '731', '733', '735', '737', '738', '740', '741', '743', '744', '746', '747', '748', '750', '751', '752', '754', '756', '757', '758', '759', '760', '761', '763', '764', '766', '768', '770', '771', '772', '775', '776', '777', '779', '780', '781', '783', '784', '785', '787', '788', '789', '790', '792', '793', '795', '796', '799', '801', '803', '804', '807', '810', '812', '814', '815', '818', '820', '822', '824', '825', '827', '830', '833', '835', '838', '839', '841', '844', '846', '847', '849', '851', '852', '854', '856', '857', '860', '861', '863', '865', '866', '868', '870', '873', '875', '877', '880', '882', '883', '885', '887', '889', '891', '892', '894', '898', '899', '901', '902', '904', '906', '907', '910', '912', '914', '916', '917', '920', '923', '926', '929', '930', '932', '934', '935', '937', '939', '940', '942', '944', '945', '947', '948', '950', '951', '952', '953', '954', '955', '956', '957', '958', '959', '960', '961', '962', '963', '964', '965', '966', '967', '968', '970', '971', '972', '973', '974', '975', '976', '977', '978', '979', '980', '981', '982', '983', '984', '985', '986', '987', '989', '990', '991', '993', '994', '995', '997', '998', '999', '1001', '1002', '1003', '1004', '1005', '1006', '1007', '1008', '1009', '1010', '1011', '1012', '1014', '1015', '1016', '1019', '1020', '1022', '1023', '1024', '1025', '1026', '1029', '1030', '1031', '1032', '1033', '1034', '1036', '1037', '1038', '1040', '1042', '1044', '1045', '1046', '1047', '1048', '1049', '1050', '1051', '1052', '1053', '1054', '1056', '1058', '1059', '1060', '1061', '1062', '1063', '1064', '1065', '1066', '1067', '1068', '1070', '1071', '1072', '1073', '1074', '1075', '1076', '1077', '1079', '1080', '1090', '1114', '1115', '1116', '1149', '1150', '1151', '1152', '1153', '1154', '1156', '1157', '1158', '1159', '1160', '1162', '1164', '1165', '1166', '1167', '1168', '1169', '1170', '1171', '1172', '1173', '1175', '1177', '1178', '1179', '1180', '1181', '1183', '1185', '1187', '1188', '1189', '1190', '1191', '1192', '1193', '1195', '1196', '1197', '1198', '1199', '1200', '1202', '1204', '1205', '1206', '1207', '1208', '1209', '1210', '1211', '1213', '1214', '1215', '1216', '1217', '1218', '1219', '1220', '1221', '1222', '1223', '1224', '1225', '1226', '1227', '1228', '1229', '1230', '1231', '1233', '1234', '1235', '1236', '1237', '1239', '1240', '1241', '1242', '1243', '1244', '1245', '1247', '1248', '1249', '1250', '1251', '1252', '1253', '1254', '1255', '1257', '1258', '1259', '1260', '1261', '1262', '1263', '1264', '1265', '1266', '1267', '1269', '1270', '1271', '1272', '1273', '1275', '1276', '1277', '1278', '1279', '1280', '1282', '1283', '1284', '1285', '1286', '1287', '1289', '1290', '1291', '1293', '1294', '1315', '1328', '1333', '1335', '1336', '1339', '1342', '1346', '1348', '1352', '1355', '1358', '1361', '1363', '1366', '1370', '1373', '1375', '1378', '1379', '1381', '1382', '1385', '1386', '1388', '1389', '1391', '1394', '1395', '1399', '1401', '1402', '1405', '1408', '1412', '1413', '1414', '1416', '1419', '1420', '1422', '1425', '1427', '1463', '1464', '1465', '1468', '1470', '1472', '1476', '1481', '1514', '1517', '1519', '1520', '1522', '1524', '1527', '1528', '1529', '1531', '1532', '1534', '1536', '1537', '1538', '1539', '1540', '1541', '1543', '1558', '1567', '1569', '1570', '1571', '1572', '1574', '1575', '1576', '1577', '1578', '1580', '1581', '1582', '1583', '1588', '1589', '1590', '1599', '1601', '1602', '1634', '1635', '1636', '1637', '1638', '1639', '1642', '1644', '1645', '1646', '1648', '1649', '1650', '1651')

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_admin.php
LINE: 698
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_user.php
LINE: 486
CALL: delete_posts()

FILE: includes/acp/acp_users.php
LINE: 196
CALL: user_delete()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
以及單獨刪除會員的錯誤訊息:
一般性錯誤
SQL ERROR [ mysqli ]

Table '.\phpbb3test\phpbb3test_posts' is marked as crashed and should be repaired [145]

SQL

SELECT COUNT(post_id) as posts_in_queue FROM phpbb3test_posts WHERE poster_id = 1507 AND post_approved = 0

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_users.php
LINE: 899
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8532
註冊時間: 2004-04-30 01:54
來自: Taiwan

Re: [問題]無法刪除會員以及其發表的文章

文章 心靈捕手 »

建議您:
修復資料表.

參考連結:
http://wang5555.dnsfor.me/phpbb3/viewtopic.php?t=8572
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
主題已鎖定

回到「[3.0.x] 安裝與使用」