MySQL Error

New Member Joined: Aug 19, 2013 Posts: 6

Hello, im currently running raven nuke on my website and i keep getting a MySql error on the forums when posting. I've been trying to solve the issue myself but im stumped. the error i get is

Error in posting
DEBUG MODE
SQL error 1366 Incorrect string value: '\x92m not...' for column 'post_text' at row 1

then on the bottom of the debug message it says:

line : 252
File : functions_post.php

anyone ever come across this issue? hoping someone can help me out

Posted: Sat May 09, 2020 1:50 am

Can you reuploading the original file again?

Posted: Sat May 09, 2020 11:35 am

i cant find that file actually, where would i be looking?

Posted: Sat May 09, 2020 5:04 pm

This is the file. Take the original file(updated) from Ravennuke's and upload it again. It will ask yo replace it. Just do it. Always make a backup from the file if you made any modification. Let us know

Code:

modules/Forums/includes/functions_post.php

Posted: Sat May 09, 2020 5:32 pm

just reuploaded it, i'll see if i get any issues

Posted: Sun May 10, 2020 11:54 pm

Re uploaded the file and im still getting the same error

Code:




Error in posting





DEBUG MODE





SQL Error : 1366 Incorrect string value: '\x92m not...' for column 'post_text' at row 1





INSERT INTO nuke_bbposts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (183, 'C. Lipton Enlistment', 'd585c539fe', 'Personal Information ------------------------- Name: Caleb Last Name: Lipton Age: 26 Gender: Male Hardware Information --------------------------- Do you have teamspeak 3 installed? Yes Do you own a copy of Arma 3? Yes Do you have a mic or headset? Yes Questionnaire ----------------- Do you have experience in arma series realism? Affirmative Past units? 82nd Airborne Div. \"The Old Breed\" - Arma 2 What makes you a good fit for the 82nd airborne division? I?m not only a great & mature team player but I?m also very good at following orders by getting the job done Why should our (S-1) department consider your application? WWII not only truly fascinates me, it always have made me wanting to join an airborne realism unit with full of enthusiasm & dedication. Signed, C. Lipton')





Line : 252


File : functions_post.php

registered · Site Admin Joined: Aug 22, 2007 Posts: 1775

welsh, which database collation you are using?

Posted: Fri May 15, 2020 11:53 pm

Sorry about the late reply, been a little busy. i dont quite understand what you mean by which database collation im using

Posted: Sat May 16, 2020 7:58 am

https://stackoverflow.com/questions/341273/what-does-character-set-and-collation-mean-exactly
https://database.guide/what-is-collation-in-databases/

Posted: Sun May 17, 2020 8:48 pm

im not really too sure on which collation im using, i can say its a MYSQL data base and the website is hosted through NFO if that helps?

Posted: Tue May 26, 2020 10:45 pm

I had a simular issue with a database collation mismatch after switching from a mysql-server to maria-db on debian 9.