<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Sat, Aug 31, 2013 at 7:14 PM, Mike McMullin <span dir="ltr"><<a href="mailto:mwmcmlln@mnsi.net" target="_blank">mwmcmlln@mnsi.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">MythTV Version : v0.25.2-15-g46cab93<br>
MythTV Branch : fixes/0.25<br>
Network Protocol : 72<br>
Library API : 0.25.20120506-1<br>
QT Version : 4.8.1<br>
<br>
<br>
I don't have a mythconverg directory nor does a locate indicate anything<br>
like ./mythconverg/logging, mythfrontend staus indicates that there is<br>
no current data for the program guide.<br>
<br>
Where should I be able to find the logging, and how do I tell if the<br>
mysql databse is crashed or fine?<br>
<br>
Aug 31 18:58:28 front-main mythbackend[1921]: E DBLogger mythdb.cpp:192<br>
(DBError) DB Error (DBLogging):#012Query was:#012INSERT INTO logging<br>
(host, application, pid, tid, thread, filename, line, function,<br>
msgtime, level, message) VALUES<br>
(:HOST, :APP, :PID, :TID, :THREAD, :FILENAME, :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)#012Bindings were:#012:APP="mythbackend", :FILENAME="mythcommandlineparser.cpp",#012:FUNCTION="ConfigureLogging", :HOST="front-main", :LEVEL=2, :LINE=2534,#012:MESSAGE="mythbackend version: fixes/0.25 [v0.25.2-15-g46cab93] <a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a>",#012:MSGTIME="2013-08-31 00:21:21", :PID=1921, :THREAD="CoreContext", :TID=1921#012Driver error was [2/1064]:#012QMYSQL: Unable to execute query#012Database error was:#012You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':HOST, :APP, :PID, :TID, :THREAD, :FILENAME, :LINE, :FUNCTION, :MSGTIME,' at line 1<br>
Aug 31 18:58:28 front-main mythbackend[1921]: E DBLogger<br>
mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging<br>
(host, application, pid, tid, thread, filename, line, function,<br>
msgtime, level, message) VALUES<br>
(:HOST, :APP, :PID, :TID, :THREAD, :FILENAME, :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)<br>
Aug 31 18:58:28 front-main mythbackend[1921]: E DBLogger<br>
mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable<br>
to prepare statement#012Database error was:#012Table<br>
'./mythconverg/logging' is marked as crashed and last (automatic?)<br>
repair failed<br>
<br></blockquote><div><br><div>I'd try running the <a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a> script. In my system, it's
located at
/usr/share/doc/mythtv-docs-0.26.0/contrib/maintenance/<a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a><br><br><a href="http://v2kblog.blogspot.com/2009/03/fixing-mythtv-database-table.html">http://v2kblog.blogspot.com/2009/03/fixing-mythtv-database-table.html</a>
is a page of a guy who was saved by this program with a similar situation to yours.<br><br>I run it every night
around 3 AM as a cron job.<br><br></div><div>HTH,<br></div>Jerry<br></div></div></div></div>