 |
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: Tue Oct 09, 2007 4:36 pm Post subject: SQL Errors |
 |
|
I keep getting error messages such as...
| Quote: | | SQL Error : 1194 Table 'w' is marked as crashed and should be repaired |
What does this portend, I wonder... 
_________________
The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
 |
Stella Maru
Joined: 11 Feb 2007
Posts: 2248
Location: Brighton
|
| Posted: Tue Oct 09, 2007 5:12 pm Post subject: |
|
|
I've had that three or four times, Reenie, but don't know what it means, either.
|
|
| Back to top |
|
|
Cayden
Joined: 01 Mar 2007
Posts: 412
|
| Posted: Tue Oct 09, 2007 7:41 pm Post subject: |
|
|
it means someone hit the big red button...
_________________
僕は男の人です
|
|
| Back to top |
|
|
Skyler
Tzoner
Joined: 08 Feb 2007
Posts: 934
Location: Canada
|
| Posted: Tue Oct 09, 2007 9:14 pm Post subject: |
|
|
w? what a silly name for a table
|
|
| Back to top |
|
|
PurplePrincess
Advisor
Joined: 08 Feb 2007
Posts: 2678
Location: Bristol
|
| Posted: Tue Oct 09, 2007 9:42 pm Post subject: |
|
|
I've visited the freeforums support forum and in a post that someone made about the SQL errors yesterday they say that they are aware of this error and will have it resolved as soon as possible. The post has been marked [RESOLVED] on the support forum which would suggest that they have resolved it (hopefully, lol). _________________ 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 |
|
|
Nathan
Tzoner
Joined: 19 May 2007
Posts: 810
Location: Brighton
|
| Posted: Tue Oct 09, 2007 10:13 pm Post subject: |
|
|
they mayve resolved the error messages but the forum has got a LOT slower today. or maybe its just my computer...
_________________
"...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: Wed Oct 10, 2007 11:24 am Post subject: |
|
|
| Quote: |
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 ('36th', '39', 'birthday', 'decided', 'discover', 'doctor', 'dump', 'eighteen', 'expected', 'finally', 'gave', 'girlfriend', 'guy', 'hazard', 'ive', 'known', 'later', 'months', 'mtf', 'onwards', 'pretending', 'rushed', 'silence', 'since', 'suffered', 'teens', 'told', 'transgendered', 'transition', 'trouble', 'two', 'tzone', 'welcome', 'years', 'yourself') AND m.word_id = w.word_id GROUP BY m.word_id HAVING COUNT(m.word_id) > 6349
Line : 309
File : functions_search.php |
Just had this at 12:23, so not resolved.
And yes, w is a silly name for a table.
_________________
The Daily Turnout - King of the Throne Room
|
|
| Back to top |
|
|
Stephanie
Joined: 04 Oct 2007
Posts: 5
|
| Posted: Wed Oct 10, 2007 12:34 pm Post subject: |
|
|
Yeah but w is just the alias not the table name ;)
tzone_search_wordlist w WHERE w.word_text
Instead of
tzone_search_wordlist WHERE tzone_search_wordlist.word_text
Makes for less typing :o)
|
|
| Back to top |
|
|
Flameboy
Advisor
Joined: 29 Mar 2007
Posts: 1653
Location: Manchester
|
| Posted: Thu Oct 11, 2007 8:54 pm Post subject: |
|
|
I just got the same error:
| 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 ('acting', 'azaria', 'book', 'chief', 'comic', 'cool', 'dave', 'enjoyed', 'fatboy', 'guy', 'hank', 'hearing', 'including', 'might', 'moe', 'next', 'number', 'part', 'run', 'simpsons', 'sosmething', 'sure', 'try', 'voice', 'voices', 'weekend', 'weve', 'wiggum') AND m.word_id = w.word_id GROUP BY m.word_id HAVING COUNT(m.word_id) > 6400
Line : 309
File : functions_search.php |
I've had it a few times now, over the course of a few days, and have also noticed that despite the error my post still appears without me having to resubmit it. I'd been kinda assuming maybe it was just a "feature" of the boards 
Dave |
|
| Back to top |
|
|
william
Tzoner
Joined: 08 Feb 2007
Posts: 765
Location: United Kingdom
|
| Posted: Thu Oct 11, 2007 9:01 pm Post subject: |
|
|
i've never seen this message. i feel somewhat left out.
_________________
forum moderator
|
|
| Back to top |
|
|
Flameboy
Advisor
Joined: 29 Mar 2007
Posts: 1653
Location: Manchester
|
|
| Back to top |
|
|
Reenie
Reporter
Joined: 08 Feb 2007
Posts: 3577
Location: Glasgow
|
| Posted: Fri Oct 12, 2007 2:05 am Post subject: |
|
|
"features" and "bugs" are one and the same. "bugs" become "features" once described and documented by the cyberhemipterologists.
_________________
The Daily Turnout - King of the Throne Room
|
|
| 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
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
