 |
tzone Educate Communicate and Inform with transgenderzone.com
|
| Welcome |
|
|
Welcome to tzone.
You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, join our community today! |
| View previous topic :: View next topic |
| Author |
Message |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
Posted: Sat Nov 10, 2007 10:24 pm Post subject: Database trouble |
|
|
There have been a few problems of late with our beloved forum.
Strange messages have been appearing from which I sense that the database is becoming increasingly corrupt.
Lately I've been logged out for no reason and tonight, I find it does this every minute or so...
Please, whatever it takes, can we have the raw data exported, the tables and indexes rebuilt...
Thanks
Reenie _________________ The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
 |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
Posted: Sat Nov 10, 2007 10:26 pm Post subject: |
|
|
It took me a couple of attempts to get this to post. With delicious irony, the first failed:
| Quote: | Could not obtain common word list
DEBUG MODE
SQL Error : 1194 Table 'w' is marked as crashed and should be repaired
SELECT m.word_id FROM tzone_search_wordmatch m, tzone_search_wordlist w WHERE w.word_text IN ('appearing', 'becoming', 'beloved', 'corrupt', 'data', 'database', 'exported', 'few', 'forum', 'increasingly', 'indexes', 'ive', 'late', 'lately', 'logged', 'loggedin', 'maintaining', 'messages', 'minute', 'problems', 'raw', 'reason', 'rebuilt', 'reenie', 'sense', 'state', 'strange', 'tables', 'takes', 'thanks', 'tonight', 'whatever') AND m.word_id = w.word_id GROUP BY m.word_id HAVING COUNT(m.word_id) > 7382
Line : 309
File : functions_search.php |
_________________ The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
 |
Han79

Joined: 05 Nov 2007 Posts: 365 Location: West Midlands - UK
|
Posted: Sat Nov 10, 2007 10:30 pm Post subject: |
|
|
I noticed that things were getting a little "slow"  _________________ Most of the time, most people do what most people do most of the time.
|
|
| Back to top |
|
 |
PurplePrincess Advisor


Joined: 08 Feb 2007 Posts: 2678 Location: Bristol
|
Posted: Sat Nov 10, 2007 10:57 pm Post subject: |
|
|
I think the hosts freeforums.org are having problems with their servers again, I'm going to check out their support site. I am an administrator on my own freeforums chat forum and I think the problem is at the hosts end. There isn't much we can do from this end apart from make the hosts freeforums aware of the problems and hope they can get it sorted soon.
I have been logged in and out like a yo-yo and post notifications have disappeared and reappeared. I am no expert but it seems like the different servers the hosts use are out of sync or something like that. _________________ Chrissy
Forums Moderator.
Always have faith and believe in yourself.
Never run from the truth.
Have the will to change your fate and your spirit will never die.
Check out the tzone team bios here: http://www.transgenderzone.com/bio.htm

|
|
| Back to top |
|
 |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
Posted: Sat Nov 10, 2007 11:01 pm Post subject: |
|
|
I'd thought it a problem with cookies or some such on my machine, but the SQL error nails it to a server database problem. _________________ The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
 |
PurplePrincess Advisor


Joined: 08 Feb 2007 Posts: 2678 Location: Bristol
|
Posted: Sat Nov 10, 2007 11:09 pm Post subject: |
|
|
Well I've looked on the freeforums support site and all they are saying is that they are working hard to resolve the login problems. It seems that quite a few forums that are hosted by freeforums are affected. I remember we had some problems like this a while ago and they got sorted out, hopefully it won't take too long to sort out again They do seem to have problems like this after they have done a big server upgrade. _________________ Chrissy
Forums Moderator.
Always have faith and believe in yourself.
Never run from the truth.
Have the will to change your fate and your spirit will never die.
Check out the tzone team bios here: http://www.transgenderzone.com/bio.htm

|
|
| Back to top |
|
 |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
Posted: Sat Nov 10, 2007 11:13 pm Post subject: |
|
|
Thanks Chrissy!  _________________ The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
 |
Herb

Joined: 29 Aug 2007 Posts: 339 Location: Greater London Co-Prosperity Sphere, UK
|
Posted: Sat Nov 10, 2007 11:21 pm Post subject: |
|
|
If you could give me an idea of the total bandwidth, I'd be more than happy to contemplate hosting it myself if the bandwidth isn't excessive. That at least, would remove the 3rd party unreliability. _________________ The boobs are just a set of metaphors.
|
|
| Back to top |
|
 |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
Posted: Sat Nov 10, 2007 11:58 pm Post subject: |
|
|
Speak Icey... _________________ The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
 |
GenderQuest

Joined: 12 Oct 2007 Posts: 451
|
|
| Back to top |
|
 |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
|
| Back to top |
|
 |
Nathan Tzoner

Joined: 19 May 2007 Posts: 810 Location: Brighton
|
Posted: Sun Nov 11, 2007 5:13 pm Post subject: |
|
|
recently it seems to take a gud 8/9 attempts before i can log in and i have to again every time i post.
not only that but it didnt show up one of my posts till the next day
forum seems to be behaving itself today, or so far... _________________ "...risk something, take back whats yours, say something that you know they might attack you for..."
|
|
| Back to top |
|
 |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
Posted: Sun Nov 25, 2007 11:02 am Post subject: |
|
|
Could not obtain common word list
DEBUG MODE
SQL Error : 1194 Table 'w' is marked as crashed and should be repaired
SELECT m.word_id FROM tzone_search_wordmatch m, tzone_search_wordlist w WHERE w.word_text IN ('cool', 'keep', 'perhaps', 'side', 'tfk', 'thefrostking', 'wink') AND m.word_id = w.word_id GROUP BY m.word_id HAVING COUNT(m.word_id) > 7832
Line : 309
File : functions_search.php _________________ The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
 |
Reenie Reporter


Joined: 08 Feb 2007 Posts: 3577 Location: Glasgow
|
Posted: Wed Dec 12, 2007 8:45 am Post subject: |
|
|
Admin: please can we resync "My Story and Daily Blogs" section?
My thread and a few others keep generating "Post or Topic not found" errors when looking for the last post in the thread or when posting to the thread.
Ta.
|
|
| Back to top |
|
 |
thefishkeeper Advisor

Joined: 09 Feb 2007 Posts: 1487 Location: Reading
|
Posted: Wed Dec 12, 2007 10:33 am Post subject: |
|
|
Reenie,
it seems that the forum is generating the next page when the post's get to a certain volum on the live page. We have said some thing but it still keeps happening. They may or may not be able to sort this out.
Nathan.
I too had problems getting on to the forums. So I now go the long way around, that is on tothe home page then follow the links. Try that and se if it helps.
 _________________ " Too many years fighting the tears, Why can't the past just die. Try to for give, teach me to live, give me the strength to try. No more memories, no more silent tears, no more gazing across the wasted years, help me to say. Goodbye"
From Phantom Of The Opera
Fishkeeper is Admin staff for FTM's.
My Bio. http://www.transgenderzone.com/bio.htm
we have a library
http://www.transgenderzone.com/library
feel free to browse
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
|
|