Help: I get a blank page

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cirdok2
    Senior Member
    • Aug 2004
    • 412
    • 3.6.x

    Help: I get a blank page

    I upgraded from 3.0.7 to 3.6 (reverted all the templates) and everything seemed to go well.

    Suddendly I got a white blank page and I am not able to load the forum.

    The admincp works, I tried to rebuild the languages and I got this error:

    PHP Code:
    Database error in vBulletin 3.6.0:
    Invalid SQL:
    LOCK TABLES mailqueue WRITE;
    MySQL Error  Access denied for user 'xxxxxx'@'localhost' to database 'xxxxxx'
    Error Number 1044
    Date         
    SundayAugust 13th 2006 08:03:38 AM
    Script       
    http://xxxxxxxxxxxxxx/forumvb/admincp/language.php?do=rebuild&goto=language.php?
    Referrer     http://xxxxxxxxxxxxxxx/forumvb/admincp/language.php?do=modify
    IP Address   131.215.103.223
    Username     
    CDk
    Classname    
    vb_database 
    Any help, thanks
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    Look like your user does not have the write privliage for your database.

    Comment

    • cirdok2
      Senior Member
      • Aug 2004
      • 412
      • 3.6.x

      #3
      Originally posted by Zachery
      Look like your user does not have the write privliage for your database.
      I have done all the installation with that user and everything went fine for many hours.

      Suddendly I got this blank page:

      Comment

      • cirdok2
        Senior Member
        • Aug 2004
        • 412
        • 3.6.x

        #4
        I have also an adserver in mySQL, same user and it works fine.
        But in vBulletin I got that message also if I go in Style Manager.

        Have I to ask to check to my hosting?
        Thanks

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          The most likely cause of this error is that the info in your config.php file is wrong or your db user does not have full permissions to this database. Please read this for all the known causes of this error:

          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          • cirdok2
            Senior Member
            • Aug 2004
            • 412
            • 3.6.x

            #6
            If the error you are getting also includes this section:

            Invalid SQL:
            LOCK TABLES ......


            Then you need to make sure the DB user has LOCK permissions to this database.

            but how can it happen suddendly after 2 hours I was working, browsing and inserting thread in the forum?

            After deleting a message I got the blank page and errors dispatched to my email (but I had already deleted some posts before and everything was ok).

            I checked the config.php files and it is ok.

            Is there any test I can do, or I have only to wait for my hosting to check the database?

            Thanks guys, I really appreciate your help.

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              If you are getting the 'access denied' error, then those are all the known causes of that error.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment

              • cirdok2
                Senior Member
                • Aug 2004
                • 412
                • 3.6.x

                #8
                solved enabling lock grant... thanks guys and thanks also to my hosting, very helpful also on a mid-August Sunday
                Last edited by cirdok2; Sun 13 Aug '06, 2:46am.

                Comment

                • cirdok2
                  Senior Member
                  • Aug 2004
                  • 412
                  • 3.6.x

                  #9
                  After enabling lock table grants, everything look fine.
                  I also repaired and optimized the tables.

                  Is there anything else I can do (besides go to sleep)?

                  Thanks

                  Comment

                  • Steve Machol
                    Former Customer Support Manager
                    • Jul 2000
                    • 154488

                    #10
                    If things are working, take a break.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment

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