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

An unexpected database error occurred. Please try again later.

Discussion in 'Troubleshooting and Problems' started by Kaiser, Apr 11, 2011.

  1. Kaiser

    Kaiser Well-Known Member

    Whenever I visit my site I get An unexpected database error occurred. Please try again later. before that it was loading real slow and it has been doing this for the past week. I opened a ticket on my host. You guys have any idea why?

    EDIT: Its working again but loading very slow.

    http://adminbb.org/
     
  2. Kaiser

    Kaiser Well-Known Member

    Now its normal again, it does this often. Here is my server error log.



    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xE2\x98\x85HTM...' for column 'title' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Scar3croW, Today at 7:00 AM

    Stack Trace​


    #0 /home/adminbbo/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array) #1 /home/adminbbo/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/adminbbo/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array) #3 /home/adminbbo/public_html/library/XenForo/DataWriter.php(1500): Zend_Db_Adapter_Abstract->insert('xf_thread', Array) #4 /home/adminbbo/public_html/library/XenForo/DataWriter.php(1489): XenForo_DataWriter->_insert() #5 /home/adminbbo/public_html/library/XenForo/DataWriter.php(1291): XenForo_DataWriter->_save() #6 /home/adminbbo/public_html/library/XenForo/ControllerPublic/Forum.php(342): XenForo_DataWriter->save() #7 /home/adminbbo/public_html/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Forum->actionAddThread() #8 /home/adminbbo/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #9 /home/adminbbo/public_html/index.php(13): XenForo_FrontController->run() #10 {main}

    Request State​


    array(3) { ["url"] => string(58) "http://adminbb.org/forums/showcasing-reviews.16/add-thread" ["_GET"] => array(0) { } ["_POST"] => array(12) { ["title"] => string(95) "★HTML5PIONEER.COM★New Xenforo Based Forum★Web/Graphic Design Discussion ★ Brand New ★" ["message_html"] => string(811) "<div style="text-align: center;"><img src="http://i607.photobucket.com/albums/tt153/serviesiscool/logo-1.png" alt="[Image: logo-1.png]" border="0" /></div> <p><a href="http://html5pioneer.com/" target="_blank"></a><br /> <br /> <span style="font-size: large;"></span></p> <div style="text-align: center;"><span style="color: #888888;">Using tomorrows standards today. Be a html5pioneer and join the discussion on our forums.<br /> This is a brand new site. I want it to become the biggest next gen web design forum on the market. Please join and contribute! </span></div> <div style="text-align: center;"><a href="http://html5pioneer.com/login"><br /></a></div> <div style="text-align: center;"><span style="color: #888888;"><a href="http://html5pioneer.com/login">http://html5pioneer.com</a><br /></span></div>" ["_xfRelativeResolver"] => string(61) "http://adminbb.org/forums/showcasing-reviews.16/create-thread" ["attachment_hash"] => string(32) "e45f000d0347b97d50e1b927ee209def" ["watch_thread"] => string(1) "1" ["watch_thread_email"] => string(1) "1" ["watch_thread_state"] => string(1) "1" ["poll"] => array(2) { ["question"] => string(0) "" ["responses"] => array(2) { [0] => string(0) "" [1] => string(0) "" } } ["_xfToken"] => string(55) "324,1302501605,84b4fe01c2f8d947c74757baa6235f15b8d943a1" ["_xfRequestUri"] => string(43) "/forums/showcasing-reviews.16/create-thread" ["_xfNoRedirect"] => string(1) "1" ["_xfResponseType"] => string(4) "json" }
     
  3. Brogan

    Brogan XenForo Moderator Staff Member

    It will more than likely be server related.

    Are you on shared hosting or VPS?
    If you're on shared hosting then it's possible the host has too many accounts on the server.
     
  4. Kaiser

    Kaiser Well-Known Member

    Its shared.

    My server log is filled with this same error.
    Also everytime I upgrade xenforo, when I upload the files I get 3 failed uploads and it says "failed creating Directory" do you know what that is? That could be the problem, I re add the failed uploads to the quee but I still get those 3 failed uploads.
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    Ah, just noticed your second post, that wasn't there when I replied.

    The problem you mention above sounds like a permissions issue.
    Have you set all the permissions correctly?
    Which three directories are they?

    It's possible that you don't have the full and correct complement of files.
     
  6. Kaiser

    Kaiser Well-Known Member

    Its never mentions which directories it fails to create, just that "Failed to create directory" and theres 3 of that in the failed uploads on filezilla. Do you want me update my board again, and take a screenshot of the failed uploads?.
     
  7. TheBoss

    TheBoss Well-Known Member

    Some servers are set up not to allow XML file uploads via FTP or HTTP

    If you find this is the case of your failed uploads and I suspect it will be you can upload XML files via your CPanel File Manager.

    I had a similar problem when I uploaded XF to a domain hosted on a shared server that is not on my dedi server...

    Regards..
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    The FTP program you're using should have a detailed log of the failures.
    Really we need to see which directories it's failing on before we can work out how to fix it.
     
  9. Kaiser

    Kaiser Well-Known Member

    I cant find any logs in filezilla. So should I re upload the files again?
     
  10. Brogan

    Brogan XenForo Moderator Staff Member

    You can try but I suspect you'll encounter the same error.

    Did you get this when you first installed?
     
  11. Kaiser

    Kaiser Well-Known Member

    Didnt happen the first time, It happened when I updated from beta6 to 1.00 and then again to 1.01. I just found out how to turn on the logs in filezilla, so I will try again and post the logs for you.
     
  12. Kaiser

    Kaiser Well-Known Member

  13. TheBoss

    TheBoss Well-Known Member

    You could try uploading files in Binary format instead of FileZilla`s default of Auto..

    Auto does not always succeed in reading the right file format...

    Regards..
     
    Kaiser likes this.
  14. Kaiser

    Kaiser Well-Known Member

    Should I make that default?
     
  15. TheBoss

    TheBoss Well-Known Member

    I am not 100% sure about FileZilla as I do not use it that much , I dont know if it retains a setting change on a permanent basis...

    As long as you upload all files in Binary mode , that should work..

    Regards..
     
  16. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    This error looks like a problem with the collation of xf_thread.title in the database.

    Login to CPanel (http://adminbb.org/cpanel/). Open phpmyadmin inside of your CPanel. Select your database on the left and then select the xf_thread table. Click the Structure tab. What is the collation of the title field? It should be "utf8_general_ci".

    Screen shot 2011-04-11 at 7.26.56 PM.png
     
    Brogan likes this.
  17. Kaiser

    Kaiser Well-Known Member

    I dont have a title, all of them start with xf_ and I looked for a xf_title and didnt see that either.

    By the way my problem was solved it was the host's issue another client was abusing resources.
     
  18. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Open the xf_thread table. There is a title field inside of that table.

    This error is probably unrelated.
     
  19. Kaiser

    Kaiser Well-Known Member

    The collation for the title is latin1_swedish_ci, and its the same collation for username, discussion_state, discussion_type, last_post_username in the xf_thread structure.
     
  20. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    They should all be "utf8_general_ci". You should change them. Check the other tables and fields as well.

    Did you deliberately change those collations to "latin1_swedish_ci"?

    FYI, you should be able to reproduce the error if you try to create a thread with the title indicated in the error:

     
    tenants likes this.

Share This Page