Page 1 of 2

changing back to phpbb2 after too many connections error

Posted: Wed Apr 09, 2008 4:55 pm
by lordofthisworld
Is it possible to convert the phpbb3 forum back to the phpbb2? if so how?

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 5:02 pm
by Pit$Bull
No, sorry

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 5:10 pm
by lordofthisworld
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?

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 5:51 pm
by Pit$Bull
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.

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 5:55 pm
by Noxwizard
A "Too many connections" problem is a limitation by your host, not the software.

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 6:03 pm
by lordofthisworld
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?

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 6:15 pm
by Noxwizard
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.

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 6:27 pm
by lordofthisworld
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?

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 10:08 pm
by Noxwizard
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.

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 10:34 pm
by lordofthisworld
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.

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 10:58 pm
by Noxwizard
You might ask them about the persistant connections and see what it's set to. If they're enabled, ask them to disable it.

Re: changing back to phpbb2

Posted: Wed Apr 09, 2008 11:36 pm
by lordofthisworld
will do , thanks!

Re: changing back to phpbb2

Posted: Fri Apr 11, 2008 7:52 am
by pacop2
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.

Re: changing back to phpbb2

Posted: Fri Apr 11, 2008 8:03 am
by lordofthisworld
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!

Re: changing back to phpbb2

Posted: Tue Apr 15, 2008 8:16 am
by lordofthisworld
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. :(