04 Gateway time-out
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Re: 04 Gateway time-out
04 Gateway time-out
25-03-2024 6:09 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I have a genealogy site at http://ccgi.stephenthompson.plus.com/genealogy/index.php
A few weeks ago I was able to logon to it and get info from the site. Now I can only log on. Anything else I do results in a 504 gateway time-out error. I've not made any changes to the site in probably many months. I logged on to the control panel the other day and received the following
"Cannot connect: invalid settings. mysqli::real_connect(): (HY000/1203): User ccgistephe670981 already has more than 'max_user_connections' active connections phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection".
Contacted PlusNet who suggested I should post here. I can now access my database through the control panel and MySQL and can see all my tables again, but the site still gives me a 04 error.
Stephen
Re: 04 Gateway time-out
25-03-2024 10:35 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@csiatst wrote:
"Cannot connect: invalid settings. mysqli::real_connect(): (HY000/1203): User ccgistephe670981 already has more than 'max_user_connections' active connections phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection".
@csiatst I clicked on the link which initially gave a genealogy page (but clicking on further links said 'no content' or some such).
Just tried the link again and it just says 'loading' (indefinitely) then 504 Gateway Timeout.
If it's a mysql issue I'm guessing @bobpullen might be the only person who could help sort this - not his area of work these days afaik but hopefully he'll see your post at some stage soon.
.
Project HappyChild website (free educational resources for kids and schools, plus directory of charities helping children) 1998 onwards
Re: 04 Gateway time-out
28-03-2024 8:26 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I think the problem is that PlusNet have moved the server. I found a thread in here from when they moved from Rumpus.
https://community.plus.net/t5/Everything-else/MySQL-cannot-connect-to-database/td-p/1400124/page/2
I can recall now where I find that database user name and password so I can update it again.
Re: 04 Gateway time-out
29-03-2024 7:57 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Can my CCGI webspace be restored to how it was before it was moved to a new server?
Where does db.inc live?
Do I need to set up a new database again?
@bobpullen are you able to help me with this issue?
Re: 04 Gateway time-out
29-03-2024 4:29 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@csiatst wrote:
I can now access my database through the control panel and MySQL and can see all my tables again, but the site still gives me a 04 error.
@csiatst wrote:
I found a thread in here from when they moved from Rumpus.
https://community.plus.net/t5/Everything-else/MySQL-cannot-connect-to-database/td-p/1400124/page/2
Illuminating thread - in lots of ways.
Called up your site yesterday - and again just now - as per screenshot below, but the links (still) don't work.
... so, a couple of questions.
(1) have you re-enabled error-reporting - as per linked post on the referenced thread
(2) no idea what TNG might be (?) but wondering if changes to php / mysql versions in the interim, might have stopped your code from calling up the required content from the database.
As far as I recall, the php version on hostopia was 7.3 (ish) last summer (the linked post refers to php 5.6). I don't know how php/mysql versions interface (not a techie) but I do know that it was necessary to replace mysql calls (in the code) with mysqli (similar types of call-ups but not structured the same), so that they would work on php 7.3, when I had to move several websites to Mythic Beasts (mainly for https).
Further to that, when MB moved from php 7.3 to 7.4, I discovered that a lot of scripts stopped working - randomly - and eventually tracked this down to the need to have <?php at the beginning of a call-up clause, rather than just <? which had crept into the coding here and there, over a period of some years
(as in, eg, <?php echo $data["bloggs"] ?> rather than <? echo $data["bloggs"] ?> ).
No idea whether either of the above would help solve your issues, but thought it might be worth asking, just in case.
.
Project HappyChild website (free educational resources for kids and schools, plus directory of charities helping children) 1998 onwards
Re: 04 Gateway time-out
04-04-2024 8:32 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@csiatst wrote:
Can my CCGI webspace be restored to how it was before it was moved to a new server?
Where does db.inc live?Do I need to set up a new database again?
@bobpullen are you able to help me with this issue?
The last CGI/SQL migration was > 5 years ago, so no chance of that. Any config files you have will be on the FTP server.
If you're able to acces your SQL database then how large is it, I wonder if it's size could be the cause of the problem?
If you're adament things were working a few weeks back then I can try raising a support ticket to our hosting partner if you like?
Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Re: 04 Gateway time-out