Welcome to the new server - POST ALL PROBLEMS HERE

Status
Not open for further replies.
"Could not insert new word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MYI'. (errno: 145)

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 532088, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('picked', 'metroid', 'prime1', 'during', 'sale', 'hated', 'first', 'ten', 'minutes', 'playing', 'seen', 'sentence', 'terrible', 'hell', 'trying', 'someone', 'came', 'house', 'prime', 'lord', 'cast', 'sales', 'seriously', 'mean', 'one', 'own', 'tru', 'toys', 'us', 'shaqfuing', 'clue', 'wow', 'whole', 'waste', 'obviously', 'important', 'halo', 'stupid', 'move', 'joystick', 'training', 'session', 'rest', 'filled', 'gun', 'gta', 'game', 'ride', 'bike', 'think', 'single', 'final', 'fantasy', 'stun', 'again', 'fan', 'brain', 'dead', 'sessions', 'although', 'halos', 'great', 'games', 'stunning', 'play', 'goddam', 'make', 'long', 'made', '15', 'hours', 'conclusion', 'learn', 'spell', 'english', 'grammer', 'give', 'chance', 'deserve')

Line : 249
File : /usr/home/cheapas/public_html/forum/includes/functions_search.php

"
^From the "Metroid Prime 2 is going to kick ass!!!"topic

When I was trying to reply to it

Strangely enough, despite the error message, my message was posted when I checked back in the topic.
 
LOL

from my last reply here

"Could not insert new word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MYI'. (errno: 145)

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 532093, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('insert', 'word', 'matches', 'debug', 'mode', 'sql', 'error', '1016', 'open', 'file', 'phpbbsearchwordmatch', 'myi', 'errno', '145', 'postid', 'wordid', 'titlematch', 'select', '532088', 'phpbbsearchwordlist', 'wordtext', 'picked', 'metroid', 'prime1', 'during', 'sale', 'hated', 'first', 'ten', 'minutes', 'playing', 'seen', 'sentence', 'terrible', 'hell', 'trying', 'someone', 'came', 'house', 'prime', 'lord', 'cast', 'sales', 'seriously', 'mean', 'one', 'own', 'tru', 'toys', 'shaqfuing', 'clue', 'wow', 'whole', 'waste', 'obviously', 'important', 'halo', 'stupid', 'move', 'joystick', 'training', 'session', 'rest', 'filled', 'gun', 'gta', 'game', 'ride', 'bike', 'think', 'single', 'final', 'fantasy', 'stun', 'again', 'fan', 'brain', 'dead', 'sessions', 'although', 'halos', 'great', 'games', 'stunning', 'play', 'goddam', 'make', 'long', 'made', 'hours', 'conclusion', 'learn', 'spell', 'english', 'grammer', 'give', 'chance', 'deserve', 'line', '249', 'usr', 'cheapas', 'publichtml', 'forum', 'includes', 'functionssearch', 'php', 'kick', 'ass', 'topic', 'reply', 'strangely', 'enough', 'despite', 'message', 'posted', 'checked', 'back')

Line : 249
File : /usr/home/cheapas/public_html/forum/includes/functions_search.php

"
 
Errno 145, at least from MySQL, means a corrupted table. I ran REPAIR TABLE, so let's see if that fixes it. Please try it again.
 
Cheapy or defender (sorry defender if this seems as though it were already posted but I wasn't sure where to post it). I'm having difficulties uploading an avatar even though the specs. are alright. Is something up?
 
The search function seems to be not working. I'm getting a general error "cannot find topic ids", followed by some debugging code.
 
General Error

Could not obtain topic ids

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY p.topic_id' at line 5

SELECT p.topic_id FROM phpbb_posts p WHERE p.post_id IN (554139, 554140, 554141, 554142, 554143, 554144, 554145, 554146, 554147, 554148, 554149, 554150, 554151, 554152, 554153, 554154, 554155, 554156, 554157, 554159, 554160, 554161, 554162, 554163, 554164, 554165, 554166, 554167, 554168, 554169, 554170, 554171, 554172, 554173, 554174, 554175, 554176, 554177, 554178, 554179, 554180, 554181, 554182, 554183, 554184, 554185, 554186, 554187, 554188, 554189, 554190, 554191, 554192, 554193, 554194, 554195, 554196, 554197, 554198, 554199, 554200, 554201, 554202, 554203, 554204, 554205, 554206, 554207, 554208, 554209, 554210, 554211, 554212, 554213, 554214, 554216, 554217, 554218, 554219, 554220, 554221, 554222, 554223, 554224, 554225, 554226, 554227, 554228, 554229, 554230, 554231, 554232, 554233, 554234, 554235, 554236, 554237, 554238, 554239, 554240, 554241, 554242, 554243, 554244, 554245, 554246, 554247, 554248, 554249, 554250, 554251, 554252, 554253, 554254, 554255, 554256, 554257, 554258, 554259, 554260, 554261, 554262, 554263, 554264, 554265, 554266, 554267, 554268, 554269, 554270, 554271, 554272, 554273, 554274, 554275, 554276, 554277, 554278, 554279, 554280, 554281, 554282, 554283, 554284, 554285, 554286, 554287, 554288, 554289, 554290, 554291, 554292, 554293, 554294, 554295, 554296, 554297, 554298, 554299, 554300, 554301, 554302, 554303, 554304, 554305, 554306, 554307, 554308, 554309, 554310, 554311, 554312, 554313, 554314, 554315, 554316, 554317, 554318, 554319, 554320, 554321, 554322, 554323, 554324, 554325, 554326, 554327, 554328, 554329, 554330, 554331, 554332, 554333, 554334, 554335, 554336, 554337, 554338, 554339, 554340, 554341, 554342, 554343, 554344, 554345, 554346, 554347, 554348, 554349, 554350, 554351, 554352, 554353, 554354, 554355, 554356, 554357, 554358, 554359, 554360, 554361, 554362, 554363, 554364, 554365, 554366, 554367, 554368, 554369, 554370, 554371, 554372, 554373, 554374, 554375, 554376, 554377, 554378, 554379, 554380, 554381, 554382, 554383, 554384, 554385, 554386, 554387, 554388, 554389, 554390, 554391, 554392, 554393, 554394, 554395, 554396, 554397, 554398, 554399, 554400, 554401, 554402, 554403, 554404, 554405, 554406, 554407, 554408, 554409, 554410, 554411, 554412, 554413, 554414, 554415, 554416, 554417, 554418, 554419, 554420, 554421, 554422, 554423, 554424, 554425, 554426, 554427, 554428, 554429, 554430, 554431, 554432, 554433, 554434, 554435, 554436, 554437, 554438, 554439, 554440, 554441, 554442, 554443, 554444, 554445, 554446, 554447, 554448, 554449, 554450, 554451, 554452, 554453, 554454, 554455, 554456, 554457, 554458, 554459, 554460, 554461, 554462, 554463, 554464, 554465, 554466, 554467, 554468, 554469, 554470, 554471, 554472, 554473, 554474, 554475, 554476, 554477, 554478, 554479, 554480, 554481, 554482, 554483, 554484, 554485, 554486, 554487, 554488, 554489, 554490, 554491, 554492, 554493, 554494, 554495, 554496, 554497, 554498, 554499, 554500, 554501, 554502, 554503, 554504, 554505, 554506, 554507, 554508, 554509, 554510, 554511, 554512, 554513, 554514, 554515, 554516, 554517, 554518, 554519, 554520, 554521, 554522, 554523, 554524, 554525, 554526, 554527, 554528, 554529, 554530, 554531, 554532, 554533, 554534, 554535, 554536, 554537, 554538, 554539, 554540) AND p.forum_id NOT IN (14, 23) GROUP BY p.topic_id GROUP BY p.topic_id

Line : 484
File : /usr/home/cheapas/public_html/forum/search.php
 
Status
Not open for further replies.
bread's done
Back
Top