Record of SQL Errors Et Cetera

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

Moderator: Sean

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Fri Oct 30, 2015 9:27 pm

It will indeed be awesome-- once I learn everything. :lol:
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Re: Record of SQL Errors Et Cetera

Postby Lupine » Thu Oct 13, 2016 10:01 pm

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

Re: Record of SQL Errors Et Cetera

Postby Lupine » Thu Oct 13, 2016 10:05 pm

And another at 3:05 :no:
User avatar
Lupine
Consul
Consul
 
Posts: 27347
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Thu Oct 13, 2016 10:12 pm

I just got one, too. We'll have to let huggle know. She'll be back from her vacation soon.
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Re: Record of SQL Errors Et Cetera

Postby huggle » Fri Oct 14, 2016 3:34 pm

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
huggle
Censor
Censor
 
Posts: 738
Joined: Mon Sep 19, 2016 4:40 am
Location: Bavaria

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Fri Oct 14, 2016 9:40 pm

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 My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Re: Record of SQL Errors Et Cetera

Postby Lupine » Fri Dec 09, 2016 4:01 pm

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

Re: Record of SQL Errors Et Cetera

Postby Lupine » Fri Dec 09, 2016 4:05 pm

And it just did it again.
User avatar
Lupine
Consul
Consul
 
Posts: 27347
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Fri Dec 09, 2016 10:21 pm

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 My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Re: Record of SQL Errors Et Cetera

Postby Orpheus » Sat Mar 11, 2017 5:59 am

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)
Orpheus
Lictor
Lictor
 
Posts: 169
Joined: Sun Nov 08, 2015 2:31 pm

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Sat Mar 11, 2017 7:42 pm

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 My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Re: Record of SQL Errors Et Cetera

Postby Lupine » Wed Aug 09, 2017 10:28 pm

I've been getting quite few SQL errors. So many that it's been hard posting about them here.
User avatar
Lupine
Consul
Consul
 
Posts: 27347
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Wed Aug 09, 2017 10:30 pm

I've been getting a few, too. I emailed huggle about it. :(
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Re: Record of SQL Errors Et Cetera

Postby huggle » Thu Aug 10, 2017 5:08 pm

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
huggle
Censor
Censor
 
Posts: 738
Joined: Mon Sep 19, 2016 4:40 am
Location: Bavaria

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Thu Aug 10, 2017 9:39 pm

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 My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Re: Record of SQL Errors Et Cetera

Postby huggle » Tue Aug 15, 2017 2:22 pm

should look better now :D
I must copy the settings (avatar size, attachment sizes, PM privileges etc) from here to the new board but apart from that it appears to be fully functionable. Or maybe it's just a better actor than its predecessors :veryhappy:
a hug a day keeps the psychiatrist away
User avatar
huggle
Censor
Censor
 
Posts: 738
Joined: Mon Sep 19, 2016 4:40 am
Location: Bavaria

Re: Record of SQL Errors Et Cetera

Postby RJDiogenes » Tue Aug 15, 2017 9:12 pm

huggle wrote:should look better now :D

It looks great. :yes:

I must copy the settings (avatar size, attachment sizes, PM privileges etc) from here to the new board but apart from that it appears to be fully functionable. Or maybe it's just a better actor than its predecessors :veryhappy:

I checked it out and posted and everything seemed fine. There were only two things I noticed: Nobody has any avatars and the name of the latest thread with activity doesn't show up on the main index page.

Attached pictures are there, though! :bounce:
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:
User avatar
RJDiogenes
Imperator
Imperator
 
Posts: 48727
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston

Previous

Return to Questions, Suggestions & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest