SQL Error and index

[Cadmium]

When I hit the submit button, the post is stored but I get the following SQL Error:

Code: Select all

Could not insert new word matches

DEBUG MODE

SQL Error : 1196 Warning: Some non-transactional changed tables couldn't be rolled back

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 65131, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('word1', 'word2', 'word3', 'word4', 'word5', 'word6')

Line : 265
File : /home/mith/public_html/forum/includes/functions_search.php

Also, the new posts don't show up in the index.

[Cadmium]

Never mind.

Must have been solved during today's crash.

[Quagmire]

That crash was sooo 10 minutes ago.

[willows_weep]

Could not obtain vote data for this topic

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result FROM phpbb_vote_desc vd, phpbb_vote_results vr WHERE vd.topic_id = 783 AND vr.vote_id = vd.vote_id ORDER BY vr.vote_option_id ASC

Line : 842
File : /home/mith/public_html/forum/viewtopic.php


I get that when I try to open a thread with a poll.

I got in earlier today and this is the first time I got this message.
I will try again later tonight perhaps

[Morpheus]

yeah me too willow.

[willows_weep]

I think it does this kind of thing off and on.
Last night I kept getting another sort of thing while in the chat and then every page I would try to go to gave that warning thing with a white page.

[jeep]

When it happens note the time and when you can post, put it in this thread.

-JEEP

[Someone]

I JUST got this error, not 10 seconds ago.

[jeep]

The vote problem should be temporarily worked around. I do not understand why (yet) but the order by clause caused many problems. I have removed it for now, so if the order of poll options move changes, it's because I removed the order by clause.

-JEEP