Mysqli statement execute error : Incorrect string value: '\xDCRK-Ba...' for column 'message' at row

[Saburov]

Mysqli statement execute error : Incorrect string value: '\xDCRK-Ba...' for column 'message' at row 1

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591
5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580
6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
7. XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 407
8. XenForo_DataWriter_Discussion->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 355
9. XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1385
10. XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 495
11. XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 310
12. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
13. XenForo_FrontController->run() in /home/gezinen/public_html/index.php at line 13

When I try to create a new post, sometimes i have this error message. What is this and how can i fix it? Thanks.

 

[Jon W]

When I try to create a new post, sometimes i have this error message. What is this and how can i fix it? Thanks.

Hi,

It's to do with non-standard characters.

Please could you run the following MySql query and post the results here. This should help identify the root of the problem.

SHOW VARIABLES LIKE  '%olla%';

 

[Saburov]

Hi,

It's to do with non-standard characters.

Please could you run the following MySql query and post the results here. This should help identify the root of the problem.

SHOW VARIABLES LIKE  '%olla%';

Hi

I Don't know mysql very well. Where will i write this querry?

 

[Jon W]

If you have something like phpMyAdmin installed on your server, you should just be able to type the above in the SQL query box and it will give you a result like this:

Variable_name        Value
collation_connection utf8_general_ci
collation_database   latin1_swedish_ci
collation_server     latin1_swedish_ci

 

[Jake Bunce]

Read this thread starting from this post:

http://xenforo.com/community/thread...red-please-try-again-later.14832/#post-194621

You need to fix your collations. On the second page in that thread I attached a script to update all tables if you need it.

 

[Saburov]

If you have something like phpMyAdmin installed on your server, you should just be able to type the above in the SQL query box and it will give you a result like this:

Variable_name        Value
collation_connection utf8_general_ci
collation_database  latin1_swedish_ci
collation_server    latin1_swedish_ci

Sorry i'm late. My results are this:

Variable_name Value
collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci

 

[Saburov]

Read this thread starting from this post:

http://xenforo.com/community/thread...red-please-try-again-later.14832/#post-194621

You need to fix your collations. On the second page in that thread I attached a script to update all tables if you need it.

Jake, my title collation cell has already "utf8_general_ci". All the collation column has "utf8_general_ci" value.

 

[Jake Bunce]

Jake, my title collation cell has already "utf8_general_ci". All the collation column has "utf8_general_ci" value.

Your error message names the message column, not title. It should be in xf_post.

 

[Saburov]

Your error message names the message column, not title. It should be in xf_post.

it's turkish but you can see all of the options are utf8_general_ci in xf_post. it's weird.

 

[Jake Bunce]

What message are you posting that causes this error? Are you able to post it here?

 

[Saburov]

for example trying to copy paste this post

http://ahmetdursun374.blogcu.com/matta-incil-e-neyi-ekledi/13138939

 

[Jake Bunce]

I have no problems posting that message with utf8 collations.

I can take a look if you give me FTP and admin access.