If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Database error on specific thread.

sink · 2008-09-11 15:51:58

The 'Obama on Bill O'Reilly' in the 'US Election 2008' sub forum of the politics board is currently unaccessible. This doesn't seem to be happening for any other thread. http://www.boards.ie/vbulletin/showthread.php?t=2055375723

Options

11-09-2008 4:51pm

#1

sink

Registered Users Posts: 4,314 ✭✭✭

Join Date: May 2005

Posts: 4221

The 'Obama on Bill O'Reilly' in the 'US Election 2008' sub forum of the politics board is currently unaccessible. This doesn't seem to be happening for any other thread.

Database Error Database error
The boards.ie database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.boards.ie home page, then try to open another page.
* Click the Back button to try another link.

The www.boards.ie forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

http://www.boards.ie/vbulletin/showthread.php?t=2055375723

Post edited by Shield on December 2021

0

Comments

Options
#2 11-09-2008 4:54pm
unkel

Registered Users Posts: 65,436 ✭✭✭✭

Chauffe, Marcel, chauffe!

Join Date: November 2001

Posts: 64169

You're a bit paranoid

Loads of forums, categories and specific threads have been giving database errors all afternoon. The index has been fine. Adverts.ie is down too. Nothing on twitter unfortunately...

My ads on adverts.ie
https://www.adverts.ie/member/5856/ads

0
Options
#3 11-09-2008 5:18pm
CuLT

Subscribers Posts: 9,716 ✭✭✭

Join Date: March 2001

Posts: 9316

Report any more of these here please, ran a pretty lightning fast repair on the DB just there, not sure if it actually repaired all the problems.

0
Options
#4 11-09-2008 5:20pm
Adam

Closed Accounts Posts: 8,866 ✭✭✭

Join Date: September 2004

Posts: 8557

CuLT wrote: »

Report any more of these here please, ran a pretty lightning fast repair on the DB just there, not sure if it actually repaired all the problems.

just got that old duplicate post error even though the post submitted there on my last post in the lair in noc forum

0
Options
#5 11-09-2008 7:09pm
Lenny

Moderators, Music Moderators, Recreation & Hobbies Moderators Posts: 9,389 Mod ✭✭✭✭

Join Date: May 2000

Posts: 8888

one in bargain alert happening too aswell,
the one with the gears of war title

0
Options
#6 12-09-2008 10:49am
stovelid

Closed Accounts Posts: 27,252 ✭✭✭✭

Join Date: January 2006

Posts: 27017

Haven't seen an error since yesterday, but boards slow for me this morning. Some pages really hanging.

0
Advertisement
Options
#7 12-09-2008 11:55am
Mr. Presentable

Closed Accounts Posts: 9,496 ✭✭✭

Join Date: September 2004

Posts: 8848

I am finding "page not found" on the V12TDI thread in Motors. Others I have tried seem OK. System is slow

0
Options
#8 12-09-2008 3:18pm
eVeNtInE

Registered Users Posts: 7,020 ✭✭✭

Join Date: May 2008

Posts: 6560

This post has been deleted.

0
Options
#9 12-09-2008 3:34pm
stovelid

Closed Accounts Posts: 27,252 ✭✭✭✭

Join Date: January 2006

Posts: 27017

Same.

0
Options
#10 12-09-2008 4:09pm
CuLT

Subscribers Posts: 9,716 ✭✭✭

Join Date: March 2001

Posts: 9316

Fixed the problem with pages hanging earlier, haven't noticed any db errors. If you find them, link to the location if you can, would help greatly.

Edit: repaired a slight problem there, may have disappeared the errors.

0
Options
#11 12-09-2008 5:13pm
Adam

Closed Accounts Posts: 8,866 ✭✭✭

Join Date: September 2004

Posts: 8557

CuLT wrote: »

Fixed the problem with pages hanging earlier, haven't noticed any db errors. If you find them, link to the location if you can, would help greatly.

Edit: repaired a slight problem there, may have disappeared the errors.

just got another 'this post is a duplicate' error on a quick reply, linky: http://www.boards.ie/vbulletin/showpost.php?p=57235723&postcount=37946

0
Advertisement
Options
#12 12-09-2008 5:20pm
CuLT

Subscribers Posts: 9,716 ✭✭✭

Join Date: March 2001

Posts: 9316

Mirror wrote: »

just got another 'this post is a duplicate' error on a quick reply, linky: http://www.boards.ie/vbulletin/showpost.php?p=57235723&postcount=37946

I want to get database errors out of the way before anything else right now, will look into that when I'm satisfied the db isn't choking anymore.

0
Options
#13 12-09-2008 9:44pm
Jonathan

Moderators, Education Moderators, Home & Garden Moderators Posts: 8,171 Mod ✭✭✭✭

Join Date: May 2006

Posts: 7932

m.boards seems to be acting up.

First it was showing me the wrong subbed forum list, then logging me out and showing the full version of boards.

Now the subbed threads are showing up as a time about 18:00 when i know there has been posts in those threads after.

0
Options
#14 14-11-2008 3:24am
sparkzter

Registered Users Posts: 177 ✭✭

Join Date: May 2008

Posts: 171

Sorry about posting in an old thread but I cant seem to access many at the moment? For example, I currently cannot access any of the Music threads...... ie: when I click on this [url] http://www.boards.ie/vbulletin/forumdisplay.php?f=233 [/url]
I get the " boards.ie database has encountered an error" message..... anyone else having this??
I only got to this thread through 'googling' the error message....

0

Options

#15 14-11-2008 3:27am

Trojan

Registered Users Posts: 16,413 ✭✭✭✭

Join Date: February 1998

Posts: 15134

There's a MySQL problem viewing forums directly, but not threads.

The error output is as follows:

Database error in vBulletin 3.7.3:

Invalid SQL:

		SELECT moderator.*, user.username,
		IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
		FROM moderator AS moderator
		INNER JOIN user AS user USING(userid);

MySQL Error   : Got error 134 from storage engine
Error Number  : 1030
Request Date  : Friday, November 14th 2008 @ 02:26:23 AM
Error Date    : Friday, November 14th 2008 @ 02:26:23 AM
Script        : http://www.boards.ie/vbulletin/forumdisplay.php?f=1
Referrer      : 
IP Address    : 84.1.111.111
Username      : Trojan
Classname     : vB_Database
MySQL Version : 5.0.22-log

🎙️ The Recognized Authority Podcast

Options
#16 14-11-2008 3:28am
AlmightyCushion

Moderators, Education Moderators, Technology & Internet Moderators Posts: 35,079 Mod ✭✭✭✭

Join Date: April 2006

Posts: 33520

sparkzter wrote: »

Sorry about posting in an old thread but I cant seem to access many at the moment? For example, I currently cannot access any of the Music threads...... ie: when I click on this [url] http://www.boards.ie/vbulletin/forumdisplay.php?f=233 [/url]
I get the " boards.ie database has encountered an error" message..... anyone else having this??
I only got to this thread through 'googling' the error message....

See this post onwards (http://www.boards.ie/vbulletin/showpost.php?p=57897540&postcount=542). All forums seem to be affected. Threads seem to be working fine. To find a thread put "site:boards.ie" and the name of the thread you are looking in to google.

0
Options
#17 14-11-2008 3:58am
sparkzter

Registered Users Posts: 177 ✭✭

Join Date: May 2008

Posts: 171

AlmightyCushion wrote: »

See this post onwards (http://www.boards.ie/vbulletin/showpost.php?p=57897540&postcount=542). All forums seem to be affected. Threads seem to be working fine. To find a thread put "site:boards.ie" and the name of the thread you are looking in to google.

Thanks for that as the last post also said that forums were affected & not individual threads, I just didnt know how to access a thread directly, so thanks a million for that!

0
Options
#18 14-11-2008 4:05am
AlmightyCushion

Moderators, Education Moderators, Technology & Internet Moderators Posts: 35,079 Mod ✭✭✭✭

Join Date: April 2006

Posts: 33520

sparkzter wrote: »

Thanks for that as the last post also said that forums were affected & not individual threads, I just didnt know how to access a thread directly, so thanks a million for that!

Not a bother, man.

0
Options
#19 14-11-2008 11:44am
Earthhorse

Registered Users Posts: 14,714 ✭✭✭✭

Join Date: September 2002

Posts: 14661

CuLT wrote: »

Report any more of these here please, ran a pretty lightning fast repair on the DB just there, not sure if it actually repaired all the problems.

Would this be causing certain users to appear as guest?

And by certain users I mean Dudess. Or is that not a "mistake".

0
Options
#20 14-11-2008 11:48am
javaboy

Registered Users Posts: 15,094 ✭✭✭✭

Join Date: October 2007

Posts: 14818

Earthhorse wrote: »

Would this be causing certain users to appear as guest?

And by certain users I mean Dudess. Or is that not a "mistake".

Ignored my advice eh Hoss? Now everybody's going to realise you're a stalker.

Next comes the questions about where to find accommodation in Cork. It's like Jigsaw all over again.

0
Options
#21 14-11-2008 11:49am
Earthhorse

Registered Users Posts: 14,714 ✭✭✭✭

Join Date: September 2002

Posts: 14661

javaboy wrote: »

Ignored my advice eh Hoss? Now everybody's going to realise you're a stalker.

Next comes the questions about where to find accommodation in Cork. It's like Jigsaw all over again.

Way to help this go smoothly.

0
Advertisement
Options
#22 14-11-2008 11:52am
javaboy

Registered Users Posts: 15,094 ✭✭✭✭

Join Date: October 2007

Posts: 14818

Earthhorse wrote: »

Way to help this go smoothly.

Sorry Hoss. I'm a bit of a cockblocker at times. Carry on.

0
Options
#23 14-11-2008 12:05pm
Steve

Moderators, Category Moderators, Entertainment Moderators, Sports Moderators Posts: 22,584 CMod ✭✭✭✭

Join Date: February 2006

Posts: 21207

Earthhorse wrote: »

Would this be causing certain users to appear as guest?

And by certain users I mean Dudess. Or is that not a "mistake".

Where is her account gone???

http://www.boards.ie/vbulletin/member.php?u=48142

Oh dear.

0
Options
#24 14-11-2008 12:16pm
CuLT

Subscribers Posts: 9,716 ✭✭✭

Join Date: March 2001

Posts: 9316

I think I've fixed her now. Mostly.

0
Options
#25 14-11-2008 12:21pm
Dave!

Closed Accounts Posts: 27,857 ✭✭✭✭

Join Date: August 2005

Posts: 26627

No more doobing on the job Cult!

Seems to be working alright now. That got a bit hairy for a while! :eek:

0
Options
#26 14-11-2008 12:22pm
Steve

Moderators, Category Moderators, Entertainment Moderators, Sports Moderators Posts: 22,584 CMod ✭✭✭✭

Join Date: February 2006

Posts: 21207

CuLT wrote: »

I think I've fixed her now. Mostly.

That just sounds wrong on so many levels..

:D:D:D

0
Options
#27 14-11-2008 12:23pm
Earthhorse

Registered Users Posts: 14,714 ✭✭✭✭

Join Date: September 2002

Posts: 14661

CuLT wrote: »

I think I've fixed her now. Mostly.

Only thing that seems to be missing is her avatartar.

And she still has those kooky, left-wing beliefs.

Can't fix that.

0
Options
#28 14-11-2008 7:46pm
Dudess

Closed Accounts Posts: 37,214 ✭✭✭✭

Join Date: July 2005

Posts: 35866

CuLT wrote: »

I think I've fixed her now. Mostly.

Thanks a lot CuLT. And I think Vexorg.

0
Options
#29 14-11-2008 8:32pm
Earthhorse

Registered Users Posts: 14,714 ✭✭✭✭

Join Date: September 2002

Posts: 14661

Dudess wrote: »

Thanks a lot CuLT. And I think Vexorg.

Oh sure, CuLT probably wrote a script to fix this and Vexorg gave him the technical advice to do it but I was the one who was annoyed enough to bring it to their attention!

0
Options
#30 14-11-2008 8:39pm
javaboy

Registered Users Posts: 15,094 ✭✭✭✭

Join Date: October 2007

Posts: 14818

Earthhorse wrote: »

Oh sure, CuLT probably wrote a script to fix this and Vexorg gave him the technical advice to do it but I was the one who was stalkery enough to bring it to their attention!

+1. And don't forget who broke it in the first place Dudess.

0
Advertisement