SQL database errors on all forum threads

[BadBoy0]

On my FFF S3 IPB forum at http://s3.forumforfree.com/nighthawk.html
I am now getting SQL error messages on any attempt to click on a thread.
Started after doing a delete operation on a thread from the moderator CP.
Admin CP still is non-functional too.

The SQL errors make the forum unusable at this point, I hope this can be fixed quickly. Is there any known operations at this point that should be avoided that cause this? I hope these database issues can be resolved soon.

[JJRedick4]

I think you gotta go to the Admin CP for this, and if u cant go in there then u gotta ask a more sure person cause I am not 100% sure.

[BadBoy0]

No this is a problem with the FFF database move the past couple days, the Forumer tech guy needs to fix it, since other forums have reported it. They need to still work on several such issues. The admin CP doesn't work at all and we don't have access to the database for problems like SQL errors anyway, only the forum hosting support staff can deal with that.
From other posts here, it appears only Limez can deal with issues like this?

[JJRedick4]

Then, maybe PM Limez just in case he doesnt see this thread.

[Firefang321]

He is currently dealing with alot of problems and private messaging him for just his attention will not be right.

[JJRedick4]

I think he already knows about this problem so I guess there isnt much point PMing him cause he is already trying to fix it.

[BadBoy0]

I assume posting in a thread here is what he expects from the previous requests, I haven't PMed him. I think these same issues have been reported by most of the FFF forums, so they all probably need similar fixes.

In my case the SQL error started after I deleted a thread. The forum was at least usable for posting to threads before that now none of the threads are accessable without the SQL error message preventing access, so that needs to be fixed to get back to the state it was. Now that I know not to delete a thread until other such issues are fully dealt with, I could avoid the short-term problem, if the resultant database error can be fixed easily. I hope others at least can learn from this and not attempt to delete any threads for now to avoid the SQL error preventing thread access for them at least.

[BadBoy0]

Will the Forumer support staff including Limez be working on the FFF forum problems like my forum's crippling SQL database errors over the weekend? Or is it known that it won't be handled until at least Monday?

[JJRedick4]

I dont think anyone except Limez has any idea on how its going.

[BadBoy0]

Does anyone know if Limez is working on the FFF forum issues over the weekend? I assume he is the only one dealing with the problems. Hopefully he reads the posts in this section fairly often regarding the current issues.

[BadBoy0]

For more detail and reference, here is the type of database error message I am getting from clicking on any of the threads at my forum: http://s3.forumforfree.com/nighthawk.html

mySQL query error: SELECT pid, post_date FROM nighthawk_posts WHERE queued <> 1 AND topic_id='2558' AND post_date > '' ORDER BY post_date LIMIT 1

mySQL error: Can't open file: 'nighthawk_posts.MYI' (errno: 145)
mySQL error code:
Date: Saturday 23rd of September 2006 06:38:34 PM

[HHDT]

http://hhdreamteam.18.forumer.com/ still have the same probleme since friday or saturday...

mySQL query error: SELECT DISTINCT(hhdreamteam_posts.author_id), hhdreamteam_topics.* FROM hhdreamteam_topics
LEFT JOIN hhdreamteam_posts ON
(hhdreamteam_topics.tid=hhdreamteam_posts.topic_id AND hhdreamteam_posts.author_id=3)
WHERE hhdreamteam_topics.forum_id=1
and hhdreamteam_topics.approved=1
and (hhdreamteam_topics.pinned=1 or hhdreamteam_topics.last_post > 1156505166) ORDER BY pinned DESC, last_post DESC LIMIT 0,20

mySQL error: Can't open file: 'hhdreamteam_posts.MYI' (errno: 145)
mySQL error code:
Date: Sunday 24th of September 2006 06:26:06 AM

[BadBoy0]

I notice that My FFF IPB forum database SQL error problem has just been fixed, thank you!
For reference, it started when I deleted a group of threads from the moderator controls. So I will avoid deleting any threads for now and perhaps others should avoid that as well, until host support staff posts here to indicate if thread deletion should work OK without producing a database problem.

Thanks again!

[CieloAzul]

http://s3.forumforfree.com/index.php?mforum=thedenpire&

Please help! Our forum is completely unusable. We receive errors when anything is clicked on. It's been having problems since 9-19

[Limez]

Originally Posted by HHDT

http://hhdreamteam.18.forumer.com/ still have the same probleme since friday or saturday...

fixed.