Database problems with the ZS forums - 7/18/2007

kyle · **Posted:** Wed Jul 18, 2007 5:05 pm

Some of you may have noticed a slow or non-existent response of this forum today. We had some problems with data corruption in the database. I worked with the host to get it cleaned up but unfortunately a few posts were lost in the process.

You might want to go back and check to see if you are missing any posts from earlier today and repost them. Or you can go cry in the corner while stabbing a picture of my face because you spent an hour coming up with it and nows it's gone for ever.

Sorry folks. Should be good now. If anyone has any further problems drop me an email. admin@zombiehunters.org

Thanks!

kyle · **Posted:** Wed Aug 08, 2007 5:54 pm

We're having problems again.

I told our host this afternoon to get us a new server for our mySQL database or we're going to start shopping for a new host. The problems we've been having over the last 5 days are completely unacceptable.

Sorry, everyone.

Citizen Simon · **Posted:** Wed Aug 08, 2007 6:41 pm

That's right, you better get this working right. You're like a drug dealer- make it cheep, fast, and easy in the beginning, just to get me hooked. Now that I am deadly addicted you take it away, allowing me to start hitting withdraws. You complain about 'server complications' and then BAM I end up paying $19.95 a month to stay in ZS. I am spiteful of having to pay, but I just can't beat the addiction. There is no nicorette of ZS, and I am too caught up to go cold turkey. Kyle wins, Doc Simon loses. :cry:

Brash · **Posted:** Wed Aug 08, 2007 6:42 pm

I noticed it earlier and got suspicious. I asked Orion to have a look and he said there was some wierd traffic coming to the site. He recorded it before going to bed. I'll ask him to PM you in the morning.

mrdbeau · **Posted:** Wed Aug 08, 2007 10:02 pm

kyle wrote:

Or you can go cry in the corner while stabbing a picture of my face because you spent an hour coming up with it and nows it's gone for ever.

Already on it.

The forum has been annoying lately, but we'll live (even DS). Good luck getting a good server host if you have to ditch the old one. mySQL databases can be a real pain, but then again, you probably have someone who knows what they're doing working with it...

kyle · **Posted:** Tue Aug 21, 2007 3:24 pm

Website was down on 8/8. I'm really sorry, guys.

I'm getting extremely annoyed now because I don't have the free time to screw around with this. I'm putting our complaints on record and looking for a new home for us.

Quote:

Ticket ID: 1098724
Type: Customer
Topic: Hosting

Status: Open
Created: 21-Aug-2007 (15:18)
Modified: 21-Aug-2007 (15:18)

Short Description: Website Down

I understand there is maintenance going on again, as indicated in my administrative panel, but this seems to be a regular thing that is bringing our site down every few days and interrupting business.

The last time it was down for this long was only a few weeks ago (8/8/07). lately, I'm noticing the web server and/or SQL sever causing us problems about once every few days for around 15 to 30 minutes at a time.

The mail sever seems to be shaky as well. I keep getting notices about the email accounts bouncing. Non of this has happened this regularly until just a few months ago.

I really like the service and tools offered by Directnic but I'm concerned about the down times we're experiencing so much lately.

I'm looking into Doster.com and stargateinc.com

If you have any suggestions for a reliable host (shared or dedicated) that can handle at least 250 gig of bandwidth traffic a month for a reasonable price let me knoe.

kyle · **Posted:** Tue Aug 21, 2007 5:11 pm

Their response, just to keep everyone in the loop, who are probably as frustrated with this host as I am...

Quote:

Date: 08/21/07 04:47pm
From: marcb

Hello Kyle,

I understand your frustrations completely, but all of these down times are scheduled maintenance and are in preparation of the upgrades to both the latest versions of SQL and PHP. Todays upgrades was to the H-Sphere OS interface to version 3 patch 4 (the latest update necessary for the upgrades of SQL and PHP), so please excuse these growing pains. However, in the long run, we are responding to our clients request to make these upgrades, so I hope you can just bear with us, in the eventuality of things getting better very soon.

We are sorry for any inconvenience this may have caused you.

Sincerely,

Marc Boudousquie

directNIC Support

This is bull though. Who the hell schedules server downtime in the middle of the day? I'd get fired from my job if I regularly dropped a production server for a software update at 1pm in the middle of the week.

I'm making plans to move our host.

Ricky Romero · **Posted:** Tue Aug 21, 2007 5:19 pm

The forum goes down every night between 1am-1:30am PST anyway, so why don't they do their upgrades then? Even if the upgrades take 2-3 hours, it would be less of an inconvenience than to "schedule" down time in the middle of the day.

kyle · **Posted:** Tue Aug 21, 2007 5:21 pm

Ricky Romero wrote:

The forum goes down every night between 1am-1:30am PST anyway, so why don't they do their upgrades then? Even if the upgrades take 2-3 hours, it would be less of an inconvenience than to "schedule" down time in the middle of the day.

The 1am - 1:30am down time things are because of me. I have my own series of back-ups. I don't trust our host.

Although, my back-ups shouldn't bring the forum down. It'll just make it run slower for about 10 minutes or so.

Ricky Romero · **Posted:** Tue Aug 21, 2007 10:35 pm

kyle wrote:

Although, my back-ups shouldn't bring the forum down. It'll just make it run slower for about 10 minutes or so.

For some reason IE won't bring the forum up during that window. Meh, no biggie. I need to take a half hour break per day. :lol:

Brash · **Posted:** Wed Aug 22, 2007 7:21 am

Quote:

Could not insert new word

DEBUG MODE

SQL Error : 145 Table './zombies_zsforumdb/phpbb_search_wordlist' is marked as crashed and should be repaired

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('actually', 0), ('alerts', 0), ('back', 0), ('came', 0), ('coincides', 0), ('email', 0), ('issues', 0), ('ive', 0), ('last', 0), ('mine', 0), ('night', 0), ('problems', 0), ('server', 0), ('usually', 0)

Line : 234
File : functions_search.php

This is a new error I've been getting all day. My post still works but I keep getting a general error message.

Lady_Helfyre · **Posted:** Wed Aug 22, 2007 7:36 am

I've been getting that same error message this morning.

Aeon · **Posted:** Wed Aug 22, 2007 9:42 am

I've been getting the same error all day.

magnus · **Posted:** Wed Aug 22, 2007 10:56 am

If the margins weren't so slim, and startup costs so high, I'd have to run a hosting company. I basically do this kind of stuff already internal to my employer and I know I could do a much better job than these knuckleheads.

spartan · **Posted:** Wed Aug 22, 2007 11:44 am

Brash wrote:

Quote:

Could not insert new word

DEBUG MODE

SQL Error : 145 Table './zombies_zsforumdb/phpbb_search_wordlist' is marked as crashed and should be repaired

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('actually', 0), ('alerts', 0), ('back', 0), ('came', 0), ('coincides', 0), ('email', 0), ('issues', 0), ('ive', 0), ('last', 0), ('mine', 0), ('night', 0), ('problems', 0), ('server', 0), ('usually', 0)

Line : 234
File : functions_search.php

This is a new error I've been getting all day. My post still works but I keep getting a general error message.

I am getting the same error as well. Ignore my PM Kyle, I just noticed this thread.

Brash · **Posted:** Wed Aug 22, 2007 11:59 am

Is it just me or is the index not showing the latest poster correctly? It seems frozen.

L1Z4RD · **Posted:** Wed Aug 22, 2007 12:02 pm

Yeah, theres some New Guy who's post count reads "1" but he's posted a few times already. I ignore the Debug err thing and continue because it still posts what I put. I think Dr.Gonzo quad posted somewhere today.

Brash · **Posted:** Wed Aug 22, 2007 12:09 pm

Yeah I just noticed that too. He's posted in several threads and several times in his ntro and still has a post count of 1.

kyle · **Posted:** Wed Aug 22, 2007 12:34 pm

It I wasn't busy I'd move the forum to a new host right now...

Quote:

Action: Reply
Date: 22-Aug-2007 (09:00)
From: marcb

Hello Kyle,

Access to PHP MyAdmin is going to be unavailable until the feature is reinstalled later today. As far as the SQL DB bugs, our administrators are working on this presently and will hopefully have this sorted out sometime later this afternoon. The existing contents of the databases will remain in tact, and will not be affected by this inconvenience. Believe me when I say that we are working on resolution of these problems as quickly as possible, and once the work is completed, the result will be more efficient database administration for both you and our programming team.

We are sorry for any inconvenience this may have caused you.

Sincerely,

Marc Boudousquie

directNIC Support

DrthTater · **Posted:** Wed Aug 22, 2007 1:15 pm

You should respond with this

Quote:

Hello Marc. In response to your latest email.

Bite me.

Sincerely,
Kyle

Just an idea.

Ricky Romero · **Posted:** Wed Aug 22, 2007 1:53 pm

Brash wrote:

Is it just me or is the index not showing the latest poster correctly? It seems frozen.

Yeah, it shows that the latest post in this forum was by me at 8:35 pm last night.

Ricky Romero · **Posted:** Wed Aug 22, 2007 1:56 pm

Brash wrote:

Is it just me or is the index not showing the latest poster correctly? It seems frozen.

Yeah, the latest post listed for this forum was by me at 8:35pm last night.

And this is my second attempt at posting this. The first time I got that error message everyone is talking about.

mrdbeau · **Posted:** Wed Aug 22, 2007 2:12 pm

Ok, so people need to realize that the posting error message DOES NOT actually prevent your post from going through. Even when you get the error message, your post goes through, so don't refresh, repost, whatever. I say that because we are getting shitloads of triple, quad, and even quintuple posts and I know it's a headache for the mods... and pretty annoying for everyone else, as well.

SlingsVaqueros · **Posted:** Wed Aug 22, 2007 5:55 pm

I've been going around and deleteing the double, triple, and sextuple posts people have been leaving. I usually don't delete posts for any reason, but this is getting silly...

Database problems with the ZS forums - 7/18/2007

Who is online