changing back to phpbb2 after too many connections error

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

changing back to phpbb2 after too many connections error

Post by lordofthisworld » Wed Apr 09, 2008 4:55 pm

Is it possible to convert the phpbb3 forum back to the phpbb2? if so how?
Last edited by lordofthisworld on Fri Apr 18, 2008 10:15 am, edited 1 time in total.

Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: changing back to phpbb2

Post by Pit$Bull » Wed Apr 09, 2008 5:02 pm

No, sorry

lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

Re: changing back to phpbb2

Post by lordofthisworld » Wed Apr 09, 2008 5:10 pm

bugger! what if i install a new phpbb2 will it work with the existing phpbb3 database?

i am having the too many connections problem as a lot are, it seems my solutions are :-

1 change hosts
2 change back to phpbb2 where we had no errors
3 change to vbulletin and stay with my current hosts

any suggestions?

Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: changing back to phpbb2

Post by Pit$Bull » Wed Apr 09, 2008 5:51 pm

lordofthisworld wrote:bugger! what if i install a new phpbb2 will it work with the existing phpbb3 database?

i am having the too many connections problem as a lot are, it seems my solutions are :-

1 change hosts
2 change back to phpbb2 where we had no errors
3 change to vbulletin and stay with my current hosts

any suggestions?
PhpBB2 and PhpBB3 are completely different and nothing is compatible except for the conversion utility.

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10341
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: changing back to phpbb2

Post by Noxwizard » Wed Apr 09, 2008 5:55 pm

A "Too many connections" problem is a limitation by your host, not the software.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

Re: changing back to phpbb2

Post by lordofthisworld » Wed Apr 09, 2008 6:03 pm

Noxwizard wrote:A "Too many connections" problem is a limitation by your host, not the software.
well after reading all the threads on this problem this seems the most definite answer. but why does it only happen since phpbb3?

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10341
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: changing back to phpbb2

Post by Noxwizard » Wed Apr 09, 2008 6:15 pm

Maybe your host has recently forced persistant database connections. Which means the server won't close the connection like it should. phpBB opens a new connection each time you view a page (because it has already requested that the last one be closed), so if they are forcing the connections to stay open, you can hit this error.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

Re: changing back to phpbb2

Post by lordofthisworld » Wed Apr 09, 2008 6:27 pm

i've had my forum running on phpbb for about 6 years now or more and since changing to phpbb3 have had these errors.My hosts disabled my database on sunday and i have begged them to reactivate it which they are reluctant to do until tonight but i'm still waiting.

this is their response today.

"We have re-enabled the database please can you ensure that all mysql connections are closed after the query has been completed, if excessive connections are found again your database may be disabled again."

so what does this mean in simpleton terms?

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10341
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: changing back to phpbb2

Post by Noxwizard » Wed Apr 09, 2008 10:08 pm

What exactly does the error say? Is it saying there's too many connections for your database user or just too many in general? If it's the latter, that's usually server-wide. Who's your host? A lot of hosts don't configure their servers very well.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

Re: changing back to phpbb2

Post by lordofthisworld » Wed Apr 09, 2008 10:34 pm

its the too many connections error

General Error
SQL ERROR [ mysql4 ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

host is webfusion.

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10341
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: changing back to phpbb2

Post by Noxwizard » Wed Apr 09, 2008 10:58 pm

You might ask them about the persistant connections and see what it's set to. If they're enabled, ask them to disable it.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

Re: changing back to phpbb2

Post by lordofthisworld » Wed Apr 09, 2008 11:36 pm

will do , thanks!

pacop2
Registered User
Posts: 31
Joined: Sat Sep 02, 2006 7:04 pm

Re: changing back to phpbb2

Post by pacop2 » Fri Apr 11, 2008 7:52 am

Noxwizard wrote:A "Too many connections" problem is a limitation by your host, not the software.
I have the same problem since I upgrade to phpbb3 (it was running for years without this problem in previous versions).

It happened four times since phpbb3 was released. I'm going to ask about persistant connections, I don't know if it's enabled.

lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

Re: changing back to phpbb2

Post by lordofthisworld » Fri Apr 11, 2008 8:03 am

well my hosts are disabled and they wont enable it due to being on shared hosting, my site s still down and they are reluctant to activate it. i have installed the new phpBB3 latest version and restored a backed up database now i am showing no forums. what a farce! If i have to start from scratch again i will be using vbulletin!

lordofthisworld
Registered User
Posts: 59
Joined: Fri Oct 12, 2007 9:14 am
Contact:

Re: changing back to phpbb2

Post by lordofthisworld » Tue Apr 15, 2008 8:16 am

UPDATE

i reinstalled PHPBB3 3.0 and my hosts have now reactivated my database so i'm back online after a weeks down time, but i have had to disable the search feature and the bots to stop this happening again. :(

Locked

Return to “[3.0.x] Support Forum”

cron