Not Solved Error 1366 - Incorrect string value:
#1
Not Solved
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'
Reply
#2
Not Solved
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.
Reply
#3
Not Solved
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.
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
Reply
#4
Not Solved
I decoded the hex value posted - \xA2\xFD\x81j.  Works out to 0.0.0.0 - which underlines Matt's question. Smile
Reply
#5
Not Solved
(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?
Reply
#6
Not Solved
(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. Smile
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.
[Image: banner.png]
Reply
#7
Not Solved
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
Reply
#8
Not Solved
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
Could be wrong but worth a try.
Reply
#9
Not Solved
(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'
Reply
#10
Not Solved
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).
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)