Help please: My forum is down MySQL Error ???

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tigull
    New Member
    • Jan 2008
    • 9

    Help please: My forum is down MySQL Error ???

    My forum at http://golfspjall.is/spjall become inactive last Friday. I have contacted my host, they seem not knoe the problem.
    Can anyone please inform me what the problem is. Thank you!

    Here is what says when you go to my forum:

    Database error in vBulletin 3.8.4:
    Invalid SQL:
    REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
    VALUES ('157.157...', 'country', '157.157..._country'), ('Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; GTB7.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; BRI/2)', 'useragent', '157.157..._useragent');
    MySQL Error : Incorrect file format 'psistats_cache'
    Error Number : 130
    Request Date : Monday, November 14th 2011 @ 05:03:24 PM
    Error Date : Monday, November 14th 2011 @ 05:03:25 PM
    Script : http://golfspjall.is/spjall/index.php
    Referrer : http://golfspjall.is/
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version : 5.1.45-1
    Last edited by tigull; Mon 14 Nov '11, 9:38am.
  • Andy
    Senior Member
    • Jan 2002
    • 5886
    • 4.1.x

    #2
    Do you have some sort of stats plugin? Disable it.

    Comment

    • tigull
      New Member
      • Jan 2008
      • 9

      #3
      Originally posted by Andy
      Do you have some sort of stats plugin? Disable it.
      I can't login to my admincp, the same error come up

      Comment

      • Andy
        Senior Member
        • Jan 2002
        • 5886
        • 4.1.x

        #4
        Originally posted by tigull
        I can't login to my admincp, the same error come up
        I assume you tried:

        Comment

        • tigull
          New Member
          • Jan 2008
          • 9

          #5
          Originally posted by Andy
          Yes, that's right

          Comment

          • Andy
            Senior Member
            • Jan 2002
            • 5886
            • 4.1.x

            #6
            Have you tried phpmyadmin to repair the 'psistats_cache' table?

            Comment

            • tigull
              New Member
              • Jan 2008
              • 9

              #7
              Originally posted by Andy
              Have you tried phpmyadmin to repair the 'psistats_cache' table?
              You have to be precise please, I'm not much into the technical things...

              Comment

              • Andy
                Senior Member
                • Jan 2002
                • 5886
                • 4.1.x

                #8
                I suggest you call your web hosting company and ask them to repair your damaged database table called 'psistats_cache'.

                Another option is to restore your database from a backup. You are backing up your database right?

                Comment

                • tigull
                  New Member
                  • Jan 2008
                  • 9

                  #9
                  Originally posted by Andy
                  I suggest you call your web hosting company and ask them to repair your damaged database table called 'psistats_cache'.

                  Another option is to restore your database from a backup. You are backing up your database right?
                  Ok I will do that, thanks a lot

                  Comment

                  • HMBeaty
                    Senior Member
                    • Mar 2005
                    • 1105
                    • 4.2.5

                    #10
                    Have you tried disabling your plugins via your includes/config.php file?

                    Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php
                    PHP Code:
                    define('DISABLE_HOOKS'true); 
                    "Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
                    "It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!"
                    "When doors close, tear down the walls. Never give up!"

                    Comment

                    • tigull
                      New Member
                      • Jan 2008
                      • 9

                      #11
                      Originally posted by HMBeaty
                      Have you tried disabling your plugins via your includes/config.php file?

                      Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php
                      PHP Code:
                      define('DISABLE_HOOKS'true); 
                      Where is this includes/config.php file located? Can just make easy things, have to be guided. Can't login to my admincp because of the error. Thanks

                      Comment

                      • HMBeaty
                        Senior Member
                        • Mar 2005
                        • 1105
                        • 4.2.5

                        #12
                        Originally posted by tigull
                        Where is this includes/config.php file located? Can just make easy things, have to be guided. Can't login to my admincp because of the error. Thanks
                        Do you not install/upgrade your own forum?
                        "Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
                        "It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!"
                        "When doors close, tear down the walls. Never give up!"

                        Comment

                        • tigull
                          New Member
                          • Jan 2008
                          • 9

                          #13
                          Originally posted by HMBeaty
                          Do you not install/upgrade your own forum?
                          No, I don't know how to and it has not been done in a while. I have never had any problems with my forum.

                          Comment

                          • tigull
                            New Member
                            • Jan 2008
                            • 9

                            #14
                            The host has repaired the database table but it's all with the same. My board is still down and I'm going crazy.
                            Last edited by Zachery; Tue 15 Nov '11, 1:36pm.

                            Comment

                            • Zachery
                              Former vBulletin Support
                              • Jul 2002
                              • 59097

                              #15
                              Please don't ask for paid help here, its not the correct place.

                              You should contact your webhost again:

                              Cannot use database golfspjall_spjall
                              MySQL Error : Access denied for user 'golfspjall'@'localhost' to database 'golfspjall_spjall'


                              Your mysql user does nto have permission to access the database set in the config file. They might have acdiently changed something when they repaired.

                              Comment

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