Results 1 to 13 of 13

Thread: SQL Errors Again?

  1. #1
    Regular Member
    Join Date
    Jun 2007
    Location
    Catasauqua, Pennsylvania, USA
    Posts
    3,047

    Post 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

  2. #2
    Regular Member
    Join Date
    Feb 2007
    Location
    USA
    Posts
    7,607

    Post imported post

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

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

  3. #3
    Regular Member thx997303's Avatar
    Join Date
    May 2008
    Location
    Lehi, Utah, USA
    Posts
    2,716

    Post imported post

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

  4. #4
    Regular Member
    Join Date
    Jan 2008
    Location
    USA
    Posts
    806

    Post imported post

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

  5. #5
    Banned
    Join Date
    Jun 2006
    Location
    Washington Island, across Death's Door, Wisconsin, USA
    Posts
    9,193

    Post imported post

    Who is tinkering with the database?

  6. #6
    Regular Member
    Join Date
    Feb 2007
    Location
    USA
    Posts
    7,607

    Post imported post

    Doug Huffman wrote:
    Who is tinkering with the database?
    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.

  7. #7
    Regular Member
    Join Date
    Jan 2008
    Location
    USA
    Posts
    806

    Post imported post

    Problem has stopped.

  8. #8
    Regular Member thx997303's Avatar
    Join Date
    May 2008
    Location
    Lehi, Utah, USA
    Posts
    2,716

    Post imported post

    Yay!

  9. #9
    Banned
    Join Date
    Jun 2006
    Location
    Washington Island, across Death's Door, Wisconsin, USA
    Posts
    9,193

    Post imported post

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

  10. #10
    Regular Member
    Join Date
    Feb 2007
    Location
    USA
    Posts
    7,607

    Post imported post

    Doug Huffman wrote:
    Really? Changing the subject and description fields, is being done by the db administrator?
    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.

  11. #11
    Campaign Veteran Nelson_Muntz's Avatar
    Join Date
    Jan 2008
    Location
    Manassas, Virginia, USA
    Posts
    697

    Post imported post

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

    {shudder}

  12. #12
    Regular Member
    Join Date
    Jan 2008
    Location
    USA
    Posts
    806

    Post 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.


  13. #13
    Regular Member thx997303's Avatar
    Join Date
    May 2008
    Location
    Lehi, Utah, USA
    Posts
    2,716

    Post imported post

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •