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

XF 1.2 An unexpected database error occurred. Please try again later.

Discussion in 'XenForo Questions and Support' started by Slind, Aug 13, 2013.

  1. Slind

    Slind Active Member

    Hey,

    I moved my Forum from a webspace to a vserver. Database and database accs are the same. Other CMSs working fine.

    What could be the issue ?

     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    View the page source to see if there is additional information.
    This is usually due to incorrect database details in config.php.
     
    kprojects likes this.
  3. Slind

    Slind Active Member

    same database and acc as contao and contao is working
    why is there a .xf ?

    An unexpected database error occurred. Please try again later.
    <!-- Mysqli prepare error: Table '46361m36800_10.xf_option' doesn't exist -->

    $config['db']['dbname'] = '46361m36800_10';
     
  4. Jeremy

    Jeremy XenForo Moderator Staff Member

    xf_ is the standard prefix to all XenForo tables.
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    At least one of the tables is missing, possibly more.
    Confirm in phpMyAdmin that the DB is viable.
     
  6. Slind

    Slind Active Member

    phpmyadmin isnt workign anymore (forbidden), it worked yesterday, fuu.
    any idea ?
     

    Attached Files:

  7. Slind

    Slind Active Member

    i cant solve it, any idea what could be wrong with apache?
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    Contact your host or server admin.
     
  9. Jeremy

    Jeremy XenForo Moderator Staff Member

    You may want to reach out to your host to help you with some of these server issues that are cropping up, they are the ones who would be able to help you the easiest.
     
  10. Slind

    Slind Active Member

    Its a vserver...

    permissions/users/groups are allright. apache setup is left.
     
  11. Jeremy

    Jeremy XenForo Moderator Staff Member

    Virtual server or not, unless you have the physical server in your house, you have a host that should be able to help.
     
  12. Slind

    Slind Active Member

    i dont think, they will help or look into it.
     
  13. Jeremy

    Jeremy XenForo Moderator Staff Member

    Who do you host with? Is it shared, VPS, or dedicated? Managed or Unmanaged?
     
  14. Slind

    Slind Active Member

    got apache working again

    you are right there are a lot of tables missing.

    How do i fix this, if I export them with default settings as bzip it only includes 136 of over 250 tables.
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    Use SSH to dump the DB:
    Code:
    mysqldump -ucta -p --single-transaction --skip-lock-tables db_name > /path/to/backup/db_name_$(date +%d.%m.%y).sql
    Then .zip it:
    Code:
    tar -czf db_name_$(date +%d.%m.%y).tar.gz /path/to/backup/db_name_$(date +%d.%m.%y).sql
    Then copy it to the new server, unzip it and import it.
     
  16. Slind

    Slind Active Member

    no shh on the webserver
     
  17. Jeremy

    Jeremy XenForo Moderator Staff Member

    How did you originally transfer the database? You'll have to redo the transfer.
     
  18. Slind

    Slind Active Member

    i used phpmyadmin on the webserver to export it and imported it via phpmyadmin on the vserver
     
  19. Jeremy

    Jeremy XenForo Moderator Staff Member

    You'll have to redo the import via PhpMyAdmin again.
     
  20. borbole

    borbole Well-Known Member

    How big is your db? Most server have a file size limit for phpmyadmins on their server so the backup/restore process can get corrupted.

    Try another tool like mysqldumper for example. It handles both operations very nicely (backup&restore). The same goes for large files as well.
     

Share This Page