CelticWomanForum.com

Everything Else => Forum Questions & Comments => Topic started by: aislin on November 05, 2016, 09:10AM



Title: Database Error Last Night & This Morning
Post by: aislin on November 05, 2016, 09:10AM
Hi all,

I got an email last night from a member saying they were seeing a database error,  I was on my phone and tried the site... and didn't see the error so I thought the error had probably sorted itself out. (You'd be surprised how often that is the case.) I was looking into it this morning and was able to reproduce the error as well as get the forum to give me the error information.

Basically? It wasn't a database error. Thanks super misleading message! An anti-spammer add on that the forum has been using for years apparently errored out. I'm not entirely sure why, but I uninstalled it and everything now appears to be back to normal.

If you want the long technical explanation, we were using a honey pot as a first level filter for spammers. We don't actually store the honey pot database, it is all run through a large repository that many websites and developers use and contribute to. Something somewhere either in the add on's code or on the repository's database intake system, caused the program to error out because it didn't like the input the add on was sending it. Why it couldn't have just submitted this into the forum error log and not cause EVERYONE to see it, I don't know. It's not world endingly important to the forum's operation, it just helps stop 200 random bots from China from suddenly being on the forum all at once. I may poke at it tonight or try to reinstall it and see what happens, or I may just see how we do without it.

aislin


Title: Re: Database Error Last Night & This Morning
Post by: Emer Dreamer on November 05, 2016, 09:15AM
 Thanks  Lindsey. I  thought  there  was  something  maybe  wrong  with  my computer. I'm glad  this  is  not  the  case  and I'm  glad  you  got  it  sorted  out.    :)


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 05, 2016, 04:07PM
I've been getting errors posting most of the day.

A common one is:

"Session verification failed. Please try logging out and back in again, and then try again."

 If I try logging out, I also get an error.

I flushed my browser cache and it appears to be working fine for the moment.


Title: Re: Database Error Last Night & This Morning
Post by: aislin on November 05, 2016, 10:31PM
CWazyTom,

A session verification error is almost universally the sign of a bad cookie. Basically, the login info stored in your cookie is corrupted in some way or was malformed last time it was updated. As you've cleared your cache (and probably your cookies in the process) you shouldn't see anymore errors.

If you start seeing any other errors, please let me know.

aislin


Title: Re: Database Error Last Night & This Morning
Post by: Jim M. on November 06, 2016, 12:18PM
I have 2 laptops which WERE working fine for the forum, but NOW don't.  I can't get anything.  Both were using Internet Explorer. 
I recently put Google Chrome on this one and it took me here on the first try.  I'm not a computer guy so I don't know why it works this way. ???
My tablet has Chrome and it let me on the forum, also, but with a small touch screen and large fingers it is hard to navigate the pages.


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 06, 2016, 01:04PM
I have 2 laptops which WERE working fine for the forum, but NOW don't.  I can't get anything.  Both were using Internet Explorer.  
I recently put Google Chrome on this one and it took me here on the first try.  I'm not a computer guy so I don't know why it works this way. ???
My tablet has Chrome and it let me on the forum, also, but with a small touch screen and large fingers it is hard to navigate the pages.

Hey Jim,

When you're using Internet Explorer, what's happening. Blank page? Error message?

I take it the problem is still happening on Internet Explorer after clearing the browser cache / cookies?

Do you have a mobile device or computer that has an Internet Explorer instance that hasn't been to the forum before? I suspect that will work. Internet Explorer works for me.


Title: Re: Database Error Last Night & This Morning
Post by: Jim M. on November 06, 2016, 01:22PM
I get an error message.  "Website down for mtce. or server problem".
I don't know how to clear the browser cache.  IE will not let me go to the forum.
All my computers have been on the forum before.


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 06, 2016, 02:14PM
I get an error message.  "Website down for mtce. or server problem".
I don't know how to clear the browser cache.  IE will not let me go to the forum.
All my computers have been on the forum before.


The steps differ a bit depending on the version of Internet Explorer, but here's one set of steps (there are probably better ones somewhere):
https://kb.wisc.edu/page.php?id=15141

If the steps above aren't working out because the settings and menus are in different spots, I can probably find more accurate steps knowing the version of Internet Explorer you're running:
https://www.lifewire.com/what-version-of-internet-explorer-do-i-have-2617990



Title: Re: Database Error Last Night & This Morning
Post by: Jim M. on November 06, 2016, 02:52PM
OK, thank you.  I will try them later. :)


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 08, 2016, 11:20PM
I'm still getting session verification errors frequently.

It seems to happen most often if I try to quote a post or Mark a post unread. It happens when replying to posts too, although sometimes I can reply when I can neither mark a post unread or quote the post.

It's been happening in multiple browsers and on multiple mobile and desktop devices this week.

Flushing the cache and cookies, then re-launching the browser works consistently as a workaround, but the issue does seem to re-occur after a few hours within the same browser for which the workaround was applied.

Anyone else running into this?


Title: Re: Database Error Last Night & This Morning
Post by: Jim M. on November 08, 2016, 11:25PM
Yes :(


Title: Re: Database Error Last Night & This Morning
Post by: Emer Dreamer on November 08, 2016, 11:56PM
Yes :(
ME  ... very  frequently ...    :(


Title: Re: Database Error Last Night & This Morning
Post by: Jim M. on November 09, 2016, 07:33PM
I have now added Google Chrome to the 2 laptops I use the most.  This seems to be the only way I can access the forum.


Title: Re: Database Error Last Night & This Morning
Post by: Emer Dreamer on November 09, 2016, 07:34PM
I have now added Google Chrome to the 2 laptops I use the most.  This seems to be the only way I can access the forum.
I found  that  if  I  hit  "preview"  first, then the bug  works  itself  out. I have  chrome  as  well.    :-\


Title: Re: Database Error Last Night & This Morning
Post by: Jim M. on November 09, 2016, 07:38PM
My oldest laptop -- 11+ years old with Windows XP -- still goes to the forum with no problem (with IE).
My 2 newer laptops both have Windows 7. ???


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 09, 2016, 09:43PM
Tonight, when replying on the hug thread, I kept getting a message that my session had expired whole posting the message.

This time, cache/cookie flushing and re-launching the browser didn't do the trick. I tried reposting a bunch of times (15 times, perhaps) and eventually the post went through.


Title: Re: Database Error Last Night & This Morning
Post by: Emer Dreamer on November 09, 2016, 10:07PM
Tonight, when replying on the hug thread, I kept getting a message that my session had expired whole posting the message.

This time, cache/cookie flushing and re-launching the browser didn't do the trick. I tried reposting a bunch of times (15 times, perhaps) and eventually the post went through.
Yep...  For  me,  hitting  the  Preview  button  helped clear  it.


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 14, 2016, 05:40PM
This being a session-related issue, I disabled the setting to always keep me logged in.

No problems since then. ;)


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 19, 2016, 10:43PM
It seems a new difficulty is cropping up.

I have my login timeout set to 60 minutes, but it seems my sessions are sometimes expiring before that.

When I try to post, I get an error that I'm not authorized to post or that I should refresh the page and re-post.

If I try to post again, I sometimes get prompted to log in.

Then, once I log in, I get an error that I've already submitted the post and that I might have resubmitted in error.

If I copy my unsaved text, navigate to a different topic, then back to the one I was trying to post in, I can see that it hasn't actually submitted the post. So I past my text and submit it again. The post usually goes through successfully at that point.


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 20, 2016, 10:21AM
I sometimes get the following error too, even when I wasn't in the process of composing a post at the time my session timed out:

Your session timed out while posting. Please try to re-submit your message.
No subject was filled in.
The message body was left empty.


This stuff all started around the same time as the database errors. There's definitely something different than before.


Title: Re: Database Error Last Night & This Morning
Post by: Maloney on November 20, 2016, 08:12PM
me too   several times.......


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on November 21, 2016, 10:49PM
For people still getting session errors, here's a summary of the steps that worked for me:

(1) Clear the browser cache and cookies in any browser you use to access the form (most importantly, clear the browser cache in the one you're going to log out from).
(2) Close and re-open that browser.
(3) Go back to the forum.
(4) Log out.
(5) Press the login button on the menu bar (next to the Register button, not the spot where you actually put the username and password in),
(6) Uncheck the box that says "Always stay logged in"
(7) Now log in.

That fixed most of the errors for me.

NOTE: You'll likely have to log back in to any other sites you were logged in to before clearing your browser cookies. It will make your browser forget about what it was logged in to before as well as potentially some other preferences for sites that use cookies to store that information about you.

If you only flush the browser cache / cookies, it will fix the problem only temporarily. It will come back shortly. You also have to uncheck "Always stay logged in."

It's almost like the forum is expiring sessions in a different way than before but the browser doesn't know it, so if you leave it logged in all the time, your session expires and gives you errors, even logging out (you can't log out of a session if the session you were logged in with isn't valid anymore ;) )

Even after the workaround above, there are still some weird errors happening to me. For example, if I leave my browser open and logged in to the forum, whether I'm in the process of composing / editing a post or not, it sometimes starts a chain of errors. The good news is that those errors will clear up if you just refresh the page (hopefully you weren't in the process of posting anything at the time).

Hopefully this helps, everyone.


Title: Re: Database Error Last Night & This Morning
Post by: CWazyTom on December 06, 2016, 09:58PM
I haven't had any more weird errors in a while.

How's everyone else doing?