What gives with the site?

Moderators: Elvis, DrVolin, Jeff

Re: What gives with the site?

Postby Grizzly » Fri Jan 12, 2024 12:19 pm

Return to index page
General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Powered by phpBB® Forum Software © phpBB Group
“The more we do to you, the less you seem to believe we are doing it.”

― Joseph mengele
User avatar
Grizzly
 
Posts: 4722
Joined: Wed Oct 26, 2011 4:15 pm
Blog: View Blog (0)

Re: What gives with the site?

Postby Laodicean » Fri Jan 12, 2024 8:11 pm

User avatar
Laodicean
 
Posts: 3343
Joined: Wed Jan 27, 2010 9:39 pm
Blog: View Blog (16)

Re: What gives with the site?

Postby JackRiddler » Fri Jan 12, 2024 10:36 pm

As I just wrote to Grizzly:

I was never listed on the board as mod/admin because of the 19th century software.

Nevertheless I have been and remain mod/admin. Have been derelict recently, so I only just saw what's going on. Sorry.

Also, I have completely forgotten what the fuck we did the last time we were in SQL Error Hell to fix it. This predicament too is due to the 19th century software and almost certainly unrelated to actions of the evil Them.

Damn it, it was something. I mean, someone told me what to do to fix it, and I did it, somewhere in the software, and then everything worked again. Please do PM if you remember....
We meet at the borders of our being, we dream something of each others reality. - Harvey of R.I.

To Justice my maker from on high did incline:
I am by virtue of its might divine,
The highest Wisdom and the first Love.

TopSecret WallSt. Iraq & more
User avatar
JackRiddler
 
Posts: 15988
Joined: Wed Jan 02, 2008 2:59 pm
Location: New York City
Blog: View Blog (0)

Re: What gives with the site?

Postby fruhmenschen » Sat Jan 13, 2024 4:07 pm

https://www.google.com/url?sa=i&url=htt ... AdAAAAABAE


Return to index page
General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
fruhmenschen
 
Posts: 5742
Joined: Thu Aug 12, 2010 7:46 pm
Blog: View Blog (0)

Re: What gives with the site?

Postby fruhmenschen » Sun Jan 14, 2024 11:32 am

Return to index page
General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
fruhmenschen
 
Posts: 5742
Joined: Thu Aug 12, 2010 7:46 pm
Blog: View Blog (0)

Re: What gives with the site?

Postby fruhmenschen » Mon Jan 15, 2024 10:22 pm

Still having problems
Anyone else?

Return to index page
General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
fruhmenschen
 
Posts: 5742
Joined: Thu Aug 12, 2010 7:46 pm
Blog: View Blog (0)

Re: What gives with the site?

Postby fruhmenschen » Wed Jan 17, 2024 4:20 pm

It is currently Wed Jan 17, 2024 4:17 pm

Top Three
Topics
Posts
Last post
Feed - General Discussion General Discussion

Moderators: Elvis, DrVolin, Jeff
28418 Topics
526842 Posts
Last post by BenDhyan View the latest post
Wed Jan 17, 2024 7:20 am
Feed - Data & Research Compilations Data & Research Compilations

Moderators: Elvis, DrVolin, Jeff
501 Topics
16598 Posts
Last post by fruhmenschen View the latest post
Mon Jan 15, 2024 10:31 pm
Feed - The Lounge & Member News The Lounge & Member News

Moderators: Elvis, DrVolin, Jeff
1215 Topics
24564 Posts
Last post by Laodicean View the latest post
Wed Sep 20, 2023 8:06 pm
Greatest
fruhmenschen
 
Posts: 5742
Joined: Thu Aug 12, 2010 7:46 pm
Blog: View Blog (0)

Re: What gives with the site?

Postby fruhmenschen » Fri Jan 19, 2024 9:45 am

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
fruhmenschen
 
Posts: 5742
Joined: Thu Aug 12, 2010 7:46 pm
Blog: View Blog (0)

Re: What gives with the site?

Postby alloneword » Fri Jan 19, 2024 3:37 pm

FYI:

The last time this happened (that I'm aware of, at least), the main cause was identified as a particularly ill-mannered Chinese search engine that was indexing the ~5 GB of text that makes up the RI database.

The remedy was to identify the user agent / IP range of the offending entity and give it a taste of the almighty ban-hammer. This was all that was/is available with the available tools (the phpbb Admin Panel).

The issues are, however, indicative of a deeper problem: The board software, the operating system and the components it sits on date back to September 2012, and to my knowledge have not been updated since then. The fact that it is all still here and running at all is testament to the abilities of the person (drew!) who initially put it together over a decade ago. I am truly astonished every time I see that it is.

Unfortunately, the login credentials to the RI server that would be required to perform an update are unavailable. At this point in time, it's actually doubtful that such an update could even be performed, so a 'bare metal' install would be required. In light of this, should it be desired that the existing database (and all the posts therein) be preserved or retained, the only option would be to take the existing database (assuming that it can be exported intact - at ~5 GB that would present it's own challenges) and load that into an instance of phpbb 3.x running on a local machine, then carefully walk that up through the phpbb updates, one at a time, to the current version. Then re-export the database again and upload it to a freshly installed phpbb running on an up-to-date operating system (either on the current - Jeff's - server or elsewhere).

I'm sure that others share in my deep gratitude to Jeff for having paid the hosting fees for so long (not to mention keeping me slightly saner during these past few 'interesting' years with his twitter posts), but I'm equally sure that I'm not the only one who has wondered how long his generosity can (or even should) continue in this regard.
User avatar
alloneword
 
Posts: 902
Joined: Mon Jan 22, 2007 9:19 am
Location: UK
Blog: View Blog (0)

Greetings everyone!

Postby JackRiddler » Sat Jan 20, 2024 10:04 am

A team has been assembled.

First measures have been taken and there appears to be less of an SQL problem this beautiful morning!*

* where I am, anyway, results may differ by latitude, altitude, and plenitude.

Let's see if this lasts and if we can get things going again.

Will keep you informed.
We meet at the borders of our being, we dream something of each others reality. - Harvey of R.I.

To Justice my maker from on high did incline:
I am by virtue of its might divine,
The highest Wisdom and the first Love.

TopSecret WallSt. Iraq & more
User avatar
JackRiddler
 
Posts: 15988
Joined: Wed Jan 02, 2008 2:59 pm
Location: New York City
Blog: View Blog (0)

Re: What gives with the site?

Postby fruhmenschen » Sat Jan 20, 2024 10:44 am

UGH!


Return to index page
General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
fruhmenschen
 
Posts: 5742
Joined: Thu Aug 12, 2010 7:46 pm
Blog: View Blog (0)

Re: What gives with the site?

Postby alloneword » Sat Jan 20, 2024 3:23 pm

OK, as of 19:20 GMT, a major potential case of the 'SQL ERROR' has been eliminated.

Please do post here if the problem (or anything similar) persists.
User avatar
alloneword
 
Posts: 902
Joined: Mon Jan 22, 2007 9:19 am
Location: UK
Blog: View Blog (0)

Was just...

Postby JackRiddler » Sat Jan 20, 2024 4:18 pm

Was just coming to say the same thing. Thanks to the expertise of Sir Alloneword, SQL Hell is over again for now.

The cause appears to be bots. It probably is not an intentional attack. (Is that right, aow? Not sure.)
We meet at the borders of our being, we dream something of each others reality. - Harvey of R.I.

To Justice my maker from on high did incline:
I am by virtue of its might divine,
The highest Wisdom and the first Love.

TopSecret WallSt. Iraq & more
User avatar
JackRiddler
 
Posts: 15988
Joined: Wed Jan 02, 2008 2:59 pm
Location: New York City
Blog: View Blog (0)

Re: What gives with the site?

Postby alloneword » Sat Jan 20, 2024 4:40 pm

You're welcome, and most likely, yes.

Most modern servers wouldn't even flinch at what was being asked of it here, TBH. It's just that ours is a little, to put it kindly, 'challenged' by today's standards.
User avatar
alloneword
 
Posts: 902
Joined: Mon Jan 22, 2007 9:19 am
Location: UK
Blog: View Blog (0)

Re: What gives with the site?

Postby fruhmenschen » Sat Jan 20, 2024 7:09 pm

https://www.youtube.com/watch?v=idfB5OSyObA


All the Power You Cannot See

Caroline Myss
fruhmenschen
 
Posts: 5742
Joined: Thu Aug 12, 2010 7:46 pm
Blog: View Blog (0)

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 10 guests