|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
Help.... my host has shut me down for the following reason - Dear Customer,
There is a problem with your forum script;
| 2475 | blighty_forum | localhost | blighty_forum | Query | 156 | Sending data |
| 2488 | blighty_forum | localhost | blighty_forum | Query | 153 | Locked |
| 2518 | blighty_forum | localhost | blighty_forum | Query | 134 | Locked |
| 2584 | blighty_forum | localhost | blighty_forum | Query | 78 | Locked |
Your script is keeping database connections open and not closing them. The numbers 156, 153, 134, 78 are all times, in seconds that a process from your account is running. These should never be more than a few seconds.
After suspending your account these processes were killed. and the CPU usuage returned from 80% down to the usual 3%CPU usage. Had the MySQL services not been restarted the server would have crashed due to your script not functioning correctly.
any ideas/help.. PLEASE... running UBB Threads 6.??
|
|
|
|
|
Joined: Jul 2001
Posts: 808
Coder
|
|
Coder
Joined: Jul 2001
Posts: 808 |
do you enable persistent connections in the admin settings? Wich version you are running excactly?
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
where is the enable persistant connections option? i think it is 6.5 ... but i cant get in to it at the moment as its suspended 
|
|
|
|
|
Joined: Oct 2006
Posts: 13
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 13 |
DO NOT use pconnections. lol. In phps' mysqli this was drop because of the number of problems it caused. If you can code ask them to send you the error log for your domain and look through it, find the script/s and make sure the database connection closes. Maybe even upgrade the sql calls the mysqli as you can clean up resources faster
$mysqli = new mysqli("db_host","db_user","db_psswd","db");
$result = $mysqli->query(select your query here);
WHILE($row = $result->fetch_assoc()){
//work done with data sets here
}
$result->close();
$mysqli->close();
To some this might look odd, this is object oreiented php using mysqli. But the main thing to notice is the 2 objects I closed.
$result->close();
This cleans up all resources used to make the query. Ram, CPU time, all cleaned up
$mysqli->close();
Closes the database connection object.
If you can't code... Get a less anal host. Interserver.net has done me very good.
|
|
|
|
|
Joined: Jul 2001
Posts: 808
Coder
|
|
Coder
Joined: Jul 2001
Posts: 808 |
if you have FTP access go to your ubbthreads directory and then to includes. You find the config.inc.php
Open this file in your editor and look for:
$config['persistent'] = "";
This is the correct string for persistent connections off. If you have any other value in this string change it.
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
If you can't code... Get a less anal host. Interserver.net has done me very good. lol... sounds like a plan... im a C man.. all this sql stuff is like VB to me 
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
this line isnt in my config $config['persistent'] = ""; should it be.. can i just add it?
|
|
|
|
|
Joined: Jul 2001
Posts: 808
Coder
|
|
Coder
Joined: Jul 2001
Posts: 808 |
it should .... Sounds your config is modified in some way. Maybe thats the main source of your problem. Do you run 6.5.5 or less? any other version as 6.5.5 have a security hole and get hacked soon. The last mass hack changes or overwrite the config.inc.php
Check the file and compare with your backup.
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
ok. its 6.5.5 i am useing. i checked back in a config.inc file from a couple of months ago... and this line still isnt there can i add it? will it still be affective if i type the line in?
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
yes
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
(ooh, top man on my case now )... nice one... thats what i will do then. ok, if this doesnt clear the fault, how do i tell which queery is holding up all the cpu time??
Last edited by MossY; 10/15/2006 9:15 AM.
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
ok, gone for a fresh install as they suspended, then locked us out i have set everything up and now im starting to put the forums back together. But i cant setup my portal/index page. i have lost that as an option in my control panel!!! how do i get it back?? i need to enable portal... but how?
|
|
|
|
|
Joined: Jul 2001
Posts: 808
Coder
|
|
Coder
Joined: Jul 2001
Posts: 808 |
6.5.5 doesn't have an portal. What do you use? IIP? Maybe you overwrite the index.php ...
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
yes.. IIP. is it an addition?/ i inherited the forum (well, the bloke that set it up left) so this was all in place when i took over.
do i need to install additional stuff then??
|
|
|
|
|
Joined: Jan 2000
Posts: 5,832 Likes: 20
UBBDev / UBBWiki Owner
Time Lord
|
|
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832 Likes: 20 |
Yes, you can, in most cases, find th emodifications in the UBB.Threads 6.5.x modifications forum here, IIP being one of them.
Another option would be upgrading to UBB.Threads, it is less intensive on the database as it utilizes a caching system, and comes with a lot of the previous popular mod's as stock features (including a portal).
|
|
|
|
|
Joined: Jul 2001
Posts: 808
Coder
|
|
Coder
Joined: Jul 2001
Posts: 808 |
There are 2 Version of IIP available: Version 6.5 Version 5.1.1
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
yup, found them.. cheers tho, nice one... ok, almost done ... one last question. which file do i edit to edit the navigation bar - you know... the one that says stuff like "Portal Page Forum List My Stuff User List Calendar Active Topics Search FAQ" along the top of the forums... last question... honest
|
|
|
|
|
Joined: Jan 2000
Posts: 5,832 Likes: 20
UBBDev / UBBWiki Owner
Time Lord
|
|
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832 Likes: 20 |
In .T7 it's through the template editor on the header.tpl file; on previous versions of .T, i'm not entirely sure as I never ran one...
|
|
|
|
|
Joined: Jul 2001
Posts: 808
Coder
|
|
Coder
Joined: Jul 2001
Posts: 808 |
in V6.5.5 its templates/default/ubbt_registerednav.tmpl and templates/default/ubbt_unregisterednav.tmpl
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
im running 6.5.5 but i dont see it in the header.tplt file
|
|
|
|
|
Joined: Oct 2006
Posts: 16
Newbie
|
|
Newbie
Joined: Oct 2006
Posts: 16 |
oh damn.... an error ok, when i go to edit display settings, i get this... Fatal error: Cannot redeclare class mailer in /home/blightyr/public_html/ubbt.inc.php on line 255 any ideas?? (oh, and i had some early problems with getting the language out of the code... (so i hard coded 'english' in some places - could this be my problem??
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 417
Joined: November 2001
|
|
|
Forums63
Topics37,571
Posts293,923
Members13,848
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
