Mysql query problem ?

Admin32 · Regular Joined: Sep 14, 2003 Posts: 74

After successfully installing phpnuke and importing my database, I have stumbled across another problem(!).

The site works fine for a few minutes and then when anyone tries to access any page the following error is produced:
------------------
Fatal error: Call to undefined function: themeheader() in /www/f/firewall/htdocs/header.php on line 47
------------------

Now, at the time this error appears, there are more than 40 users online, and I am guessing its got something to do with the SQL max_connections limits placed on the server. Currently its set to 36,000 per hour per user.

I wouldn't imagine 50 people being able to exceed this amount of queries in 15-20 minutes so I am wondering what the problem could be.

When the error starts coming up, I then change to the old site which dosent use the SQL database and leave it for 10 minutes, reenable the phpnuke site and it works again for another 20 minutes until the error starts coming up again!!

Any suggestions ?

Raven · Posted: Fri Sep 19, 2003 7:30 am

That is very strange. I would first ask your host to bump that up to something more reasonable, like 100000, to see if it continues to happen.

Other than that I have no idea.

[Shameless Plug]You could come on over to Raven Web Hosting. You won't suffer that restriction Laughing

Admin32 · Regular Joined: Sep 14, 2003 Posts: 74

Hehehe,

Funny you mentioned that.... my hosting expires 29th of October Smile

If you can offer a competitive package, I'll certainly consider it!!

After checking on the hosting company's forums, I found a few users that use a small script in order to have php-nuke randomly use one of the 3 possible account that's allowed on the sql server.:

$dbhost = "mysql01.powweb.com";
$auser = array("user","user1","user2");
$user = $auser[rand(0,2)];
$dbuname = "$user";
$dbpass = "password";
$dbname = "dbname";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";

So, I created another 2 users, giving me a total of 3 users and entered the details, but didn't seem to help.

The above settings would give me 108,000 queries per hour, if it works.

Raven · Posted: Fri Sep 19, 2003 7:46 am

Send me your requirements and what you consider 'competitive' and I will see what I can do. Either post it here or PM me. Thanks!