mySQL error

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • mySQL error

      As I noted in my other thread I get the following error when I post to the site. When looking at the forum it also appears like there are no "new" threads or replies. Anyone else getting this? I'm assuming it's a site thing as from the error it looks like one of the database tables is the problem.

      mysql-database errormysql-database error
      Database error in WoltLab Burning Board: Invalid SQL: SELECT wordid, word FROM bb1_wordlist WHERE word IN
      (This part contains the word's of the post)
      mysql error: Table 'bb1_wordlist' is marked as crashed and should be repaired
      mysql error number: 1194
      Date: 11.10.2013 @ 18:35
      Script: /GameCode/addreply.php

      The post was edited 1 time, last by Trinak ().

    • Yes I have been getting the errors as well, I do see the replies IN the post, however the main page shows 0 replies on the threads.
      PC - Custom Built
      CPU: 3rd Gen. Intel i7 3770 3.4Ghz
      GPU: ATI Radeon HD 7959 3GB
      RAM: 16GB

      Laptop - Alienware M17x
      CPU: 3rd Gen. Intel i7 - Ivy Bridge
      GPU: NVIDIA GeForce GTX 660M - 2GB GDDR5
      RAM: 8GB Dual Channel DDR3 @ 1600mhz
    • It's weird, I'm very curious.
      I assume its some cms, is it Mike's own?
      It probably shouldn't return db errors to hosts....
      Does it have a dictionary and then posts stored as a collection of indexes into a words table?
      That must be a big table, is it there for searching?
      Just curious is all...
    • The site uses Burning Board.
      PC - Custom Built
      CPU: 3rd Gen. Intel i7 3770 3.4Ghz
      GPU: ATI Radeon HD 7959 3GB
      RAM: 16GB

      Laptop - Alienware M17x
      CPU: 3rd Gen. Intel i7 - Ivy Bridge
      GPU: NVIDIA GeForce GTX 660M - 2GB GDDR5
      RAM: 8GB Dual Channel DDR3 @ 1600mhz
    • RE: mySQL error

      I'll check into it ASAP. Thanks for the heads up!.
      Mr.Mike
      Author, Programmer, Brewer, Patriot
    • RE: mySQL error

      I believe everything should be back to normal now...
      Mr.Mike
      Author, Programmer, Brewer, Patriot
    • RE: mySQL error

      @quin - it looked like a simple indexing error in MySQL that just needed to be cleaned up, which is a typical thing you can find in admin software for MySQL.

      No big deal!
      Mr.Mike
      Author, Programmer, Brewer, Patriot
    • RE: mySQL error

      This is a test post!
      Mr.Mike
      Author, Programmer, Brewer, Patriot