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.
User avatar
Jimr
Forums Moderator
Forums Moderator
Posts: 2175
Joined: Fri Jul 31, 2009 2:14 pm
Experience: Level 4 Explorer
Location: Torrance

SQL Error messages today

Post 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.
If you don't know where you're going, then any path will get you there.
User avatar
Jimr
Forums Moderator
Forums Moderator
Posts: 2175
Joined: Fri Jul 31, 2009 2:14 pm
Experience: Level 4 Explorer
Location: Torrance

Re: SQL Error messages today

Post by Jimr »

It happens when I submit a post, but the post goes through.
If you don't know where you're going, then any path will get you there.
User avatar
rlown
Topix Docent
Posts: 8225
Joined: Thu Oct 25, 2007 5:00 pm
Experience: Level 4 Explorer
Location: Wilton, CA

Re: SQL Error messages today

Post 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.
User avatar
maverick
Forums Moderator
Forums Moderator
Posts: 11821
Joined: Thu Apr 06, 2006 5:54 pm
Experience: Level 4 Explorer

Re: SQL Error messages today

Post 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()
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
copeg
Founding Member & Forums Administrator
Founding Member & Forums Administrator
Posts: 2109
Joined: Fri Oct 28, 2005 9:25 pm
Experience: Level 4 Explorer
Location: Menlo Park, CA
Contact:

Re: SQL Error messages today

Post by copeg »

Looking into it...but don't see any errors myself at the moment so hard to diagnose
User avatar
ERIC
Your Humble Host & Forums Administrator
Your Humble Host & Forums Administrator
Posts: 3254
Joined: Fri Oct 28, 2005 9:13 am
Experience: Level 4 Explorer
Location: between the 916 and 661

Re: SQL Error messages today

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

Re: SQL Error messages today

Post 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...
User avatar
ERIC
Your Humble Host & Forums Administrator
Your Humble Host & Forums Administrator
Posts: 3254
Joined: Fri Oct 28, 2005 9:13 am
Experience: Level 4 Explorer
Location: between the 916 and 661

Re: SQL Error messages today

Post 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.
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
Jimr
Forums Moderator
Forums Moderator
Posts: 2175
Joined: Fri Jul 31, 2009 2:14 pm
Experience: Level 4 Explorer
Location: Torrance

Re: SQL Error messages today

Post by Jimr »

Testing


Edit: no errors reported.
If you don't know where you're going, then any path will get you there.
User avatar
ERIC
Your Humble Host & Forums Administrator
Your Humble Host & Forums Administrator
Posts: 3254
Joined: Fri Oct 28, 2005 9:13 am
Experience: Level 4 Explorer
Location: between the 916 and 661

Re: SQL Error messages today

Post 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?
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
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests