Forum adverts like this one are shown to any user who is not logged in. Join us by filling out a tiny 3 field form and you will get your own, free, dakka user account which gives a good range of benefits to you: No adverts like this in the forums anymore. Times and dates in your local timezone. Full tracking of what you have read so you can skip to your first unread post, easily see what has changed since you last logged in, and easily see what is new at a glance. Email notifications for threads you want to watch closely. Being a part of the oldest wargaming community on the net. If you are already a member then feel free to login now.

So I was trying to search the gallery and this showed up every time. I don't think the search term matters, I tried a few different ones. Included below is the full error message/page.

"HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: java.sql.SQLException: Table './dakka/jgallery_searchphrase' is marked as crashed and last (automatic?) repair failed

Query being executed when exception was thrown:

SELECT DISTINCT SQL_CALC_FOUND_ROWS jp.image_id FROM jgallery_images_search_trimmed jp, jgallery_searchphrase js WHERE js.image_id=jp.image_id AND (MATCH(js.imagetext) AGAINST('slayer' IN BOOLEAN MODE)) ORDER BY image_uploaded DESC LIMIT 30 OFFSET 0
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.gallery_002dsearch_jsp._jspService(gallery_002dsearch_jsp.java:1623)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.lang.Exception: java.sql.SQLException: Table './dakka/jgallery_searchphrase' is marked as crashed and last (automatic?) repair failed

Query being executed when exception was thrown:

SELECT DISTINCT SQL_CALC_FOUND_ROWS jp.image_id FROM jgallery_images_search_trimmed jp, jgallery_searchphrase js WHERE js.image_id=jp.image_id AND (MATCH(js.imagetext) AGAINST('slayer' IN BOOLEAN MODE)) ORDER BY image_uploaded DESC LIMIT 30 OFFSET 0
com.dakka.jgallery.DatasourceSearch.doSearch(DatasourceSearch.java:346)
org.apache.jsp.gallery_002dsearch_jsp._jspService(gallery_002dsearch_jsp.java:341)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.sql.SQLException: Table './dakka/jgallery_searchphrase' is marked as crashed and last (automatic?) repair failed

Query being executed when exception was thrown:

SELECT DISTINCT SQL_CALC_FOUND_ROWS jp.image_id FROM jgallery_images_search_trimmed jp, jgallery_searchphrase js WHERE js.image_id=jp.image_id AND (MATCH(js.imagetext) AGAINST('slayer' IN BOOLEAN MODE)) ORDER BY image_uploaded DESC LIMIT 30 OFFSET 0
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
com.dakka.jgallery.DatasourceSearch.doSearch(DatasourceSearch.java:266)
org.apache.jsp.gallery_002dsearch_jsp._jspService(gallery_002dsearch_jsp.java:341)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5 logs."

I don't know if it's just a temporary problem, a problem on my computer specifically, or even the gallery refusing to produce results invlolving Warmachine...

I seem to get the same error (I'm using Mozilla/5.0):

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: java.sql.SQLException: Table './dakka/jgallery_searchphrase' is marked as crashed and last (automatic?) repair failed

Query being executed when exception was thrown:

SELECT DISTINCT SQL_CALC_FOUND_ROWS jp.image_id FROM jgallery_images_search_trimmed jp, jgallery_searchphrase js WHERE js.image_id=jp.image_id AND (MATCH(js.imagetext) AGAINST('cheese' IN BOOLEAN MODE)) ORDER BY image_uploaded DESC LIMIT 30 OFFSET 0
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.gallery_002dsearch_jsp._jspService(gallery_002dsearch_jsp.java:1623)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.Exception: java.sql.SQLException: Table './dakka/jgallery_searchphrase' is marked as crashed and last (automatic?) repair failed

Query being executed when exception was thrown:

SELECT DISTINCT SQL_CALC_FOUND_ROWS jp.image_id FROM jgallery_images_search_trimmed jp, jgallery_searchphrase js WHERE js.image_id=jp.image_id AND (MATCH(js.imagetext) AGAINST('cheese' IN BOOLEAN MODE)) ORDER BY image_uploaded DESC LIMIT 30 OFFSET 0
com.dakka.jgallery.DatasourceSearch.doSearch(DatasourceSearch.java:346)
org.apache.jsp.gallery_002dsearch_jsp._jspService(gallery_002dsearch_jsp.java:341)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: Table './dakka/jgallery_searchphrase' is marked as crashed and last (automatic?) repair failed

Query being executed when exception was thrown:

SELECT DISTINCT SQL_CALC_FOUND_ROWS jp.image_id FROM jgallery_images_search_trimmed jp, jgallery_searchphrase js WHERE js.image_id=jp.image_id AND (MATCH(js.imagetext) AGAINST('cheese' IN BOOLEAN MODE)) ORDER BY image_uploaded DESC LIMIT 30 OFFSET 0
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
com.dakka.jgallery.DatasourceSearch.doSearch(DatasourceSearch.java:266)
org.apache.jsp.gallery_002dsearch_jsp._jspService(gallery_002dsearch_jsp.java:341)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5 logs.
Apache Tomcat/5.5

I've noticed something else too, all the buttons look different and I can't preview threads by mousing over them anymore... I'm getting the feeling this is all related...?

That all seems to be OK for me. I will just go check if the gallery is working for me (I'm now on a different PC and browser).

Edit: No, getting the same error in the gallery, and am using IE6.

There's nothing whatsoever different with my computer, and I've been using IE8 for as long as I've been coming here. I'm pretty sure changes were made to the site, or something like that. Whatever it is, I don't like it... But what can ya do?

I was running some optimisation stuff last night (which made the site run slow btw), and killed it when it was doing the search cache for the gallery which caused corruption that I didnt notice.

It is rebuilding now and should be done in about 30 minutes so then the gallery will be working normally once more.

Thanks for reporting the error.

MasterDRD, if your site appearance has changed, you are most likely using the mobile version of dakka. Use the 'switch theme' link to go back to the normal version to restore the design and features.

Huh... no idea how I got switched to mobile version... Thanks.