FAQ |
Members List |
Calendar |
Search |
Today's Posts |
|
Announcements / Suggestions / Help Announcements from Admin, member suggestions and forum help |
Reply |
|
Thread Tools | Display Modes |
01-06-2007, 01:47 PM | #1 | ||
|
|||
Senior Member
|
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.
I managed to type this now, but I hope whatever's up gets sorted. |
||
Reply With Quote |
01-06-2007, 01:53 PM | #2 | ||
|
|||
Banned
|
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 |
||
Reply With Quote |
01-06-2007, 01:53 PM | #3 | |||
|
||||
Senior Member
|
Yeah, it happened to everyone. It's basically because so many people are using the site just now.
|
|||
Reply With Quote |
01-06-2007, 01:55 PM | #4 | ||
|
|||
Senior Member
|
Oh right - thanks James. I got worried and thought it was just me.
It's working now anyway. |
||
Reply With Quote |
01-06-2007, 01:56 PM | #5 | ||
|
|||
Banned
|
Yes, thanks James
It seems okay now.... nodisharmony |
||
Reply With Quote |
01-06-2007, 02:13 PM | #6 | ||
|
|||
Banned
|
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 |
||
Reply With Quote |
01-06-2007, 02:20 PM | #7 | |||
|
||||
Senior Member
|
Todays posts also showed up as 99 pages before. lol
|
|||
Reply With Quote |
01-06-2007, 02:23 PM | #8 | |||
|
||||
Senior Member
|
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
|
|||
Reply With Quote |
01-06-2007, 02:27 PM | #9 | ||
|
|||
Banned
|
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 |
||
Reply With Quote |
01-06-2007, 02:49 PM | #10 | |||
|
||||
Senior Member
|
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.
|
|||
Reply With Quote |
01-06-2007, 03:02 PM | #11 | ||
|
|||
Banned
|
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 |
||
Reply With Quote |
01-06-2007, 03:06 PM | #12 | ||
|
|||
Banned
|
I couldn't delete it
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 |
||
Reply With Quote |
01-06-2007, 05:01 PM | #13 | |||
|
||||
GetReadyToFly
|
Quote:
|
|||
Reply With Quote |
02-06-2007, 10:40 AM | #14 | |||
|
||||
Senior Member
|
I hate database errors. Go TiBB!
|
|||
Reply With Quote |
02-06-2007, 10:41 AM | #15 | |||
|
||||
Senior Member
|
The Good News was it was fine last night with around 70 users and 240 guest on.... so things are looking good.
|
|||
Reply With Quote |
02-06-2007, 10:44 AM | #16 | |||
|
||||
Senior Member
|
Quote:
|
|||
Reply With Quote |
02-06-2007, 10:55 AM | #17 | |||
|
||||
Senior Member
|
We will see the eviction nights well tell us how well things are going. We get a lot of traffic.
|
|||
Reply With Quote |
02-06-2007, 11:07 AM | #18 | |||
|
||||
Senior Member
|
Quote:
|
|||
Reply With Quote |
07-06-2007, 08:03 PM | #19 | ||
|
|||
Banned
|
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 |
||
Reply With Quote |
07-06-2007, 08:06 PM | #20 | |||
|
||||
Senior Member
|
It's fixed now.
|
|||
Reply With Quote |
07-06-2007, 08:16 PM | #21 | ||
|
|||
Banned
|
That's great James
nodisharmony |
||
Reply With Quote |
07-06-2007, 08:16 PM | #22 | |||
|
||||
GetReadyToFly
|
Oh thats good, thanks for fixing it james.
|
|||
Reply With Quote |
Reply |
|
|