Resetting Database? Help! (Multiple Database Users?)

[BigMike]

Wow, that was really retarded.

Well, I updated 4 source files, so I am sure that was the problem.

I guess I could move the # of users back down to 4 or even 3, and then see if it starts having the same error with the max_questions, but then it would just scare my members away, so I guess I'll just use the ol' "If it ain't broke, don't fix it" method and just hope I never see that error ever again. With 7 users now, it shouldn't be a problem-

If everything goes well, I'll hit back after a week and just thank all involved for their time and help.

Have a nice day, cya!!
BigMike

[BigMike]

Welp,

This is completely Unbelievable. It is just past midnight now, and we have a light load on our forum, and I just got the same error again for the first time since fixing my file versions. max_questions error.... Man I have had it.

I am going to look into a new host for our forum tomorrow. I just can't take Ipowerweb any more. This is the worst experience I've ever had. Absolutely nothing I can do.

I'll keep this updated tomorrow.

So could someone be hacking my forum or something? Has anyone else had experience with this?

I am using SEVEN users, and all 7 of them are experiencing more than 50,000 "questions" to the database. Can you believe that? That's a total of 350,000 questions going on right now, and we only have, what, maybe 20 people on right now? This is out of hand at the moment...

During a page reload:

Code Select Expand

: User 'marlincr_ol6' has exceeded the 'max_questions' resource (current value: 50000)
/home/marlincr/public_html/board/Sources/Load.php
1231

Check that out! That's User 'marlincr_ol6', which stands for "Over Load #6" hahahahahaha

[BigMike]

Wow, it's serious now, I cant even get the forum to load at all. It is cycling through all 7 users, all throwing the same error.

I am going to upload the repair_settings.php and put the forum into maintence mode. Looks like it's gonne be shut down tomorrow for the first time in 3 years. I'll be happy to move to a more reliable host..

So what is a great host? What do you guys recommend?
This is where I'm gonna start tomorrow:
http://www.thehostingchart.com/?igojo=1&mej=406

Gotta clock out for today, got class in the morning, so I won't be able to resolve this problem until the afternoon.............

[BigMike]

Well, line 1231 of my Load.php is:

      LIMIT 1", __FILE__, __LINE__);

Here is the complete code of that area:

Code Select Expand


1219: function sessionRead($session_id)
1220: {
1221: global $db_prefix;
1222:
1223: if (preg_match('~^[A-Za-z0-9]{16,32}$~', $session_id) == 0)
1224: return false;
1225:
1226: // Look for it in the database.
1227: $result = db_query("
1228: SELECT data
1229: FROM {$db_prefix}sessions
1230: WHERE session_id = '" . addslashes($session_id) . "'
1231: LIMIT 1", __FILE__, __LINE__);
1232: list ($sess_data) = mysql_fetch_row($result);
1233: mysql_free_result($result);
1234:
1235: return $sess_data;
1236: }


Any ideas? I think I still want to make the change. My manager already told me that because we have been growing so much, that if we need some more resources, then to just ask him and he'll give me the green light to make the changes. So I am going to change hosts and move everything tomorrow.

Oh boy, here we go.....

[BigMike]

Ok, while trying to post to let my members know that the board will be down, I got the error in Load.php, but this time on Line 520.

Looking line 520 up...........

Ok, here it is:

Code Select Expand


516: // Load the data.
517: $request = db_query("
518: SELECT$select_columns
519: FROM {$db_prefix}members AS mem$select_tables
520: WHERE mem." . ($is_name ? 'memberName' : 'ID_MEMBER') . (count($users) == 1 ? " = '" . current($users) . "'" : " IN ('" . implode("', '", $users) . "')"), __FILE__, __LINE__);
521: $loaded_ids = array();


So that's

Code Select Expand

WHERE mem." . ($is_name ? 'memberName' : 'ID_MEMBER') . (count($users) == 1 ? " = '" . current($users) . "'" : " IN ('" . implode("', '", $users) . "')"), __FILE__, __LINE__);

[BigMike]

Ok, I just got off the phone with Ipowerweb, and the guy says that they have not made any changes to any of there servers for a while now.

I was hopeing that the had some older/newer version of php that they just installed yesterday, that was giving me these problems, but apparently that is not the problem.

So if none of their files changed, and none of my files changed, I guess someone is trying to hack my forum, or the database has some serious problem with it.

I've done the table repair and myphpAdmin couldn't find anything wrong with my tables, that was as of about 6 hrs ago.

The tech guy also said that the max_questions thing is reset ever hour, don't know if that means anything to anyone

Basically, the way that I feel right now, is that I've had many people tell me that Ipowerweb is crap, so I am just going to get rid of them and move the forum somewhere else.

G'Night World,
BigMike

[BigMike]

One last thing, does anyone have any experience with any of the following hosts?

IX Web Hosting
Host Excellence
Lunar Pages
Easy CGI
Jump Line
Global Host
Host Rocket
Ace Host
Globat

[BigMike]

I just changed all of the database user names and passwords, so it's working now, but I'm leaving it in Maintenance mode until I can figure something out....

I was thinking that by changing the pswrd, a would-be hacker is left in the dark now?

[BigMike]

ttt

[BigMike]

Well, so far it's doing ok.

I've got 16 users right now, and I staggered them into groups every 15mins. So this way, as those that are overloading are resetting after 1hours time, the others will still be in service. Quartely rotations on the hour.

Well, if I can get some time later today, I am going to upgrade to 1.1 RC1 and see if that solves it.

One mod that I've installed that I've always though was a bit *fishy* was the "Faster Parsecode" mod. Is that really needed? Does that really improve the speed? If so, then why isn't it just standard? So I am going to remove that mod when I upgrade to RC1, and also remove the "PJIRC Integrated Chat Mod", since I've never seen anyone use it hahahahaha The shout box is awesome!

Cya
BigMike

[BigMike]

Hey,

For some reason, my forum has gone in to Maintenance Mode by itself TWICE now and I am the only one who can do that, and I am not even in the admin panel.

How are these users being opened and closed? Because so many users are being used now, is it possible fo someone to sneak or roll into my acount and get into the admin? Or, since I put the forum in Maintenance Mode at 1am this morning, could the user that I was using have hung open, and then when it finally closed, it ran the command the put it in to Maintenance Mode?

I dont know what the hells been going on, this is beyond craziness

[BigMike]

ttt

[BigMike]

Well, now the forum is taking 40 - 50 seconds to load, or it will not even come up at all, and then after a couple of mins, it'll load at 3 - 4 secs, and you can load a couple of pages just fine, and then 5mins later, it'll hang at 40secs again... This is really frustrating.


EDIT: I just checked our webpage and it loads just fine. So its not the server, it is database related or something. Our website (www) loads really quick. Wish the forum would do that.........

Page created in 56.155 seconds with 22 queries.

[BigMike]

Page created in 45.232 seconds with 21 queries.


Well...........

You know, my database has been used since 2002. It was originally a YaBBSE database that was then used for SMF. So maybe the database is just too cluttered........?

So I was wondering, is it possible to start all over with a fresh database, and somehow be able to copy over just the Profiles, Threads, Boards, Posts, PMs, Password data, etc. ?

I am ready right now to start a 2nd temporary forum somewhere on my server, like board.marlincrawler.com/test2/index.php or something, and see if it works any better with a fresh database, but If I restore a saved database, and if that database has problems (like mine) then that would copy the same problem over to my new test forum.

So I am wondering if I can just extract the posts/members/PMs/etc and I'll take care of all the settings and the other stuff to get it back running. I'll use the newer 1.1 RC1 and I'll get the theme copied over, but everything else I am wondering if I could somehow copy over just the basics?

I know I wont copy the attachments over, so this would just be a test forum to see how it would run.

And look at this, just in the time it has taken me to post this, now my page is back loading at Page created in 4.753 seconds with 16 queries. which IS REALLY SUPER FAST !!!! <---- Can you believe that that's is what I consider fast right now? geeze

[BigMike]

Hey,

For some reason, my forum has gone in to Maintenance Mode by itself TWICE now and I am the only one who can do that, and I am not even in the admin panel.

Ok, I think I found out what this was all about, when I was doing an Optimize on the forum, it was putting the forum into the Maintenance Mode. I guess there were too many people online or something? So now when ever I want to Optimize my forum (I do this about once a week) I will then have to go to the server settings and take it out of maint. mode. It's never done that before........


Hey, is anyone alive out there? I feel like I'm at the UN and no one has their head phones on.