Record of SQL Errors Et Cetera

Your opinion is important to us. Please continue to hold. Just kidding: Post your brainstorms here.

Moderator: Sean

User avatar
RJDiogenes
Olympian
Olympian
Posts: 82419
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes »

It will indeed be awesome-- once I learn everything. :lol:
Please visit RJ's Drive-In. :) And read Trunkards. :) And then there's my Heroes Essays at U of R. :)

:grape:
User avatar
Lupine
Imperator
Imperator
Posts: 49487
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine »

I got a SQL error at 3:00 pm Pacific time on 10/13/16.
User avatar
Lupine
Imperator
Imperator
Posts: 49487
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine »

And another at 3:05 :no:
User avatar
RJDiogenes
Olympian
Olympian
Posts: 82419
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes »

I just got one, too. We'll have to let huggle know. She'll be back from her vacation soon.
Please visit RJ's Drive-In. :) And read Trunkards. :) And then there's my Heroes Essays at U of R. :)

:grape:
User avatar
huggle
Primus Pilus Centurion
Primus Pilus Centurion
Posts: 1746
Joined: Mon Sep 19, 2016 4:40 am
Location: Bavaria

Re: Record of SQL Errors Et Cetera

Post by huggle »

back :)
Exactly what error did you get? A screenshot would be ideal, in case the board specified the nature of the error.

Sorry about the long silence - dad's flu viruses thought of starting a colony in a second host and though my immune system is a good deal stronger than his, I still couldn't go online, the prob being that ever since I cracked his way too obvious password, dad has been using a very complicated one so that I can't go online without him switching the machine on first. (Dad thinks: safety first, daughters later :D )

Update on the attachment problem on the new board: it's still 2:1 for the bug. New attachments will be displayed, old ones won't even though they are there. Even my dad is pretty mystified and suspects it might be a server-software related problem. Tomorrow I'll check which software both servers use and if I can't find a vital difference I'll contact Orpheus to see whether he encountered such a problem before.
In the worst case I'll just have to edit the respective posts and re-post the 1400 attachments. That'll take a while but has the advantage to be bound to work.
a hug a day keeps the psychiatrist away
User avatar
RJDiogenes
Olympian
Olympian
Posts: 82419
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes »

huggle wrote:back :)
Welcome back. :)
Exactly what error did you get? A screenshot would be ideal, in case the board specified the nature of the error.
I should have thought to copy the message. I will if it happens again. So far it seems like a couple of isolated cases. :fingerscrossed:
Sorry about the long silence - dad's flu viruses thought of starting a colony in a second host
Aw, I hope you're feeling better. Being sick on vacation is not good. They should give you credit for sick days on vacation.
In the worst case I'll just have to edit the respective posts and re-post the 1400 attachments. That'll take a while but has the advantage to be bound to work.
I hope the worst-case scenario doesn't come to pass. I don't want you to have to do that. If you do, you should teach me how to help.
Please visit RJ's Drive-In. :) And read Trunkards. :) And then there's my Heroes Essays at U of R. :)

:grape:
User avatar
Lupine
Imperator
Imperator
Posts: 49487
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine »

The site seemed to freeze up for a couple of minutes around 8:00 this morning. :unsure:
User avatar
Lupine
Imperator
Imperator
Posts: 49487
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine »

And it just did it again.
User avatar
RJDiogenes
Olympian
Olympian
Posts: 82419
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes »

This morning it froze on me on the redirection screen after I posted. Then I got a DNS error. It's just Yahoo stuff. It seems to be okay now already-- not like the last time when it lasted about three days.
Please visit RJ's Drive-In. :) And read Trunkards. :) And then there's my Heroes Essays at U of R. :)

:grape:
Orpheus
Censor
Censor
Posts: 460
Joined: Sun Nov 08, 2015 2:31 pm

Re: Record of SQL Errors Et Cetera

Post by Orpheus »

I fixed ReNext's [classic] after-post redirect issue some time back. Let me know if the current issue isn't just a Yahoo thing.

Be aware, however, that browsers will increasingly complain/warn that ReNext isn't auto-redirecting http:// urls to https://

Http:// is much less secure than Https://, but ubiquitous Https:// mostly makes it hard for the NSA/etc. to track everyone.

What's the difference? Mostly: browsers now want ReNext to use a (once expensive, now free) AUTHORIZED cert for https://

For 25 years, I (and most other admins) created/signed our own cryptographic certs, except when we needed public trust.

These days, browsers have begun to "protect users" -- and since they don't know every admin/site, they want "known certifiers"

I don't even disagree. It's not a bad idea (even if some "known certifiers" were known to only test if your check to them cleared)
User avatar
RJDiogenes
Olympian
Olympian
Posts: 82419
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes »

We haven't had an actual SQL error in a long while, probably because you fixed that redirect. We've just had the occasional Yahoo awkwardness. I'm not sure if we're going to be https after we move or not. But I do hope that we can upgrade to a software version that will let me embed YouTube videos without editing their https address. :lol:
Please visit RJ's Drive-In. :) And read Trunkards. :) And then there's my Heroes Essays at U of R. :)

:grape:
User avatar
Lupine
Imperator
Imperator
Posts: 49487
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine »

I've been getting quite few SQL errors. So many that it's been hard posting about them here.
User avatar
RJDiogenes
Olympian
Olympian
Posts: 82419
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes »

I've been getting a few, too. I emailed huggle about it. :(
Please visit RJ's Drive-In. :) And read Trunkards. :) And then there's my Heroes Essays at U of R. :)

:grape:
User avatar
huggle
Primus Pilus Centurion
Primus Pilus Centurion
Posts: 1746
Joined: Mon Sep 19, 2016 4:40 am
Location: Bavaria

Re: Record of SQL Errors Et Cetera

Post by huggle »

add another error: your first mail didn't reach me, Rick. I only got the one from today (Thursday) saying all is well again.

Interestingly, the board's own error records claim there hasn't been an error since December 2015.

I just made a backup and shall make new ones at 24 hour intervals at minimum (if possible more often).
The new board still gives me trouble but I think the error there is of a nature we can ignore: an error message is only displayed on the admin control panel but appears to not interfere with the board performance. I'll try to speed up work on the new board and install the daily updates on it so that we'll have a sort of mirror copy ready for use and lose only posts from the last 24 hours in the worst case.

In case this one crashes, from Saturday on the address of the new board will be http://sdg3.com/renext

Feel free to have a look and even log in but please do not post or message there as long as this one exists since your posts on the new board will get wiped out the instant I install the newest backup. Also, if I happen to be working on the board you might encounter errors or the board may even be inaccessible for a while.
a hug a day keeps the psychiatrist away
User avatar
RJDiogenes
Olympian
Olympian
Posts: 82419
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes »

huggle wrote:add another error: your first mail didn't reach me, Rick. I only got the one from today (Thursday) saying all is well again.
That's weird. :conf:
Interestingly, the board's own error records claim there hasn't been an error since December 2015.
That's weirder. :mellow:
The new board still gives me trouble but I think the error there is of a nature we can ignore: an error message is only displayed on the admin control panel but appears to not interfere with the board performance.
Does it interfere with any of the Admin functions?
Feel free to have a look and even log in but please do not post or message there as long as this one exists since your posts on the new board will get wiped out the instant I install the newest backup. Also, if I happen to be working on the board you might encounter errors or the board may even be inaccessible for a while.
It looks a little different. :D
Please visit RJ's Drive-In. :) And read Trunkards. :) And then there's my Heroes Essays at U of R. :)

:grape:
Post Reply