Opened 10 years ago

Closed 10 years ago

Last modified 4 years ago

#8089 closed defect (invalid)

Listing search

Reported by: grshane@… Owned by: Rob Smith
Priority: major Milestone: unknown
Component: Plugin - MythWeb Version: unknown
Severity: medium Keywords:
Cc: Ticket locked: yes

Description

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

)

Change History (3)

comment:1 Changed 10 years ago by robertm

Resolution: invalid
Status: newclosed

So you should fix your crashed database. ;)

comment:2 Changed 4 years ago by ar_yjmdya@…

And one would do that how? optimize_mythdb.pl doesn't fix it, so don't glibly say to use that.

comment:3 Changed 4 years ago by Karl Egly

Ticket locked: set

This is a good question for our users list or our forum troubleshooting. Not so for a 6 year old ticket in the bug tracker.

If its the credits table (the OPs issue) that is broken beyond repair, then I'd just drop it and create a new one. From dbcheck.cpp

DROP TABLE credits;

CREATE TABLE credits (
  person mediumint(8) unsigned NOT NULL DEFAULT '0',
  chanid int(10) unsigned NOT NULL DEFAULT '0',
  starttime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  role set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL DEFAULT '',
  UNIQUE KEY chanid (chanid,starttime,person,role),
  KEY person (person,role)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

PS: This question has already been asked over there, here are the relevant threads. First Second.

Note: See TracTickets for help on using tickets.