MySQL fatal Error

Discussion in 'MySQL' started by Jalpari, Apr 3, 2009.

  1. #1
    How to solve this mysql error. first time i am experiencing this problem and 3 hours of work and search can not find what is going wrong, while each table is at its own place and they are empty :confused:
    Fatal Error

    If your blog does not display, please contact the owner of this site.

    If you are the owner of this site please check that MySQL is running properly and all tables are error free.

    Database Tables Missing.
    Database tables are missing. This means that MySQL is either not running, WPMU was not installed properly, or someone deleted wp_site. You really should look at your database now.

    What do I do now?
    Read the bug report page. Some of the guidelines there may help you figure out what went wrong.
    If you're still stuck with this message, then check that your database contains the following tables:
    • wp_blogs
    • wp_users
    • wp_usermeta
    • wp_site
    • wp_sitemeta
    • wp_sitecategories
    If you suspect a problem please report it to the support forums but you must include the information asked for in the WPMU bug reporting guidelines!

    link
     
    Jalpari, Apr 3, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Did you recently installed some plugin?
     
    mwasif, Apr 3, 2009 IP
  3. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #3
    Are all the table mentioned above present in your database?

    Kailash
     
    kailash, Apr 3, 2009 IP
  4. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #4
    no just wpmu installtion.
    yes all are there i can show screeshot.
     
    Jalpari, Apr 3, 2009 IP
  5. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #5
    You can create a new database user and assign appropriate permissions to database user and then change database username and password in config file.

    Kailash
     
    kailash, Apr 3, 2009 IP
  6. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #6
    all privilages are selected, what i did yesterday :confused:
     
    Jalpari, Apr 3, 2009 IP
  7. kmofo

    kmofo Active Member

    Messages:
    442
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    85
    #7
    Did you create the wp-config.php file or was it generated at the time of the installation?

    If you manually create it and upload it prior to the installation, it may be the cause of the error. So what you need to do is to remove it from the server, upload the sample config file, and then re-run the install...
     
    kmofo, Apr 4, 2009 IP
  8. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #8
    No i did not create wp-config.php just edit the db info but if i delete wp-config.php file and re create then it says, wp-config file is missing and when upload the file then says error establishing db so i enter db info then it says, fatal error. (Even i try 2 db one which is working fine with wp single user)
     
    Jalpari, Apr 6, 2009 IP
  9. n00bmaster

    n00bmaster Peon

    Messages:
    371
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Let WPMU generate the config file. Don't add it manually. Delete wp-config.php - upload wp-config-sample.php and goto your website's root for installation.

    If you want, I'll do it for ya - drop me a PM.
     
    n00bmaster, Apr 6, 2009 IP
  10. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #10
    I am doing since last 3 days see my last post

     
    Jalpari, Apr 6, 2009 IP
  11. peterCx

    peterCx Peon

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Tables Missing
     
    peterCx, Apr 7, 2009 IP
  12. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #12
    put tables are there. and what when i am using wordpress (single user db) then why i am getting error , even that db is working fine :confused:
     
    Jalpari, Apr 7, 2009 IP
  13. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #13
    It seems to be a permissions problem

    1. MySQL user does not have rights to the tables/database
    2. Operating system does not have rights to these tables. Can you verify that the OS or the user under which MySQL is running has rights on these tables (you can check this by going to mysql_data_directory/database_name/wp_blogs.MYI and wp_blogs.FRM, wp_blogs.MYD and same for the other files).
     
    mwasif, Apr 11, 2009 IP