Previous Thread
Next Thread
Print Thread
Rate Thread
Hosting being suspended due to sql errors :( #311681
10/12/2006 1:44 AM
10/12/2006 1:44 AM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
Help.... my host has shut me down for the following reason -

Quote
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.??

Sponsored Links
Re: Hosting being suspended due to sql errors :( [Re: MossY] #311683
10/12/2006 2:29 AM
10/12/2006 2:29 AM
Joined: Jul 2001
Posts: 811
Berlin, Germany
Zarzal Offline
Coder
Zarzal  Offline
Coder
Joined: Jul 2001
Posts: 811
Berlin, Germany
do you enable persistent connections in the admin settings? Wich version you are running excactly?

Re: Hosting being suspended due to sql errors :( [Re: Zarzal] #311684
10/12/2006 3:21 AM
10/12/2006 3:21 AM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
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 frown

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311691
10/12/2006 1:18 PM
10/12/2006 1:18 PM
Joined: Oct 2006
Posts: 14
L
Learner Offline
Newbie
Learner  Offline
Newbie
L
Joined: Oct 2006
Posts: 14
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.

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311697
10/12/2006 6:00 PM
10/12/2006 6:00 PM
Joined: Jul 2001
Posts: 811
Berlin, Germany
Zarzal Offline
Coder
Zarzal  Offline
Coder
Joined: Jul 2001
Posts: 811
Berlin, Germany
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.

Sponsored Links
Re: Hosting being suspended due to sql errors :( [Re: Learner] #311716
10/13/2006 12:30 PM
10/13/2006 12:30 PM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
Originally Posted by Learner
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 smile

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311717
10/13/2006 12:47 PM
10/13/2006 12:47 PM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
this line isnt in my config frown

$config['persistent'] = "";

should it be.. can i just add it?

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311719
10/13/2006 4:15 PM
10/13/2006 4:15 PM
Joined: Jul 2001
Posts: 811
Berlin, Germany
Zarzal Offline
Coder
Zarzal  Offline
Coder
Joined: Jul 2001
Posts: 811
Berlin, Germany
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.

Re: Hosting being suspended due to sql errors :( [Re: Zarzal] #311726
10/14/2006 12:41 PM
10/14/2006 12:41 PM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
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 frown

can i add it? will it still be affective if i type the line in?

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311727
10/14/2006 4:57 PM
10/14/2006 4:57 PM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho
Joined: Mar 2000
Posts: 25,587
Texas
yes smile


- Allen wavey
- What Drives You?
Sponsored Links
Re: Hosting being suspended due to sql errors :( [Re: AllenAyres] #311732
10/15/2006 9:14 AM
10/15/2006 9:14 AM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
(ooh, top man on my case now smile )... 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.
Re: Hosting being suspended due to sql errors :( [Re: MossY] #311733
10/15/2006 11:03 AM
10/15/2006 11:03 AM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
ok, gone for a fresh install as they suspended, then locked us out frown

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?

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311734
10/15/2006 11:19 AM
10/15/2006 11:19 AM
Joined: Jul 2001
Posts: 811
Berlin, Germany
Zarzal Offline
Coder
Zarzal  Offline
Coder
Joined: Jul 2001
Posts: 811
Berlin, Germany
6.5.5 doesn't have an portal. What do you use? IIP? Maybe you overwrite the index.php ...

Re: Hosting being suspended due to sql errors :( [Re: Zarzal] #311735
10/15/2006 4:13 PM
10/15/2006 4:13 PM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
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??

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311736
10/15/2006 6:43 PM
10/15/2006 6:43 PM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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).


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: Hosting being suspended due to sql errors :( [Re: MossY] #311737
10/16/2006 2:40 AM
10/16/2006 2:40 AM
Joined: Jul 2001
Posts: 811
Berlin, Germany
Zarzal Offline
Coder
Zarzal  Offline
Coder
Joined: Jul 2001
Posts: 811
Berlin, Germany
There are 2 Version of IIP available:
Version 6.5
Version 5.1.1


Re: Hosting being suspended due to sql errors :( [Re: Zarzal] #311743
10/16/2006 5:07 PM
10/16/2006 5:07 PM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
yup, found them.. cheers tho, nice one...

ok, almost done smile...

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 smile

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311748
10/16/2006 5:23 PM
10/16/2006 5:23 PM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: Hosting being suspended due to sql errors :( [Re: MossY] #311751
10/16/2006 6:23 PM
10/16/2006 6:23 PM
Joined: Jul 2001
Posts: 811
Berlin, Germany
Zarzal Offline
Coder
Zarzal  Offline
Coder
Joined: Jul 2001
Posts: 811
Berlin, Germany
in V6.5.5 its templates/default/ubbt_registerednav.tmpl and templates/default/ubbt_unregisterednav.tmpl

Re: Hosting being suspended due to sql errors :( [Re: Gizmo] #311754
10/16/2006 6:47 PM
10/16/2006 6:47 PM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
im running 6.5.5 but i dont see it in the header.tplt file frown

Re: Hosting being suspended due to sql errors :( [Re: MossY] #311757
10/17/2006 1:40 AM
10/17/2006 1:40 AM
Joined: Oct 2006
Posts: 16
M
MossY Offline OP
Newbie
MossY  Offline OP
Newbie
M
Joined: Oct 2006
Posts: 16
oh damn.... an error frown

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 Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit Us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,938
Joined: January 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,448
Posts293,484
Members13,793
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,938
Greg Hard 5,533
Top Posters(30 Days)
isaac 4
Today's Statistics
Currently Online 685
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 18
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180611.dev)
Page Time: 0.123s Queries: 15 (0.056s) Memory: 3.3952 MB (Peak: 3.6629 MB) Zlib enabled. Server Time: 2018-06-18 23:21:50 UTC