Help! - Forum accessing problems!

[Bells]

Something weird keeps happening now and again on the forum... I'm not too brilliant with computers but when I click on a particular section some weird text comes up, and at other times it says there's something wrong with the database connection. :conf:

I managed to type this now, but I hope whatever's up gets sorted.

[nodisharmony]

I just made a post, then this warning came up:-

-------------------------------------------------------------------
Database connection error!
A connection to the Database could not be established.
Please check your username, password, database name and host.
Also make sure config.php is rightly configured!
-------------------------------------------------------------------

Then, when I was trying to look at todays posts & then clicking back to the forums home page:-
-------------------------------------------------------------------

MySQL encountered the following error: Lost connection to MySQL server during query
In the following query: SELECT username FROM bbf_members ORDER BY regdate DESC LIMIT 1


and then:-


MySQL encountered the following error: Lost connection to MySQL server during query
In the following query: SELECT t.* FROM bbf_threads t WHERE t.fid='39' ORDER BY topped desc,lastpost desc LIMIT 0, 40

and then:-

MySQL encountered the following error: Lost connection to MySQL server during query
In the following query: SELECT count(tid) FROM bbf_threads WHERE fid='39'



Is there a problem with the site at the moment???

Perhaps it's overloading or something else?







nodisharmony :angel:

[James]

Yeah, it happened to everyone. It's basically because so many people are using the site just now.

[Bells]

Oh right - thanks James. I got worried and thought it was just me. :hugesmile:
It's working now anyway.

[nodisharmony]

Yes, thanks James:thumbs:

It seems okay now....







nodisharmony :angel:

[nodisharmony]

I was posting in the BB Lounge & my post & Red Moon's posts have multiplied.

I got this error:-

MySQL encountered the following error: Incorrect key file for table: 'bbf_threads'. Try to repair it
In the following query: UPDATE bbf_threads SET lastpost='1180706815|nodisharmony', replies=replies+1 WHERE (tid='38926' AND fid='160') OR closed='moved|38926'

and things are going wrong still.

I am sure it will be solved before tonight.





nodisharmony :angel:

[Mrluvaluva]

Todays posts also showed up as 99 pages before. lol

[BigSister]

Last night i clicked on some threads and they were coming up with posts from a week ago but not the ones that i wanted to read, its sorted now though

[nodisharmony]

It could be an intermittent problem BigSister.

Okay now, but in 30 minutes something else??

I am sure it will be sorted. It is not that busy on the forum at this particular time of day.






nodisharmony

[Mrluvaluva]

I have been having a few problems recently where as I can't see the latest posts in a thread - only up to a certain point if there are many pages. It seems to happen most in the lounge, but then, I do spend most of my time in there. :spin:

[nodisharmony]

I have just worked out what has gone wrong with the multiplying of posts with myself, " ~~ " & Red Moon within the BB Lounge.

I just made a post, then clicked "Reply" & suddenly, this error message came up:-

MySQL encountered the following error: Incorrect key file for table: 'bbf_threads'. Try to repair it
In the following query: UPDATE bbf_threads SET lastpost='1180708939|nodisharmony', replies=replies+1 WHERE (tid='38926' AND fid='160') OR closed='moved|38926'

I then clicked "Refresh current page" on my browser & then a small window appears saying, "Retry", then the same warning message appears again. I repeated that three times, which has caused it to multiply three times extra.

I then opened another window on my computer, got onto the site again and saw that my post had multiplied.

Also, on the "Chat & Games" page/folder, where the "BB Lounge" is kept.

It says that there is 493 pages in the BB Lounge, "Red Moon" being the name of the person who posted last. but when you click on the link, there is 496 pages. and " ~~ " was the last member who posted.

I shall delete my multiple posts within that thread now, If it lets me??






nodisharmony :angel:

[nodisharmony]

I couldn't delete it:sad:

Came up with:-
MySQL encountered the following error: Incorrect key file for table: 'bbf_threads'. Try to repair it
In the following query: UPDATE bbf_threads SET replies='12380', lastpost='1180709625|~~' WHERE tid='38926'







nodisharmony :angel:

[Ruth*Star]

Originally posted by BigSister
Last night i clicked on some threads and they were coming up with posts from a week ago but not the ones that i wanted to read, its sorted now though
It did that too me, i thought it was me so i did loads of spywear and antivirus checks convinced i had messed up my pc in some way. but its cool the forums back now.

[Matt]

I hate database errors. Go TiBB!

[Red Moon]

The Good News was it was fine last night with around 70 users and 240 guest on.... so things are looking good.

:thumbs:

[Matt]

Originally posted by Red Moon
The Good News was it was fine last night with around 70 users and 240 guest on.... so things are looking good.

:thumbs:

Brilliant - you're coping well then!

[Red Moon]

We will see the eviction nights well tell us how well things are going. We get a lot of traffic.

[Matt]

Originally posted by Red Moon
We will see the eviction nights well tell us how well things are going. We get a lot of traffic.

Why doesnt that surprise me? :wink:

[nodisharmony]

I don't know whether anyone else has had some problems with accessing pages on the forum at the moment??

Anyway, 15 minutes ago, this happened:-

todays posts:-

MySQL encountered the following error: Can't open file: 'bbf_threads.MYI'. (errno: 145)
In the following query: SELECT tid FROM bbf_threads WHERE lastpost >= '1181159003' AND fid IN(1, 4, 5, 13, 7, 12, 39, 40, 45, 76, 88, 86, 87, 93, 91, 94, 119, 101, 120, 139, 160, 162, 163, 165, 178, 182, 186, 189, 187, 188, 190, 191, 192, 193, 194, 195, 196, 200, 198, 201, 199, 202, 203, 204, 205, 206, 207, 208, 209, 210, 212)

todays posts(big brother only):-


MySQL encountered the following error: Can't open file: 'bbf_threads.MYI'. (errno: 145)
In the following query: SELECT tid FROM bbf_threads WHERE lastpost >= '1181159402' AND fid IN(1, 4, 5, 7, 40, 87, 119, 139, 163, 165, 182, 186, 200, 198, 201, 199, 202, 203, 204, 205, 206, 207, 208, 209, 210, 212)

big brother forum page:-


MySQL encountered the following error: Can't open file: 'bbf_threads.MYI'. (errno: 145)
In the following query: SELECT l.*, f.private, f.userlist, f.name, f.fid FROM bbf_threads l, bbf_forums f WHERE l.lastpost >= '1181159064' AND l.fid = f.fid ORDER BY l.lastpost DESC LIMIT 25

big brother main page:-

MySQL encountered the following error: Can't open file: 'bbf_threads.MYI'. (errno: 145)
In the following query: SELECT COUNT(*) FROM bbf_threads


podcast episode 3:-

MySQL encountered the following error: Can't open file: 'bbf_threads.MYI'. (errno: 145)
In the following query: SELECT f.fid, f.theme FROM bbf_forums f, bbf_threads t WHERE f.fid=t.fid AND t.tid='61013'

forum stats:-

MySQL encountered the following error: Can't open file: 'bbf_threads.MYI'. (errno: 145)
In the following query: SELECT COUNT(tid) FROM bbf_threads

control panel:-


MySQL encountered the following error: Can't open file: 'bbf_threads.MYI'. (errno: 145)
In the following query: SELECT * FROM bbf_favorites f, bbf_threads t, bbf_posts p WHERE f.tid=t.tid AND p.tid=t.tid AND p.subject=t.subject AND f.username='nodisharmony' AND f.type='favorite' ORDER BY t.lastpost DESC LIMIT 0,5


It could just be a busy time??



I have added these error messages, just in case it may help??






nodisharmony :angel:

[James]

It's fixed now.

:thumbs:

[nodisharmony]

That's great James:thumbs:






nodisharmony :angel:

[Ruth*Star]

Oh thats good, thanks for fixing it james.