SQL Errors

Comments, Questions, Requests, or Suggestions relating to discgolfreview.com

Moderators: Timko, Solty, Frank Delicious, Blake_T, Fritz, Booter

SQL Errors

Postby discspeed » Fri Jan 15, 2010 6:45 pm

Has anyone else been experiencing a lot of SQL errors with this site the last couple of days?
discspeed
Most Gyroscopic Poster (MGP)
User avatar
 
Posts: 5465
Joined: Tue Mar 10, 2009 9:02 am
Location: Clearwater, FL
Favorite Disc: Ion

Re: SQL Errors

Postby Booter » Fri Jan 15, 2010 6:48 pm

i have since yesterday. ive had about 4 today. alot less than yesterday
always looking for:
flat pink/red barstamp buzzzs, ce aviars, pearly pro candy fb's, pearly champion gators (fr or stock stamp),
Booter
Das Boot!
User avatar
 
Posts: 4361
Joined: Tue Sep 01, 2009 8:43 pm
Location: plaztek bins!
Favorite Disc: square ones

Re: SQL Errors

Postby BCR-9er » Fri Jan 15, 2010 6:56 pm

Yeah, I had one about an hour ago.
Brad Richardson
MVP Disc Sports
BCR-9er
Tree Magnet
User avatar
 
Posts: 113
Joined: Thu Oct 11, 2007 4:29 pm
Location: Michigan

Re: SQL Errors

Postby elnino » Fri Jan 15, 2010 7:20 pm

General Error
SQL ERROR [ mysql4 ]

Table 'm0' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


is this what everyone is seeing? the error doesn't allow me to search in firefox will try ie in a few minutes!
Positive feedback 56 Trade
Destroyer=Firebird=Striker=Roc=Wizard
elnino
Fairway Surgeon
 
Posts: 704
Joined: Wed Dec 03, 2008 6:04 pm
Favorite Disc: Firebird/wizard

Re: SQL Errors

Postby discspeed » Sat Jan 16, 2010 6:29 am

Yeah, I posted this like I know what I'm talking about, but I don't at all. Any of you tech geeks know what the hell is going on?
discspeed
Most Gyroscopic Poster (MGP)
User avatar
 
Posts: 5465
Joined: Tue Mar 10, 2009 9:02 am
Location: Clearwater, FL
Favorite Disc: Ion

Re: SQL Errors

Postby Timko » Sat Jan 16, 2010 9:18 am

We need Fritz to tell the the other admins some stuff about the backend first.
jsun3thousand wrote:Disc golfers are holding the sport back.
Timko
Like Angels Kicking Ass in your Mouth
User avatar
 
Posts: 7708
Joined: Wed Aug 02, 2006 10:21 pm
Location: KCMO

Re: SQL Errors

Postby dgdave » Sat Jan 16, 2010 8:07 pm

I don;t think Fritzy needs to be told anything about the back end
"The Gauge may be the best disc ever"
-dgdave

Destroyer/Enforcer/PD/TD/XXX/Gauge/Suspect/Clutch/P2
dgdave
DGR Postmaster General
User avatar
 
Posts: 12100
Joined: Mon Jan 15, 2007 8:22 pm
Location: Central OK
Favorite Disc: GAUGE!

Re: SQL Errors

Postby discspeed » Sun Jan 17, 2010 6:49 am

Timko wrote:We need Fritz to tell the the other admins some stuff about the backend first.


I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).
discspeed
Most Gyroscopic Poster (MGP)
User avatar
 
Posts: 5465
Joined: Tue Mar 10, 2009 9:02 am
Location: Clearwater, FL
Favorite Disc: Ion

Re: SQL Errors

Postby Dag » Sun Jan 17, 2010 10:27 am

DGR sez wrote:General Error
SQL ERROR [ mysql4 ]

Table 'm0' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


This has been happening for a day or two when I attempt to search. Happens in Explorer and in Chrome fwiw.
...there was a time when you were taught to find the best disc for you, not the best disc for your situation on the course, which is how they are sold now. IMO, the flight charts are basically there to point out all the stuff you dont have in your bag and why you suck.

Chase Roberts
Dag
Tree Magnet
User avatar
 
Posts: 318
Joined: Tue Nov 10, 2009 11:55 am
Favorite Disc: Discworld

Re: SQL Errors

Postby Timko » Sun Jan 17, 2010 3:39 pm

discspeed wrote:
Timko wrote:We need Fritz to tell the the other admins some stuff about the backend first.


I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).


Actually, I did know about the 4 degrees warmer thing. "4 Degrees" is the title of a Tool song:

Apparently the anal cavity has 8 more working muscles and is 4 degrees warmer than the vagina. This, however, is NOT a song about violation. It is a song about opening up, completely, without reservation.
jsun3thousand wrote:Disc golfers are holding the sport back.
Timko
Like Angels Kicking Ass in your Mouth
User avatar
 
Posts: 7708
Joined: Wed Aug 02, 2006 10:21 pm
Location: KCMO

Re: SQL Errors

Postby discspeed » Sun Jan 17, 2010 4:30 pm

Timko wrote:
discspeed wrote:
Timko wrote:We need Fritz to tell the the other admins some stuff about the backend first.


I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).


Actually, I did know about the 4 degrees warmer thing. "4 Degrees" is the title of a Tool song:

Apparently the anal cavity has 8 more working muscles and is 4 degrees warmer than the vagina. This, however, is NOT a song about violation. It is a song about opening up, completely, without reservation.


Yeah, that Maynard quote is where I got it from... :wink: Prison sex on the other hand is all about violation.
discspeed
Most Gyroscopic Poster (MGP)
User avatar
 
Posts: 5465
Joined: Tue Mar 10, 2009 9:02 am
Location: Clearwater, FL
Favorite Disc: Ion

Re: SQL Errors

Postby Timko » Sun Jan 17, 2010 4:33 pm

discspeed wrote:
Timko wrote:
discspeed wrote:
Timko wrote:We need Fritz to tell the the other admins some stuff about the backend first.


I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).


Actually, I did know about the 4 degrees warmer thing. "4 Degrees" is the title of a Tool song:

Apparently the anal cavity has 8 more working muscles and is 4 degrees warmer than the vagina. This, however, is NOT a song about violation. It is a song about opening up, completely, without reservation.


Yeah, that Maynard quote is where I got it from... :wink: Prison sex on the other hand is all about violation.


I would be all about looking into the issue, but I to be able to query tables. The admin console is just a frontend application.
jsun3thousand wrote:Disc golfers are holding the sport back.
Timko
Like Angels Kicking Ass in your Mouth
User avatar
 
Posts: 7708
Joined: Wed Aug 02, 2006 10:21 pm
Location: KCMO

Re: SQL Errors

Postby Timko » Sun Jan 17, 2010 9:34 pm

One more thing.

Here's another one you get when editing a post:

SQL ERROR [ mysql4 ]

Table 'm' is marked as crashed and should be repaired [1194]

SQL

SELECT w.word_id, w.word_text, m.title_match FROM search_wordlist w, search_wordmatch m WHERE m.post_id = 237310 AND w.word_id = m.word_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/search/fulltext_native.php
LINE: 1085
CALL: dbal_mysql->sql_query()

FILE: includes/functions_posting.php
LINE: 2368
CALL: fulltext_native->index()

FILE: posting.php
LINE: 1000
CALL: submit_post()
jsun3thousand wrote:Disc golfers are holding the sport back.
Timko
Like Angels Kicking Ass in your Mouth
User avatar
 
Posts: 7708
Joined: Wed Aug 02, 2006 10:21 pm
Location: KCMO

Re: SQL Errors

Postby JimW » Sun Jan 17, 2010 10:38 pm

If I recall correctly from my time running a phpBB board someone probably just needs to run a repair query on each table in the database using something like phpMyAdmin. Pretty simple thing, the database just gets a bit funky at random times and needs to be ordered to fix itself. As mentioned before though it can't be done through the board admin panel, it's not actually the board software acting up (it may have caused the problem, dunno for sure, but it can't fix it). You'd have to have access to the hosting control panel to take care of it.
discspeed wrote:We're not owls


The core of my game is throwing pink stuff really straight
JimW
1000 Rated Poster
User avatar
 
Posts: 1381
Joined: Wed Feb 25, 2009 11:08 pm
Location: Seminole, FL
Favorite Disc: Whatever

Re: SQL Errors

Postby what'shisname » Tue Jan 19, 2010 4:22 pm

Every attempt at searching for the last few days has produced this error:

General Error
SQL ERROR [ mysql4 ]

Table 'm0' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
what'shisname
1000 Rated Poster
User avatar
 
Posts: 1364
Joined: Mon Jul 06, 2009 8:34 am
Location: Calgary
Favorite Disc: PD

Next

Return to Website Comments

Who is online

Users browsing this forum: No registered users and 0 guests