Page 1 of 2
SQL Error messages today
Posted: Tue Jul 18, 2017 11:08 am
by Jimr
I've gotten this several times this morning. Anyone else experiencing this?
General Error
SQL ERROR [ mysql4 ]
Data too long for column 'config_value' at row 1 [1406]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 11:10 am
by Jimr
It happens when I submit a post, but the post goes through.
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 11:19 am
by rlown
That is why WD multiple posted in backpacking and just now I saw the same error on the conditions forum. SQL error row 1 or something like that. I couldn't capture it but I could probably reproduce it by posting another reply.
Rule of thumb for now should be scroll up a bit to see if it posted. There is a message that pops up that says "You cant post so soon after your last post." That is the key that it did post, and you should just go back to board index. copy your post so you can repost if things go really bad.
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 11:41 am
by maverick
This is the message I got when trying to post on the first try.
General Error
SQL ERROR [ mysql4 ]
Data too long for column 'config_value' at row 1 [1406]
SQL
UPDATE phpbb3_config SET config_value = 'a:9:{i:0;i:3;i:1;i:300;i:2;i:1;i:3;s:184:\"<html>\r\n<head><title>500 Internal Server Error</title></head>\r\n<body bgcolor=\"white\">\r\n<center><h1>500 Internal Server Error</h1></center>\r\n<hr><center>nginx</center>\r\n</body>\r\n</html>\";i:4;a:2:{i:0;i:1500402836;i:1;i:1500403129;}i:5;i:0;i:6;i:0;i:7;i:600;i:8;b:1;}' WHERE config_name = 'tapatalk_push_slug'
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()
FILE: [ROOT]/includes/db/mysql.php
LINE: 193
CALL: dbal->sql_error()
FILE: [ROOT]/includes/functions.php
LINE: 160
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/mobiquo/push/TapatalkPush.php
LINE: 37
CALL: set_config()
FILE: [ROOT]/mobiquo/push/TapatalkBasePush.php
LINE: 159
CALL: TapatalkPush->set_push_slug()
FILE: [ROOT]/mobiquo/push/TapatalkPush.php
LINE: 337
CALL: TapatalkBasePush->do_push_request()
FILE: [ROOT]/mobiquo/push/TapatalkPush.php
LINE: 159
CALL: TapatalkPush->push()
FILE: [ROOT]/mobiquo/hook/functions_posting_hook.php
LINE: 20
CALL: TapatalkPush->doPushReply()
FILE: [ROOT]/includes/functions_posting.php
LINE: 2726
CALL: include('[ROOT]/mobiquo/hook/functions_posting_hook.php')
FILE: [ROOT]/posting.php
LINE: 1186
CALL: submit_post()
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 12:08 pm
by copeg
Looking into it...but don't see any errors myself at the moment so hard to diagnose
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 12:23 pm
by ERIC
Thanks for reporting this here. maverick provided me with the full error which seems to be coming from Tapatalk:
Code: Select all
General Error
SQL ERROR [ mysql4 ]
Data too long for column 'config_value' at row 1 [1406]
SQL
UPDATE phpbb3_config SET config_value = 'a:9:{i:0;i:3;i:1;i:300;i:2;i:1;i:3;s:184:\"<html>\r\n<head><title>500 Internal Server Error</title></head>\r\n<body bgcolor=\"white\">\r\n<center><h1>500 Internal Server Error</h1></center>\r\n<hr><center>nginx</center>\r\n</body>\r\n</html>\";i:4;a:2:{i:0;i:1500402836;i:1;i:1500403129;}i:5;i:0;i:6;i:0;i:7;i:600;i:8;b:1;}' WHERE config_name = 'tapatalk_push_slug'
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()
FILE: [ROOT]/includes/db/mysql.php
LINE: 193
CALL: dbal->sql_error()
FILE: [ROOT]/includes/functions.php
LINE: 160
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/mobiquo/push/TapatalkPush.php
LINE: 37
CALL: set_config()
FILE: [ROOT]/mobiquo/push/TapatalkBasePush.php
LINE: 159
CALL: TapatalkPush->set_push_slug()
FILE: [ROOT]/mobiquo/push/TapatalkPush.php
LINE: 337
CALL: TapatalkBasePush->do_push_request()
FILE: [ROOT]/mobiquo/push/TapatalkPush.php
LINE: 159
CALL: TapatalkPush->push()
FILE: [ROOT]/mobiquo/hook/functions_posting_hook.php
LINE: 20
CALL: TapatalkPush->doPushReply()
FILE: [ROOT]/includes/functions_posting.php
LINE: 2726
CALL: include('[ROOT]/mobiquo/hook/functions_posting_hook.php')
FILE: [ROOT]/posting.php
LINE: 1186
CALL: submit_post()
Greg, I'm also noticing that on the mobile version the menu isn't showing up. I was about to submit a support ticket to the host before seeing the above error message. Looking into whether or not there's anything of interest on the Tapatalk website.
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 12:27 pm
by copeg
Eric, did you disable tapatalk recently? Still looks to be 'push' code in the posting file...
Edit:
Greg, I'm also noticing that on the mobile version the menu isn't showing up.
I see that (or don't see it as the case may be) as well...
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 12:34 pm
by ERIC
Yes, sort of. I disabled in the test area before realizing I hadn't updated the config file to point to the test DB. Tapatalk has been reactivated. Let's see if that makes any difference.
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 12:39 pm
by Jimr
Testing
Edit: no errors reported.
Re: SQL Error messages today
Posted: Tue Jul 18, 2017 12:58 pm
by ERIC
copeg wrote:I see that (or don't see it as the case may be) as well...
Think it could have anything to do with uninstalling MODs?