Posts: 6
Threads: 3
Joined: Mar 2019
Reputation:
0
2021-10-10, 10:15 PM
(This post was last modified: 2021-10-10, 10:16 PM by MrBASins. Edited 1 time in total.)
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'
Posts: 607
Threads: 14
Joined: Oct 2019
Reputation:
34
2021-10-11, 12:08 PM
(This post was last modified: 2021-10-11, 12:23 PM by nixer55. Edited 1 time in total.)
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.
Posts: 37,500
Threads: 399
Joined: Apr 2008
Reputation:
773
2021-10-11, 12:42 PM
(This post was last modified: 2021-10-11, 12:42 PM by Matt.)
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.
Posts: 607
Threads: 14
Joined: Oct 2019
Reputation:
34
2021-10-11, 01:54 PM
I decoded the hex value posted - \xA2\xFD\x81j. Works out to 0.0.0.0 - which underlines Matt's question. 
Posts: 6
Threads: 3
Joined: Mar 2019
Reputation:
0
2021-10-11, 04:24 PM
(This post was last modified: 2021-10-11, 05:20 PM by MrBASins. Edited 11 times in total.)
(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?
Posts: 4,231
Threads: 113
Joined: Jan 2006
Reputation:
110
2021-10-12, 08:05 AM
(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.
Posts: 607
Threads: 14
Joined: Oct 2019
Reputation:
34
2021-10-12, 11:26 AM
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. 
Posts: 858
Threads: 43
Joined: Aug 2019
Reputation:
76
2021-10-12, 07:34 PM
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
Posts: 6
Threads: 3
Joined: Mar 2019
Reputation:
0
2021-10-13, 12:23 AM
(This post was last modified: 2021-10-13, 12:41 AM by MrBASins. Edited 5 times in total.)
(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'
Posts: 37,500
Threads: 399
Joined: Apr 2008
Reputation:
773
2021-10-13, 10:54 AM
(This post was last modified: 2021-10-13, 10:54 AM by Matt.)
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).
|
