Listing search

[grshane@…]

While accessing Mythweb from another computer to check listings received SQL Error: Table './mythconverg/credits' is marked as crashed and last (automatic?) repair failed #144

Backtrace:

file: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php line: 83

class:

function: trigger_error

type: args: Array

(

[0] => SQL Error: Table './mythconverg/credits' is marked as crashed and last (automatic?) repair failed #144 [1] => 256

)

file: /usr/share/mythtv/mythweb/classes/Database.php line: 263

class: Database_Query_mysql

function: execute

type: -> args: Array

(

[0] => Array ( )

)

file: /usr/share/mythtv/mythweb/modules/tv/includes/programs.php line: 166

class: Database

function: query

type: -> args: Array

(

[0] => SELECT program.*,

UNIX_TIMESTAMP(program.starttime) AS starttime_unix, UNIX_TIMESTAMP(program.endtime) AS endtime_unix, IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS rating, channel.callsign, channel.channum

FROM program

LEFT JOIN programrating USING (chanid, starttime) LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN credits ON (program.chanid = credits.chanid AND program.starttime = credits.starttime) LEFT JOIN people ON (credits.person = people.person)

WHERE program.chanid IN (1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072) AND (program.endtime > FROM_UNIXTIME('1266521400') AND program.starttime < FROM_UNIXTIME('1266532200') AND program.starttime != program.endtime)

GROUP BY channel.callsign, program.chanid, program.starttime ORDER BY program.starttime )

file: /usr/share/mythtv/mythweb/modules/tv/list.php line: 49

class:

function: load_all_program_data

type: args: Array

(

[0] => 1266521400 [1] => 1266532200

)

file: /usr/share/mythtv/mythweb/modules/tv/handler.php line: 87

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/tv/list.php

)

file: /usr/share/mythtv/mythweb/mythweb.php line: 35

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/tv/handler.php

)

[robertm]

So you should fix your crashed database. ;)