Database crashing trying to save a new article

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RobbieZ
    Senior Member
    • Jun 2008
    • 137

    [CMS] Database crashing trying to save a new article

    Any one else getting this error?

    For some reason since yesterday, I can not save a new article I create anymore!

    I thought it was just the re-editing but its across the board now as in any article.

    I have left a bug report too.

    Database error in vBulletin 4.0.6:

    Invalid SQL:
    INSERT INTO searchgroup_text (searchgroupid, title)
    VALUES ( 93, 'test' )
    ON DUPLICATE KEY UPDATE searchgroupid = VALUES(searchgroupid), title = VALUES(title);

    MySQL Error : Table './my_database/searchgroup_text' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Friday, September 3rd 2010 @ 12:17:03 PM
    Error Date : Friday, September 3rd 2010 @ 12:17:03 PM
    Script : http://myforum.com/test/content.php?125
    Referrer : http://myforum.com.info/test/content...age/addcontent
    IP Address : *******
    Username : ******
    Classname : vB_Database
    MySQL Version : 5.1.48

    *edit

    I have hit repair table and got this:
    searchgroup_text Check Warning: Table is marked as crashed

    searchgroup_text Check Error: Key in wrong position at page 2048

    searchgroup_text Check Error: Corrupt

    searchgroup_text


    Then I hit repair and optimize and everything is ok.

    WTF! lol
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    Take a look at this thread and try these methods to repair the table - 3 ways to repair a database

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • RobbieZ
      Senior Member
      • Jun 2008
      • 137

      #3
      Thanks Lynne

      Comment

      • drkenlee
        Member
        • Aug 2006
        • 38
        • 4.2.x

        #4
        I get a link not found error on the "2 ways to repair a database" can you resend that?

        When I create a new article my Vbulletin just hangs, it shows a blank page in the browser but the article has a link from the originating page. If I click on "read more" I get the same result, a blank page. Any ideas of what to try next?

        Comment

        • Lynne
          Former vBulletin Support
          • Oct 2004
          • 26255

          #5
          Please read this blog about repairing corrupt databases. As it says, you may need to contact your host - http://www.vbulletin.com/forum/blogs/george-l/3929800

          Here is a page from the manual about troubleshooting blank or 'white' pages: https://www.vbulletin.com/docs/html/blank_pages

          Please don't PM or VM me for support - I only help out in the threads.
          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
          Want help modifying your vbulletin forum? Head on over to vbulletin.org
          If I post CSS and you don't know where it goes, throw it into the additional.css template.

          W3Schools <- awesome site for html/css help

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...