Error 1366 - Incorrect string value:

Error 1366 - Incorrect string value: - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: Error 1366 - Incorrect string value: (/thread-233951.html)

Error 1366 - Incorrect string value: - MrBASins - 2021-10-10

I keep getting this error below can anyone help or tell me how to fix it?? no matter what version.

SQL Error:
1366 - Incorrect string value: '\xA2\xFD\x81j' for column 'ip' at row 1

Query:
REPLACE INTO my3_sessions SET uid='0',sid='aa1a7e7443078a9e4e49624c076a35c4',time='1633903612',ip=X'a2fd816a',location='/forums/index.php?',useragent='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.71',location1='0',location2='0',nopermission='0'

RE: Error 1366 - Incorrect string value: - nixer55 - 2021-10-11

My3_sessions not a default mybb table - but error is consistent with wrong encoding for the table / field. Considering it appears to be a custom table, I'd get to the cause of that first.

Edit: Unless for some reason the table prefix was changed. But that should be consistent with - and documented - in the config.php. AFAIK - lol.

RE: Error 1366 - Incorrect string value: - Matt - 2021-10-11

Yeah looks like the database prefix was just changed.

Does this happen for everyone? Are you on a live board or local test one? I can't work out what that value is or where it's coming from, but it looks like the server is reporting the IP address incorrectly somehow.

RE: Error 1366 - Incorrect string value: - nixer55 - 2021-10-11

I decoded the hex value posted - \xA2\xFD\x81j. Works out to 0.0.0.0 - which underlines Matt's question. Smile

RE: Error 1366 - Incorrect string value: - MrBASins - 2021-10-11

(2021-10-11, 12:42 PM)Matt Wrote: Yeah looks like the database prefix was just changed.

Does this happen for everyone? Are you on a live board or local test one? I can't work out what that value is or where it's coming from, but it looks like the server is reporting the IP address incorrectly somehow.

That is what I thought! I said that it looks to be maybe an Ip address issue, (you can see the issue for yourself HERE) when I was talking to tech support on GoDaddy (for over an hour) but he said it couldn't be everything looks good on there end and they said the server is live as all my websites work and all its current databases for wordpress work just fine.

All this happened via their cpanel as your software is up to data and apart of panels "Installedron" as they call it (a free application directory to install via the panel to get one started) this is where I installed it from the first time.

Them I tried manual and it would go thought the first few steps and it stopped at “database config”. and said that ether the password, username or database does not work are you sure its correct (Something along that line)?. Even if I’ve manually created the database for MySQL (with all the details required) and field out spot on?

RE: Error 1366 - Incorrect string value: - StefanT - 2021-10-12

(2021-10-11, 01:54 PM)nixer55 Wrote: I decoded the hex value posted - \xA2\xFD\x81j. Works out to 0.0.0.0 - which underlines Matt's question.

The IP address from the actual query (see first post) is perfectly fine. It looks like there is an issue with the database schema. This error message is not plausible for a varbinary field.

RE: Error 1366 - Incorrect string value: - nixer55 - 2021-10-12

Thanks StefanT. Wasn't sure on that error, but did note the field should be varbinary. No experience with "Installedron" or other webhost driven installers. But as you say, it's valid address syntax. Just never seen it on a live board. Huh

RE: Error 1366 - Incorrect string value: - noyle - 2021-10-12

Will you please run this query (using phpMyAdmin, etc., assuming you're on MySQL) and paste the output back here?

SHOW CREATE TABLE my3_sessions

RE: Error 1366 - Incorrect string value: - MrBASins - 2021-10-13

(2021-10-12, 07:34 PM)noyle Wrote: Will you please run this query (using phpMyAdmin, etc., assuming you're on MySQL) and paste the output back here?
SHOW CREATE TABLE my3_sessions

the board know shows two errors when I visit the site HERE but I'll post the details below

The following warnings occurred:
Warning [2] Invalid argument supplied for foreach() - Line: 331 - File: global.php PHP 7.3.30 (Linux)

File
Function/global.php
Line
331
errorHandler->error
/index.php
Line
18
require_once

then I updated it to the news version and I got this

SQL Error:1406 - Data too long for column 'useragent' at row 1Query:UPDATE my3_sessions SET uid=0, time=1634085603, location='/forums/index.php', useragent='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36', location1=0, location2=0, nopermission=0 WHERE sid='3e82f56781745acbc7f660af3b091777'

RE: Error 1366 - Incorrect string value: - Matt - 2021-10-13

Again, we need the output of the query noyle posted. That user agent string is 114 characters but the table should allow 200 characters, so should not be erroring. It looks like Installedron has created non-standard tables meaning it will be impossible to support this board (and is one of the reasons I'm against these auto-installers).