HST Community      SQL Error messages today

SQL Error messages today | High Sierra Topix  

SQL Error messages today

Instead of emailing or messaging the Admins or Mods with technical support questions or comments about the site, we prefer you check here to see if someone else has had the same difficulty or has made the same suggestion. What you're after might have already been posted and addressed here or within the FAQ. If not, please post a detailed description of the problem/suggestion and someone from the HST team will address your needs shortly. If you can't login/post and are unable to reset your password on your own, you may contact us directly.

SQL Error messages today

Postby Jimr » Tue Jul 18, 2017 11:08 am

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.
Love is blind, but marriage is a real eye opener.



User avatar
Jimr
Forums Moderator
Forums Moderator
 
Posts: 1729
Joined: Fri Jul 31, 2009 2:14 pm
Location: Redondo Beach
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby Jimr » Tue Jul 18, 2017 11:10 am

It happens when I submit a post, but the post goes through.
Love is blind, but marriage is a real eye opener.
User avatar
Jimr
Forums Moderator
Forums Moderator
 
Posts: 1729
Joined: Fri Jul 31, 2009 2:14 pm
Location: Redondo Beach
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby rlown » Tue Jul 18, 2017 11:19 am

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.
User avatar
rlown
Topix Junkie
 
Posts: 6695
Joined: Thu Oct 25, 2007 5:00 pm
Location: Petaluma, CA
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby maverick » Tue Jul 18, 2017 11:41 am

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()
Professional Sierra Landscape Photographer

I don't give out specific route information, my belief is that it takes away from the whole adventure spirit of a trip, if you need every inch planned out, you'll have to get that from someone else.

Have a safer backcountry experience by using the HST ReConn Form 2.0, named after Larry Conn, a HST member: http://reconn.org
User avatar
maverick
Forums Moderator
Forums Moderator
 
Posts: 9739
Joined: Thu Apr 06, 2006 5:54 pm
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby copeg » Tue Jul 18, 2017 12:08 pm

Looking into it...but don't see any errors myself at the moment so hard to diagnose
User avatar
copeg
Founding Member & Forums Administrator
Founding Member & Forums Administrator
 
Posts: 2011
Joined: Fri Oct 28, 2005 9:25 pm
Location: Menlo Park, CA
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby ERIC » Tue Jul 18, 2017 12:23 pm

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.
New members, please consider giving us an intro!
Follow us on Twitter @HighSierraTopix. Use hashtags #SIERRAPHILE #GotSierra? #GotMountains?
Follow us on Facebook: https://www.facebook.com/HighSierraTopix
User avatar
ERIC
HS Topix Owner & Forums Administrator
HS Topix Owner & Forums Administrator
 
Posts: 3122
Joined: Fri Oct 28, 2005 9:13 am
Location: between the 916 and 661
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby copeg » Tue Jul 18, 2017 12:27 pm

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...
User avatar
copeg
Founding Member & Forums Administrator
Founding Member & Forums Administrator
 
Posts: 2011
Joined: Fri Oct 28, 2005 9:25 pm
Location: Menlo Park, CA
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby ERIC » Tue Jul 18, 2017 12:34 pm

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.
New members, please consider giving us an intro!
Follow us on Twitter @HighSierraTopix. Use hashtags #SIERRAPHILE #GotSierra? #GotMountains?
Follow us on Facebook: https://www.facebook.com/HighSierraTopix
User avatar
ERIC
HS Topix Owner & Forums Administrator
HS Topix Owner & Forums Administrator
 
Posts: 3122
Joined: Fri Oct 28, 2005 9:13 am
Location: between the 916 and 661
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby Jimr » Tue Jul 18, 2017 12:39 pm

Testing


Edit: no errors reported.
Love is blind, but marriage is a real eye opener.
User avatar
Jimr
Forums Moderator
Forums Moderator
 
Posts: 1729
Joined: Fri Jul 31, 2009 2:14 pm
Location: Redondo Beach
Experience: Level 4 Explorer

Re: SQL Error messages today

Postby ERIC » Tue Jul 18, 2017 12:58 pm

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?
New members, please consider giving us an intro!
Follow us on Twitter @HighSierraTopix. Use hashtags #SIERRAPHILE #GotSierra? #GotMountains?
Follow us on Facebook: https://www.facebook.com/HighSierraTopix
User avatar
ERIC
HS Topix Owner & Forums Administrator
HS Topix Owner & Forums Administrator
 
Posts: 3122
Joined: Fri Oct 28, 2005 9:13 am
Location: between the 916 and 661
Experience: Level 4 Explorer

Next

Return to Website Technical Problems, Questions, Comments & Suggestions



Who is online

Users browsing this forum: No registered users and 1 guest