1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 xf_stats_daily doesn't exist

Discussion in 'Troubleshooting and Problems' started by grantus, Jun 29, 2015.

  1. grantus

    grantus Active Member

    The past few days I've been getting these errors:

    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'forums.xf_stats_daily' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77

    But nothing has changed that would cause this, I didn't modify anything recently.

    When I look at the database in phpMyAdmin, it shows the table is there but when I click on the table, an error pops up saying the table doesn't exist.

    Any ideas as to what could be causing this and how to fix it?

    Thanks.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    If you haven't made any changes then you should contact your host.

    If you are getting an error when trying to view the table, that could indicate database corruption.
     
  3. grantus

    grantus Active Member

    I'll contact them and see. But would it be safe to just recreate that table?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    I wouldn't advise making any changes until you determine the nature of the problem.
     
  5. grantus

    grantus Active Member

    Ok it's fixed now. All my host did was restart the mysql server because this is their explanation:

    Since the database is an Innodb type, repairing is not supported. This issue is because sometimes the database fails to access the data files from the corresponding directory. This can be resolved by just restarting the mysql server.
     

Share This Page