Page 1 of 1

Search Error

Posted: Thu Feb 23, 2006 11:58 pm
by Tom_S
I just tried to do a search in the Quizzies support forum for "Moderator" and got this error:

Code: Select all

 
Could not delete old search id sessions

DEBUG MODE

SQL Error : 1034 Incorrect key file for table 'phpbb2_search_results'; try to repair it

DELETE FROM phpbb2_search_results WHERE session_id NOT IN ('0151e4bc3fabe33a4a374f74670dd6a4', '029c1bbd078e72f1298f5b712dd8a927', '036b67d8e07229a2e439d366acd1fdb4', '049bda42c0111b76dfdaf27cdcb033ef', '05b2c10bd8facc39b267aaa49f17df60', '09fa034c24ed272088e59cb58d48e6a4', '0bdcf74dbcda6fdf668931c532ab8c0e', '0cb433d284d3edf81554ea3616e7794b', '0cf7cbdc9c6b6a757838b3eb9dfbb067', '0d2acbb1c38e58326c74d997bc21d9ed', '0f633b0e90c3b0119ff48d3144c8ab43', '118f389fe4bf6e39fea935bca970e1aa', '13a86cfae12d0ed06f8f5fc8a95815e6', '17426e4f14c4faf2dca90ca0ea15bfd2', '179be0fb9b562b54cdfc7c2faae5dc61', '18499db5dbaf67f2c00a50f0e2cab25c', '1bc9dda34930f4c8d3f562cdc8476bc2', '1d709ca0438799fa24fc37be071439cf', '1d751254baf14765f5bda138da53acac', '1d92a578fc74ba03fa2f694b9b8ed550', '1e07ec9c9481a86faabffb7940b63226', '20e3d743ff34c89339e4f9904cbea30a', '243d7958479cfdd319f83d26c0d32635', '2658a5642848a3a7cc3341cf9708975d', '2889ebb63ac3931876d09765e545f033', '29e147c1aefb56a38ba55403082da175', '2d4edc2c7674b6fcc63287527803327d', '333e25b874cd66b115dbde4d7238d43b', '3384c1f87e26bb1e795a52e38a9a3f69', '34495b8314345e0d5b602882f2e96f6c', '3a3c46866d64f140afb563179e47f8ba', '3b1f02aaa4fa0debf8d5f8d9debf9f7f', '3d148da4d5ff92c75d6540a5edc4d63a', '418548836f95bb161c0f00d41b6d0ff6', '430ea91d79b0f220390a24734ffbe0c1', '43b01692b77999188352f43dda5b005f', '44c2dd9bcd86c431c3b3448feca590a8', '480c77233dfd5e1808893227a26dd539', '4847e7fa7d3a2dd86d5f4cbf570fbc13', '4939a1b84781541271b8ff50b3b04d18', '4ddb4f9a8b87699f46f59c6d240fec21', '4feb9de92fde5392efdd23a64f560bd2', '53384cef1d9cff2cdd84615a13f05d27', '56671ca7e1cba107e213e8641e727656', '57aa366d1a085e101132dd086233f883', '5983b109aa77aa1ff55d76cdd41202ae', '5a5a03bb5ed06052675a83cac4696695', '5cf7e1084110c34277b27bd3e80652ae', '5da5b67eff6f9944041d90a85e2ccde7', '5fe4d6a294ec4afe1871c6bd18c485ce', '61736faeaf74572dede90d87c89598da', '627c8d9bc49a3c7798e90436d5e4b2e7', '657de9918232ee55681978cbf98d30c4', '65c0d6f3b35c853dee5ac7fdd7566f84', '675b2bc209fd3593fb422ec0d88edcc1', '68cf4fdfdcddbd46d11ec4b6cacfbb2d', '6b35ed585b04602246e88469d117d013', '6d8d4bb12a0ff3f8e8ddea754f3eb15f', '7177d012b97180338d12fee86baeb143', '745a6c030d057282c1a46b76b22e547e', '7616c110cf81c96a8343c1a493702764', '76ce8bd11e56e4faca8d81221ed033d8', '76d3ec878113b7979ed08b8ca2639202', '76fea335fb6a4682ceba6eeb365d0176', '77d733d050944f1713f6b8d8274163f3', '7d8796c4c5058103e04d3c01da9f7495', '809ea631cd9934fd6a8b434a2915bfeb', '823e9f9c032e51f5145a7fe9ef74b387', '84e502edf50ade6348e067efee9544ea', '86306cd51082a12b9d386e1336cc511b', '88abd43ff19867e4623554d473036d54', '8a0aab534fa419c6894e96c50638d0af', '8d8a6025d7419245b1bd12d872a42dea', '8dc7985f748f0b1d6faa0135572fab2c', '8f190d834838b391e0dc6866c6b02129', '8f7925641deddf971f353a9a8042f013', '905f569951fac26d996128a3a4ef6c64', '91c0733b59d7e89be4163bf26e5a8c94', '92c233c053bd97b2cfc06320c778b93e', '9312081999f760921fa5a3ac2ae4980a', '95294ab89886d00ff27532e3d99c6010', '957523170c4c28d5df75c61ae9db114e', '95eee8fabfba5ded6b6b3de672776004', '978fff584e992c453b5157eb3a9c01ef', '9a7208587d2831c75c7c119647d1f470', '9d6b7cda4cdef846a4aacd68d6ffde3c', '9ef4d2da3b1ff92cd5b65039efb4920d', 'a0e20b795454fcd7f548744368c97f06', 'a0e82b8e1b1674aa966988edf72447a9', 'a150f8aa1778c691e94bc0302e4f1941', 'a1e557a3539679bec03b47953b1212a3', 'a1ec9930c680e1a48489368858068d4d', 'a5519a44c9c64fb11c99f22ffc650f2b', 'a599a5733d11342857315a9c90d4b2f1', 'a616bbd9abe6bb112dc4c1e1750e6eb0', 'a9ebe57c036d89a415598828a8d070f2', 'ad739e7c9af1372136516f1d81200586', 'adbcb86eb5f3178f78811489f7d78298', 'aee6dd4f728f292e97bbadafdc94cbf1', 'b18dcd6157ef657cfe1de22faf8d031e', 'b58a3f87268f01646057b590c0fc2ab4', 'ba630085ca45bcf4f26e30b9ea943268', 'bb9d7fdc12470e35d62bb0da99b193fd', 'be52de1dc2e926b8f4cbb186d257fa93', 'be98b52b38d514993c31aec01ca8be99', 'be9f5cc1732c3056c4c6a17334f147cc', 'c077b399ddc42ae736fc3321df398b6e', 'c4695e016e8ba72a7202df2f57cad13f', 'c5c8762e49806a66947d4daf7a2a2bfa', 'c91fbd0f1ed48901cdef00ee6c18c03f', 'cb7755aa9d89fdbd4b3c0ed519e021d4', 'cbeedc595a7260e657ec954f4ba971a4', 'cc2f4a6285f679afc2a8ad966ccfc055', 'cd37a16e0d929d3671b65d9c32b3096d', 'cdbba02b818ae60588d962af3ca481ca', 'cecf750b64bd5340073f427ea78cafde', 'cedbf2b7eb7805152df0f85f2f617939', 'cefb9c7d7820ef2600b077b504da494e', 'd0182d4003ca784d54ab84e1cf36136c', 'd14c53bde6718f8fcf885bde228b20c2', 'd20dbbb68bf06e268c794b9142d823f6', 'd329c9befac7d1f3e138b1038ed245a4', 'd32b69cbf5a396ccafd4f3531cbc95ad', 'd39c306e41efb5fd581165773fa7aa30', 'd3c4c81af8a3f95550d875a49b59d620', 'd5b7c2e40f5ebbfdfe4863bc63642319', 'd7d12ece4740a82a77e5a9b61dfb813b', 'd9ab673c73e720cd913fed0ec543e1b5', 'deb1a04fa4c0b35b47ba1663d25bc6d4', 'df3c34966c35163819dff84eb7187611', 'e08f906580b6b4673cc56306e2c805a6', 'e09fc98e5e9ebc28b84542215eb2ac69', 'e0a1edfbda73ddbc22538adf31722ceb', 'e0d695f8308618007ec655cabd90dcf8', 'e0f7b60d70aadcbc2c9098cb68067ab4', 'e1ed84f9a9012caece39b78a61a41581', 'e3800f0b80bd81329a08f9b72137f104', 'e8da723dc1635a503f8ae15914126f64', 'e9c834529c6f0b4d8050d65abe7728a5', 'eedd410f2a2f0465e87043649295531a', 'ef07e57f585a338ad2a7c951b19f862d', 'eff82cdfa45559baaf1bf812e8449844', 'f2d2eb2e332287ffa56de9c6aa85c2c8', 'f4c2c52c54f7199013c9e9d7da55dfba', 'f573df36a5485a22f6c0458869c5b12d', 'f5cad235c80668952f307a0c28d43fc3', 'f7ffada6f8ec0c8fadb5c21244ec3379', 'f84095acb4a44762f0998cf9e2782a8d', 'f8b049e3a4075c5cc5a4a3a2d9649dcb', 'f8f67fcddb05ebf4b2d7a1fd32867900', 'f9245327a8c0bede718d0e19abce94c5', 'f95481507471f72d0cb4e2cd6f011658', 'fa37d4ada83eb99970a1b33a138d7f8f', 'faa50b4a72224f38263ecfd24d7b4b91', 'fbe4d43ee6f3d24b9a10551b736e18f2', 'fe4c1de0013d420f0e7e9b9c5f04f508', 'fea95f50b8755c0778ccd6158f6ad24c')
 
Thought I would let you know.

Oh..my question for searching was "How do I assign a moderator since that option is in the ACP?"

Thanks,
Tom

Posted: Fri Feb 24, 2006 2:33 pm
by battye
This has been repaired.

In answer to your question, go to the ACP -> Quiz, and a few rows down, it will ask you to enter the USER ID's of those which you wish to make moderators :)

Remember to insert the ID (number) and not their username. This is quite a common error :)

Posted: Fri Feb 24, 2006 2:52 pm
by Tom_S
Thank you my friend :D

I completely did not see that and stared at it for awhile! I have a bad cold and it is showing for me to miss something that obvious.

Love the Mod and Thanks again :D

Tom

Posted: Thu Sep 28, 2006 1:51 pm
by Encebas