Guys/Gals can you do us a favour?

Printed from http://www.compatdb.org/support/topics/70555_guys_gals_can_you_do_us_a_favour.html

Guys/Gals can you do us a favour? - 07/24/01 08:25 PM

OK, this is a weird one.
I frequent [url=www.matroxusers.com]www.matroxusers.com[/url] as I used to have a G400MAX in my main system.
For the past hour, whenever I've tried to view any threads on their forums I get an error message.
Normally I'd just assume their forum's were down, however I can view the actual forum and there are new threads appearing and the count in some of the other threads is going up!
Anyway, if anybody has got a spare second, can they really quickly pop along to:

http://forums.matroxusers.com/

Click the general hardware/software forum and then click on any of the threads.
Can you view the thread or do you get an error message too?

Yes, bizarre post and I hope it doesn't break any guidelines here.

Re: Guys/Gals can you do us a favour? - 07/24/01 08:43 PM

Look like the "posts" table in their database is broken:

Code:
Database error in vBulletin: Invalid SQL: 
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM
post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                       LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
                                            AND session.userid > 0
                                            AND user.invisible = 0
                                            AND session.lastactivity>995994819)
WHERE
post.postid IN (0,204959)
ORDER BY dateline 

mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Tuesday 24th of July 2001 01:28:39 PM
Script: /showthread.php?threadid=27474
Referer: [url]http://forums.matroxusers.com/forumdisplay.php?forumid=8[/url]

Re: Guys/Gals can you do us a favour? - 07/24/01 10:01 PM

Thanks a lot! smile
Pleased to know it's not just me, cheers!