Error Reports

[GeekMaster]

PLEASE INCLUDE COMPLETE ERROR MESSAGES

[roadstrailstris]

I can't post much of anything anymore. I keep trying to post to the 1st Amendment thread, stripping out any quotes, apostrophe's, italics. Nothing works.

[GeekMaster]

I can't post much of anything anymore. I keep trying to post to the 1st Amendment thread, stripping out any quotes, apostrophe's, italics. Nothing works.

PC. MAC, iphone or Android phone?
Which browser?

[nadra's babydaddy]

It seems to only consistently happen when I try to post in MoS threads, which is probably for the best 

Both PC and iphone.   Just seems to be a quirky glitch since I can usually post in all the other threads with no trouble when it happens.   

[GeekMaster]

PLEASE INCLUDE COMPLETE ERROR MESSAGES

[lamerun]

Database error.

[GeekMaster]

Is that the complete error message?

[GeekMaster]

Please understand that vague errors like "database error" is not helpful.  If that is the complete message that you get then at lease post the time that you got it.

[Arrojo]

Whenever I try something that has the degree symbol I get this error message:

“Please try again. If you come back to this error screen, report the error to an administrator”

So now I just spell out the word degrees as in 70 degrees.

[Arrojo]

Whenever I try something that has the degree symbol I get this error message:

“Please try again. If you come back to this error screen, report the error to an administrator”

So now I just spell out the word degrees as in 70 degrees.

And then I couldn’t even post that message above in your thread. I originally was able to post it in the error reply thread that Eco Ellen started. But when I copied that message and tried to paste it into a new reply to this thread I got the exact same error message as above.

Perhaps it has something to do with copy/paste using safari?

Test: 70°

This works fine in Tapatalk

[Chris the Wheeler]

Okay,  Now I'm getting an error when  trying to report my error in the ERROR REPORTS thread

Sorry to start another error thread put it here.  But I couldn't post in the Error Reports thread. 



I've been trying to post in a thread that I started.  I keep getting the same error.  2 days now.


Here is what I'm posting in the Time Travel thread that I started:   

jamers quote  But my answer is boring.  Id like to see my grandparents as children

I understand that  Not so boring I'd probably go back and get to meet my grandfather  He was a North Atlantic Fisherman  Went over the side in bad weather  They never recovered him   My grandmother  always said I had the same sense of humor as him   I'd love to have a pint of two and crack each other up

Here's what I get

Please try again. If you come back to this error screen, report the error to an administrator.
Back

[Chris the Wheeler]

I had to strip out all the punctuation to get my report to post

[nadra's babydaddy]

quack quack

[GeekMaster]

And then I couldn't even post that message above in your thread. I originally was able to post it in the error reply thread that Eco Ellen started. But when I copied that message and tried to paste it into a new reply to this thread I got the exact same error message as above.

Perhaps it has something to do with copy/paste using safari?

Test: 70d

This works fine in Tapatalk

How about if the degree symbol is converted to a lower case 'd'?

[Arrojo]

How about if the degree symbol is converted to a lower case 'd'?

Yes you can just spell it out. 70 degrees.

[GeekMaster]

Yes you can just spell it out. 70 degrees.

Of course.  But if someone forgets, the d will replace it.

[radial]

It's not just apostrophes and degree symbols.  There's a whole host of other characters that trigger the database error condition.  Can't help but think there's some character set based misconfiguration at the root of this.  Fix that root cause, and all of these glitches will disappear. 

[GeekMaster]

It's not just apostrophes and degree symbols.  There's a whole host of other characters that trigger the database error condition.  Can't help but think there's some character set based misconfiguration at the root of this.  Fix that root cause, and all of these glitches will disappear.

I have read descriptions of how to attempt such a fix and it hurt my head.  Not something that I want to do.

Sent from my SM-G975U using Tapatalk

[radial]

I have read descriptions of how to attempt such a fix and it hurt my head.  Not something that I want to do.

My head too!  I used to know a thing or two about web server administration, scripting, and backend database management, but my fevered brain moved on to other things and I'm way out of that loop now.  trotter seems to know a thing or two about this stuff and is apparently on summer break.  Seems like a nice pro bono opportunity.  Maybe you should read him in and see if he can figure out a more elegant solution. 

[Arrojo]

I attempted to post this in the am I an a$$hole thread:

You’re the mom here. Mother’s Day is for to do as you see fit. Scout is the a$$hole.

Got the same old message:

Please try again. If you come back to this error screen, report the error to an administrator

[Arrojo]

I was however just able to post it using Tapatalk. That appears to be the workaround.

[Arrojo]

Same thing just happened posting in another thread. There are no weird symbols or anything like that. It’s just the standard same error message that is resolved by using Tapatalk

[GeekMaster]

I attempted to post this in the am I an a$$hole thread:

You're the mom here. Mother's Day is for to do as you see fit. Scout is the a$$hole.

Got the same old message:

Please try again. If you come back to this error screen, report the error to an administrator

The problem is that the error message tells us nothing about what went wrong and there are no entries in the forum's error log.

If you could send the exact failing post that you tried to webmaster@chrunners.net I will take a look at it.

[Trotter]

My head too!  I used to know a thing or two about web server administration, scripting, and backend database management, but my fevered brain moved on to other things and I'm way out of that loop now.  trotter seems to know a thing or two about this stuff and is apparently on summer break.  Seems like a nice pro bono opportunity.  Maybe you should read him in and see if he can figure out a more elegant solution. 

Mike, I'm not a SMF pro, but I do dev work in PHP and open-source SQL databases, so I might be able to help with the charset mismatch thing. But I totally get it if you'd rather not have a hacky dude poking around, especially when you've looked into this way more and with a more knowing eye than I have & have gotten things pretty settled with the string replaces. But my messages and email are open.

[GeekMaster]

I appreciate it Trotter.

What I am currently doing is for every known character problem I am having the code change it to a substitute that does not throw an error.

I just discovered how to do it for the thread title.  In fact, I believe that the degree symbol issue is solved.

[Ergonomic Mouse]

quack quack

same for me

[GeekMaster]

Most of the posting errors seem to be due to characters that cannot be handled by the database.

My task now is to discover the actual characters and intercept them before the post is inserted into the DB.  The latest one that I found thanks to Arrojo is a type of right quotation with the decimal code of 8217.  It should now be converted to a standard single quote.

[Trotter]

Mike, the common thread here is that error happens when someone tries to post something involving a UTF-8 character that doesn't overlap with the ISO-8859-1 set. And it looks like it gets resolved when you swap in a ISO-8859-1 character.

But this doesn't mean the database can't handle UTF-8. The fact that folks can bypass the troubles by using Tapatalk confirms this. So the problem's happening because the SMF encoding isn't harmonizing with the database encoding.

Check the database encoding charset. According to the site's HTML and JS files, the site is telling every user's browser to expect ISO-8859-1 characters. That's SMF's default, for old school legacy reasons. But if you're using an updated MySQL database, the charset might well be set to UTF-8 by default. If there's a mismatch, that might be the root of the problem. The system is behaving like there's some funky double encoding going on, which is messing up input escaping & causing the database to reject inserts.

If there's a charset mismatch, I would think that you can get well down the path to repairing it by converting the charset to UTF-8, which the SMF folks discuss here: https://wiki.simplemachines.org/smf/UTF-8_Readme. If the DB is already using UTF-8, you wouldn't need or want to convert it again.

[GeekMaster]

Mike, the common thread here is that error happens when someone tries to post something involving a UTF-8 character that doesn't overlap with the ISO-8859-1 set. And it looks like it gets resolved when you swap in a ISO-8859-1 character.

But this doesn't mean the database can't handle UTF-8. The fact that folks can bypass the troubles by using Tapatalk confirms this. So the problem's happening because the SMF encoding isn't harmonizing with the database encoding.

Check the database encoding charset. According to the site's HTML and JS files, the site is telling every user's browser to expect ISO-8859-1 characters. That's SMF's default, for old school legacy reasons. But if you're using an updated MySQL database, the charset might well be set to UTF-8 by default. If there's a mismatch, that might be the root of the problem. The system is behaving like there's some funky double encoding going on, which is messing up input escaping & causing the database to reject inserts.

If there's a charset mismatch, I would think that you can get well down the path to repairing it by converting the charset to UTF-8, which the SMF folks discuss here: https://wiki.simplemachines.org/smf/UTF-8_Readme. If the DB is already using UTF-8, you wouldn't need or want to convert it again.

Not happening.

[nadra's babydaddy]

Got the same one I screenshotted above while attempting to quote a post.  Removed the quote and it posted fine. 

[rocketgirl]

Not an error report, but why am I getting subscribed to topics?  I'm not actively choosing this and I'm getting a bunch of notification emails for "topics I've subscribed to".

[radial]

I can't see my sent messages.  Just get the database error screen when I try.

[GeekMaster]

I can't see my sent messages.  Just get the database error screen when I try.

Try it again.

[radial]

Try it again.

Works now, thank you!

[GeekMaster]

Not an error report, but why am I getting subscribed to topics?  I'm not actively choosing this and I'm getting a bunch of notification emails for "topics I've subscribed to".

If you look at your Profile->Notifications you will see 23 pages of topics to which you are subscribed.  You can un-notify individually or a page at a time.

[GeekMaster]

Works now, thank you!

The forum Error Log had multiple entries with your name on them like this:

Database Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'chrunners.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT MAX(pm.id_pm) AS id_pm, pm.id_pm_head
FROM smf_personal_messages AS pm
WHERE pm.id_member_from = 1782
AND pm.deleted_by_sender = 0
GROUP BY pm.id_pm_head
ORDER BY pm.id_pm DESC
LIMIT 0, 20

I changed this setting: sql_mode=only_full_group_by.  But why you got the error and I don't is a mystery.

[nadra's babydaddy]

There's something quirky with the members list.  It looks like a good chunk of it was copied twice. And when you try to search for members by letter, it pulls up a different part of the list (i.e. searching for usernames beginning with K pulls up Y, Z, and then back to A).  They're all in there in one place or another though.

[GeekMaster]

There's something quirky with the members list.  It looks like a good chunk of it was copied twice. And when you try to search for members by letter, it pulls up a different part of the list (i.e. searching for usernames beginning with K pulls up Y, Z, and then back to A).  They're all in there in one place or another though.

I am not seeing that behavior.  There are 39 pages of members and I do not see any dupes.  If I search by a single letter all members with that letter in their name are displayed.

[Trotter]

Mike, there are no error messages about this, but a bunch of posts are getting cut off. You can just look at recent posts in the vaccination thread and some others to see examples of this. I've had issues with it for over a week, and it looks like others have as well.

The common denominator is that people use a character outside the ISO-8859-1 set (and this often seems to be happening when people quote a user who posted something from Tapatalk or paste something from an outside source), and then the rest of what they wrote gets escaped, so the post only contains their text up to the character that caused the glitch.

For me, this has sometimes happened even when I just use a comma in a browser (whether Chrome or iOS Safari). But not always. This post has commas and, if you're reading it, it still worked.

So it looks like, rather than replacing the non-ISO-8859-1 character, the code is just escaping the post.

Some examples of posts where this happened today. There are a bunch of other examples as well; all have the same characteristics:

http://chrunners.net/forum/index.php?topic=127337.msg3434400#msg3434400 (the character that caused the cutoff was an angled quotation mark in the quoted post, which came from Tapatalk; scroll down in the thread to see it happen when MM tries to quote the same post)

http://chrunners.net/forum/index.php?topic=127337.msg3434526#msg3434526 (post cuts off when I used a comma)

http://chrunners.net/forum/index.php?topic=127523.msg3434277#msg3434277 (cutoff happened when poster tried to paste an article)

[tazawa]

I was just going to post what Trotter posted without the knowledge or insight. Just that I can't see things people are cutting and pasting (including my own once it's posted).

[Honey Badger]

Your session timed out while posting. Please try to resubmit your post.


I first wrote this error message in quotes and it ended up being a blank post.
I was trying to post in the How's your mood? thread.
I'd refreshed prior. I exited the app and retried multiple times


My mood is really fucking shitty BTW. That was my response. 😡

[GeekMaster]

"Your session timed out while posting. Please try to resubmit your post."


I don't see any messages about this in the Forum error log. If it is a one-time glitch the problem could be anywhere from your browser to the internet to the forum server.


Please let me know as soon as possible if it happens again.

[Honey Badger]

After posting the above I tried again and it took

[Honey Badger]

PC. MAC, iphone or Android phone?
Which browser?

iphone
Safari

[rocketgirl]

I am unable to PM some members except from the search members screen where I click on the profile and then click send message.

If I type their username in and hit "enter" from the create message in the Personal Message section, I get this message:

The following error or errors occurred while posting this message:
One or more 'to'-recipients could not be found.

Some people will populate, like Suesquatch.  Some give me the error message, like Jamers or Batty.


ETA this is from Chrome browser on laptop, not TapaTalk.

[Honey Badger]

I'm getting the same timeout error as above again.
I'm on my iPhone using safari

[Eco Ellen]

I've been having consistent issues with quotation marks. I post from iPhone via safari. When I use quotation marks everything after the quotation mark disappears. So if I start a post with Quotes then the post shows up empty. I've seen it happen to other people as well.

[Eco Ellen]

Also just happened so  try h single quotation mark/apostrophe?

[GeekMaster]

Stop using safari? Use different quotation marks. Don't use quotation marks?

I don't think that there is anything else that I can do about this.

[Eco Ellen]

Ok. I just thought you should know. (It is not just happening to me, I have noticed.)

Thanks for everything you do!

E

[rocketgirl]

I am unable to PM some members except from the search members screen where I click on the profile and then click send message.

If I type their username in and hit "enter" from the create message in the Personal Message section, I get this message:

The following error or errors occurred while posting this message:
One or more 'to'-recipients could not be found.

Some people will populate, like Suesquatch.  Some give me the error message, like Jamers or Batty.

ETA this is from Chrome browser on laptop, not TapaTalk.

Fionn is having the same issue.  Also I tried Tapatalk and the same people I can't populate in Chrome, I can't populate in TapaTalk either.  (I don't get an error in TapaTalk; it just won't send, or if it's a group, it won't send to everyone). 
My theory is that it's people who have changed their names (i.e. Jamers) and those who have a multiple word username (i.e. Mom of Scooby).

[GeekMaster]

I'm finding that typing the entire multi-word name works. As for other instances like Jamers, the user name and display name are different. Using the username "jamers86" works.

This is weird and definitely calls for further research.

[Trotter]

Test §§§§§