Whats the deal with the database

[Jokersmokesem]

Since yesterday I get it every time now. Last night I saw it for 40 minutes straight and then for 20 minutes. Today I have been seeing it here and there all day. Whats going on. I don't see any threads that have any info

[smackdownsrt]

Database error? Couple threads down.

database upgrade: Step 1 of 2 complete
Getting "Database Errors" on a regular basis

[Jokersmokesem]

Database error?

Getting "Database Errors" on a regular basis

Yes I posted there, but it seems the powers have not since yesterday. just wondering what was going on.

[bryan_k47]

Multiple threads on this
it is being worked on as far as I know

[Jokersmokesem]

Sorry for the repost. I just hadn't gotten this and between yesterday and today I've been getting hammered by them.

[bryan_k47]

Yeah now everytime I post I get an error, refresh the screen and the post is there
Weird

[jonny]

All threads are showing 0 replies, and the proper number of views. weird.

I have had database error only once.

[jonny]

All threads are showing 0 replies, and the proper number of views. weird.

I have had database error only once. Nope, twice....

[MattRobertson]

None of this had anything to do with the transition/upgrade. Sort of.

Our hosting company screwed up on our database upgrade of two days ago (you guys noticed its faster and isn't throwing errors anymore?); They did most of the job but forgot one part of it. They were supposed to fix that last night but the tech forced the database to shut down. This crashed a table that the forum needs to do all kinds of stuff. The tech didn't bother to read the logs when he restarted the db to find out if he'd caused any damage. So it took until 6 am when I got a phone call to find out we were up $hit creek.

Took two hours to repair the damage but we came back up around 8.

I know you guys want to blame the new forum software but that wasn't it :-)

[monty1269]

Can we blame the new forum software on the crappy forum searching ability then???

[MattRobertson]

Whats crappy about it? Featurewise? Performance?

[monty1269]

hhhmmm.. I see what yoou did there...

Looks like the search index rebuilt itself within the past hour or so??

[monty1269]

Can we search by "thread started by" ...???

[monty1269]

And how 'bout being able to filter sections when getting "new threads" like we used to!?

[MattRobertson]

Looks like the search index rebuilt itself within the past hour or so??

No. The search text table crashed last night and caused all of the grief we went thru overnight and this morning. When the site came back up it was after I repaired it. Before last night it also worked fine.

There is a whole database table that contains (almost) nothing but the text of every post. I assume this is so you can do a big scan of the table while other people are posting into it. Maybe (VBulletin was apparently designed by alien chimps on crack). This table exploded last night after a service tech at the hosting company did a bad thing and then never checked to see if he caused any damage.

Can we search by "thread started by" ...???

You always could. Go into Advanced Search. Click the Single Content type tab at screen top. That is the same old Advanced Search screen you are used to seeing on the old forum.

Let me guess... you never clicked on that? You've been using the other one? The sucky multicontent one that nobody has figured out?

Notice at screen bottom you can click to save your search prefs. Set it the way you want it to display as and when you come back it'll be like that again.