An unexpected database error occurred. Please try again later.

[Kaiser]

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/

 

[Kaiser]

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" }

 

[Paul B]

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.

 

[Kaiser]

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.

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.

 

[Paul B]

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.

 

[Kaiser]

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.

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?.

 

[TheBoss]

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..

 

[Paul B]

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.

 

[Kaiser]

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.

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

 

[Paul B]

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

Did you get this when you first installed?

 

[Kaiser]

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

Did you get this when you first installed?

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.

 

[Kaiser]

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

Did you get this when you first installed?

http://xenforo.com/community/thread...-error-occurred-please-try-again-later.14832/

 

[TheBoss]

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]

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..

Should I make that default?

 

[TheBoss]

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..

 

[Jake Bunce]

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" }

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".

 

[Kaiser]

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".

View attachment 13736

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.

 

[Jake Bunce]

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

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

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

This error is probably unrelated.

 

[Kaiser]

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

This error is probably unrelated.

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.

 

[Jake Bunce]

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:

★HTML5PIONEER.COM★New Xenforo Based Forum★Web/Graphic Design Discussion ★ Brand New ★