SQL Errors Again?

imported post

I'm getting the same error message when posting that I did back when we had the SQL indexing problem a few months ago. It still posts after I hit "send", but it displays a long error message.

Or maybe the BATFE is trying to thwart my activity on OCDO... :shock:

ETA: This is the message I got after I posted this thread:

Invalid SQL query: INSERT INTO wowbb_search_index (word_id, post_id, topic_id) VALUES (160983, 180216, 11204),(197258, 180216, 11204),(174274, 180216, 11204),(161179, 180216, 11204),(160880, 180216, 11204),(161258, 180216, 11204),(161099, 180216, 11204),(160933, 180216, 11204),(161005, 180216, 11204),(161049, 180216, 11204),(161106, 180216, 11204),(161885, 180216, 11204),(161079, 180216, 11204),(161231, 180216, 11204),(161113, 180216, 11204),(160888, 180216, 11204),(161238, 180216, 11204),(171227, 180216, 11204),(163144, 180216, 11204),(161130, 180216, 11204),(160975, 180216, 11204),(161008, 180216, 11204),(161318, 180216, 11204),(160879, 180216, 11204),(161044, 180216, 11204),(200597, 180216, 11204),(161972, 180216, 11204),(160881, 180216, 11204),(160901, 180216, 11204),(161254, 180216, 11204),(161056, 180216, 11204),(161321, 180216, 11204),(160911, 180216, 11204),(161291, 180216, 11204),(161995, 180216, 11204),(163071, 180216, 11204),(160898, 180216, 11204),(162940, 180216, 11204),(161225, 180216, 11204),(162185, 180216, 11204),(174188, 180216, 11204),(160936, 180216, 11204),(160876, 180216, 11204),(176340, 180216, 11204),(164935, 180216, 11204),(160985, 180216, 11204),(164437, 180216, 11204)-Table 'wowbb_search_index' is marked as crashed and should be repaired

imported post

Ya.... everything is making it in...

It seems that the process that marks a thread as viewed by you is not working.

imported post

Hopefully somebody fixes it soon, it's very obnoxious.

imported post

I'm getting these errors with every single post. I wonder what happened.

imported post

Who is tinkering with the database?

imported post

Doug Huffman wrote:

Who is tinkering with the database?

Click to expand...

Only the database administrator where the web-server is housed has access.

SQL Databases that accumulate a lot of entries do, at times, fail and have an indexing problem.

imported post

Problem has stopped.

imported post

Yay!

imported post

Really? Changing the subject and description fields, is being done by the db administrator?

imported post

Doug Huffman wrote:

Really? Changing the subject and description fields, is being done by the db administrator?

Click to expand...

It just so happens that I am a SQL database administrator. What are the odds on that!!??

Tinkering with the database describes what is done behind the scenes with the data tables. ANYTING can be changed there. Maybe you meant tinkering with the threads.

imported post

LEO 229 wrote:

It just so happens that I am a SQL database administrator. What are the odds on that!!??

Click to expand...

{shudder} :uhoh:

imported post

I am experiencing some other very strange things when posting.

1. Hitting enter nowalways causes a double space within the "posting window."

2. Hitting backspacewith the cursorat the beginninga wordunder a quoted section of text is automatically putting the unquotedwords into the quoted section.

3. Quite a few other assorted, but hard to explain things, are happening related to quoted/unquoted text.

imported post

It won't let me put any emoticons before my text.