Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- datetime: 2011-11-06 11:32:20 (EST)
- errornum: 256
- error type: User Error
- error string: SQL Error: Table './mythconverg/credits' is marked as crashed and should be repaired [#145]
- filename: /data/srv/httpd/htdocs/mythweb/classes/Database/Query/mysql.php
- error line: 83
- ==========================================================================
- Backtrace:
- file: /data/srv/httpd/htdocs/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 should be repaired [#145]
- [1] => 256
- )
- file: /data/srv/httpd/htdocs/mythweb/classes/Database.php
- line: 263
- class: Database_Query_mysql
- function: execute
- type: ->
- args: Array
- (
- [0] => Array ( )
- )
- file: /data/srv/httpd/htdocs/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 (65002,65003,65004,65005,65006,65007,65008,65101,65010,65011,65012,65013,65014,65015,65016,65017,65018,65019,65020,65021,65022,65023,65029,65025,65026,65027,65028,65104,65030,65031,65032,65033,65034,65035,65036,65037,65038,65039,65040,65041,65042,65043,65044,65045,65046,65100,65048,65049,65050,65051,65052,65053,65054,65055,65056,65057,65058,65095,65096,65102) AND (program.endtime > FROM_UNIXTIME('1320597000') AND program.starttime < FROM_UNIXTIME('1320607800') AND program.starttime != program.endtime)
- GROUP BY channel.callsign, program.chanid, program.starttime ORDER BY program.starttime
- )
- file: /data/srv/httpd/htdocs/mythweb/modules/tv/list.php
- line: 49
- class:
- function: load_all_program_data
- type:
- args: Array
- (
- [0] => 1320597000
- [1] => 1320607800
- )
- file: /data/srv/httpd/htdocs/mythweb/modules/tv/handler.php
- line: 87
- class:
- function: require_once
- type:
- args: Array
- (
- [0] => /data/srv/httpd/htdocs/mythweb/modules/tv/list.php
- )
- file: /data/srv/httpd/htdocs/mythweb/mythweb.php
- line: 35
- class:
- function: require_once
- type:
- args: Array
- (
- [0] => /data/srv/httpd/htdocs/mythweb/modules/tv/handler.php
- )
- ==========================================================================
- $_SESSION: Array
- (
- [language] => English
- [prefer_channum] => 1
- [date_statusbar] => %a %b %e, %Y, %I:%M %p
- [date_scheduled] => %a %b %e, %Y (%I:%M %p)
- [date_scheduled_popup] => %a %b %e, %Y
- [date_recorded] => %a %b %e, %Y (%I:%M %p)
- [date_search] => %a %b %e, %Y, %I:%M %p
- [date_listing_key] => %a %b %e, %Y, %I:%M %p
- [date_listing_jump] => %a %b %e, %Y
- [date_channel_jump] => %a %b %e, %Y
- [date_job_status] => %a %b %e, %Y, %I:%M %p
- [time_format] => %I:%M %p
- [recorded_pixmaps] => 1
- [guide_favonly] =>
- [timeslot_size] => 300
- [num_time_slots] => 36
- [timeslot_blocks] => 3
- [timeslotbar_skip] => 20
- [max_stars] => 4
- [star_character] => ★
- [show_popup_info] => 1
- [show_channel_icons] => 1
- [sortby_channum] => 1
- [recorded_paging] =>
- [genre_colors] => 1
- [show_video_covers] => 1
- [settings] => Array
- (
- [screens] => Array
- (
- [tv] => Array
- (
- [upcoming recordings] => Array
- (
- [title] => on
- [channel] => on
- [record date] => on
- [length] => on
- )
- )
- )
- )
- [backend] => Array
- (
- [192.168.8.106] => Array
- (
- [proto_version] => Array
- (
- [last_check_version] => 50
- [last_check_time] => 1320596078
- )
- )
- [timezone] => Array
- (
- [value] => America/New_York
- [last_check_time] => 1320215406
- )
- )
- [tv] => Array
- (
- [last] => Array
- (
- [0] => list
- )
- )
- [recorded_title] =>
- [recorded_recgroup] =>
- [recorded_sortby] => Array
- (
- [0] => Array
- (
- [field] => airdate
- [reverse] => 1
- )
- [1] => Array
- (
- [field] => title
- [reverse] =>
- )
- )
- [list_time] => 1320597000
- [recording_details] => Array
- (
- [show_Conflict] => 1
- [show_PreviousRecording] => 1
- [show_EarlierShowing] => 1
- [show_CurrentRecording] => 1
- [show_WillRecord] => 1
- )
- [scheduled_recordings] => Array
- (
- [disp_scheduled] => 1
- [disp_duplicates] =>
- [disp_deactivated] =>
- [disp_conflicts] => 1
- )
- [] => Array ( )
- [schedules_sortby] => Array
- (
- [0] => Array
- (
- [field] => airdate
- [reverse] =>
- )
- [1] => Array
- (
- [field] => title
- [reverse] =>
- )
- )
- )
- ==========================================================================
- $_SERVER: Array
- (
- [spl_fifo] => //lib/splash/cache/.splash
- [TERM] => linux
- [SPLASH_KDMODE] => TEXT
- [SPLASH_TEXTBOX] => no
- [SPLASH_XSERVICE] => xdm
- [spl_decor] => //sbin/fbcondecor_ctl.static
- [SPLASH_BOOT_MESSAGE] => Booting the system ($progress%)... Press F2 for verbose mode.
- [SPLASH_TTY] => 16
- [SPLASH_EFFECTS] =>
- [SPLASH_SANITY] =>
- [SPLASH_THEME] => linhes
- [SPLASH_PROFILE] => off
- [spl_cachesize] => 4096
- [PATH] => /bin:/sbin:/usr/bin:/usr/sbin
- [spl_daemon] => //sbin/fbsplashd.static
- [spl_tmpdir] => //lib/splash/tmp
- [spl_cachedir] => //lib/splash/cache
- [PWD] => /etc/sv/lighttpd
- [spl_pidfile] => //lib/splash/cache/daemon.pid
- [SPLASH_MODE_REQ] => silent
- [SPLASH_SHUTDOWN_MESSAGE] => Shutting down the system ($progress%)... Press F2 for verbose mode.
- [SPLASH_REBOOT_MESSAGE] => Rebooting the system ($progress%)... Press F2 for verbose mode.
- [SHLVL] => 0
- [spl_bindir] => //lib/splash/bin
- [spl_util] => //bin/splash_util.static
- [spl_cachetype] => tmpfs
- [SPLASH_AUTOVERBOSE] => 0
- [splash_get_mode] => () { local ctty="${spl_bindir}/fgconsole";
- local mode="$(${spl_util})";
- if [ "${mode}" = "silent" ]; then
- echo "silent";
- else
- if [ -z "$(${spl_decor} -c getstate --tty=${ctty} 2>/dev/null | grep off)" ]; then
- echo "verbose";
- else
- echo "off";
- fi;
- fi
- }
- [splash_svclist_get] => () { if [ "$1" = "start" -a -r "${spl_cachedir}/svcs_start" ]; then
- cat "${spl_cachedir}/svcs_start";
- else
- if [ "$1" = "stop" -a -r "${spl_cachedir}/svcs_stop" ]; then
- cat "${spl_cachedir}/svcs_stop";
- fi;
- fi
- }
- [splash_get_boot_message] => () { if [ "${RUNLEVEL}" = "6" ]; then
- echo "${SPLASH_REBOOT_MESSAGE}";
- else
- if [ "${RUNLEVEL}" = "0" ]; then
- echo "${SPLASH_SHUTDOWN_MESSAGE}";
- else
- echo "${SPLASH_BOOT_MESSAGE}";
- fi;
- fi
- }
- [splash_comm_send] => () { if [ -z "`pidof $(basename ${spl_daemon})`" ]; then
- return 1;
- else
- splash_profile "comm $*";
- echo "$*" > "${spl_fifo}" &
- fi
- }
- [splash_setup] => () { if [ "${SPLASH_THEME}" != "" -a "${SPLASH_TTY}" != "" -a "$1" != "force" ]; then
- return 0;
- fi;
- export SPLASH_EFFECTS="";
- export SPLASH_SANITY="";
- export SPLASH_TEXTBOX="no";
- export SPLASH_MODE_REQ="off";
- export SPLASH_PROFILE="off";
- export SPLASH_THEME="default";
- export SPLASH_TTY="16";
- export SPLASH_KDMODE="TEXT";
- export SPLASH_AUTOVERBOSE="0";
- export SPLASH_BOOT_MESSAGE="Booting the system (\$progress%)... Press F2 for verbose mode.";
- export SPLASH_SHUTDOWN_MESSAGE="Shutting down the system (\$progress%)... Press F2 for verbose mode.";
- export SPLASH_REBOOT_MESSAGE="Rebooting the system (\$progress%)... Press F2 for verbose mode.";
- export SPLASH_XSERVICE="xdm";
- [ -f /etc/splash/splash ] && . /etc/splash/splash;
- [ -f /etc/conf.d/splash ] && . /etc/conf.d/splash;
- [ -f /etc/conf.d/fbcondecor ] && . /etc/conf.d/fbcondecor;
- if [ -f /proc/cmdline ]; then
- options=$(grep -o 'splash=[^ ]*' /proc/cmdline);
- for opt in ${options};
- do
- options=${opt#*=};
- for i in $(echo "${options}" | sed -e 's/,/ /g');
- do
- case ${i%:*} in
- theme)
- SPLASH_THEME=${i#*:}
- ;;
- tty)
- SPLASH_TTY=${i#*:}
- ;;
- verbose)
- SPLASH_MODE_REQ="verbose"
- ;;
- silent)
- SPLASH_MODE_REQ="silent"
- ;;
- kdgraphics)
- SPLASH_KDMODE="GRAPHICS"
- ;;
- profile)
- SPLASH_PROFILE="on"
- ;;
- insane)
- SPLASH_SANITY="insane"
- ;;
- esac;
- done;
- done;
- fi
- }
- [splash_silent] => () { splash_comm_send "set mode silent"
- }
- [splash_cache_cleanup] => () { [ -z "$(grep ${spl_cachedir} /proc/mounts)" ] && return;
- if [ ! -d "${spl_tmpdir}" ]; then
- mkdir -p "${spl_tmpdir}" 2> /dev/null;
- [ "$?" != "0" ] && return;
- fi;
- if [ -n "$(pgrep fbsplashd)" ]; then
- sleep 1;
- killall -9 "${spl_daemon##*/}" 2> /dev/null;
- fi;
- local mntopt="";
- [ -w /etc/mtab ] || mntopt="-n";
- mount ${mntopt} --move "${spl_cachedir}" "${spl_tmpdir}" 2> /dev/null;
- [ -w "${spl_cachedir}" ] || return;
- if [ "${SPLASH_PROFILE}" != "off" ]; then
- cp -a "${spl_tmpdir}/profile" "${spl_cachedir}" 2> /dev/null;
- fi;
- while [ -n "$1" ]; do
- cp -a "${spl_tmpdir}/$1" "${spl_cachedir}" 2> /dev/null;
- shift;
- done;
- umount -l "${spl_tmpdir}" 2> /dev/null
- }
- [splash_start] => () { if [ "${SPLASH_MODE_REQ}" = "verbose" ]; then
- ${spl_decor} -c on 2> /dev/null;
- return 0;
- else
- if [ "${SPLASH_MODE_REQ}" != "silent" ]; then
- return 0;
- fi;
- fi;
- if [ "${SPLASH_MODE_REQ}" = "silent" -a "${SPLASH_SANITY}" != "insane" ]; then
- if [ -z "$(grep -E '(^| )CONSOLE=/dev/tty1( |$)' /proc/cmdline)" -a -z "$(grep -E '(^| )console=tty1( |$)' /proc/cmdline)" ]; then
- clear;
- splash_warn "You don't appear to have a correct console= setting on your kernel";
- splash_warn "command line. Silent splash will not be enabled. Please add";
- splash_warn "console=tty1 or CONSOLE=/dev/tty1 to your kernel command line";
- splash_warn "to avoid this message.";
- if [ -n "$(grep 'CONSOLE=/dev/tty1' /proc/cmdline)" -o -n "$(grep 'console=tty1' /proc/cmdline)" ]; then
- splash_warn "Note that CONSOLE=/dev/tty1 and console=tty1 are general parameters and";
- splash_warn "not splash= settings.";
- fi;
- return 1;
- fi;
- if [ -n "$(grep -E '(^| )CONSOLE=/dev/tty1( |$)' /proc/cmdline)" ]; then
- mount -n --bind / ${spl_tmpdir};
- if [ ! -c "${spl_tmpdir}/dev/tty1" ]; then
- umount -n ${spl_tmpdir};
- splash_warn "The filesystem mounted on / doesn't contain the /dev/tty1 device";
- splash_warn "which is required for the silent splash to function properly.";
- splash_warn "Silent splash will not be enabled. Please create the appropriate";
- splash_warn "device node to avoid this message.";
- return 1;
- fi;
- umount -n ${spl_tmpdir};
- fi;
- fi;
- rm -f "${spl_pidfile}";
- rm -f "${spl_fifo}" 2> /dev/null;
- mkfifo "${spl_fifo}";
- local options="";
- [ "${SPLASH_KDMODE}" = "GRAPHICS" ] && options="--kdgraphics";
- [ -n "${SPLASH_EFFECTS}" ] && options="${options} --effects=${SPLASH_EFFECTS}";
- [ "${SPLASH_TEXTBOX}" = "yes" ] && options="${options} --textbox";
- local ttype="bootup";
- if [ "${RUNLEVEL}" = "6" ]; then
- ttype="reboot";
- else
- if [ "${RUNLEVEL}" = "0" ]; then
- ttype="shutdown";
- fi;
- fi;
- BOOT_MSG="$(splash_get_boot_message)" ${spl_daemon} --theme="${SPLASH_THEME}" --pidfile="${spl_pidfile}" --type=${ttype} ${options};
- splash_comm_send "set tty silent ${SPLASH_TTY}";
- if [ "${SPLASH_MODE_REQ}" = "silent" ]; then
- splash_comm_send "set mode silent";
- splash_comm_send "repaint";
- ${spl_decor} -c on 2> /dev/null;
- fi;
- splash_comm_send "set autoverbose ${SPLASH_AUTOVERBOSE}";
- splash_set_event_dev;
- return 0
- }
- [splash_set_event_dev] => () { local t="$(grep -Hsi keyboard /sys/class/input/input*/name | sed -e 's#.*input\([0-9]*\)/name.*#event\1#')";
- if [ -z "${t}" ]; then
- t="$(grep -Hsi keyboard /sys/class/input/event*/device/driver/description | grep -o 'event[0-9]\+')";
- if [ -z "${t}" ]; then
- for i in /sys/class/input/input*;
- do
- if [ "$((0x$(cat $i/capabilities/ev) & 0x100002))" = "1048578" ]; then
- t="$(echo $i | sed -e 's#.*input\([0-9]*\)#event\1#')";
- fi;
- done;
- if [ -z "${t}" ]; then
- t="$(/bin/grep -s -m 1 '^H: Handlers=kbd' /proc/bus/input/devices | grep -o 'event[0-9]*')";
- fi;
- fi;
- fi;
- [ -n "${t}" ] && splash_comm_send "set event dev /dev/input/${t}"
- }
- [splash_cache_prep] => () { mount -ns -t "${spl_cachetype}" cachedir "${spl_cachedir}" -o rw,mode=0644,size="${spl_cachesize}"k;
- retval="$?";
- if [ ${retval} -ne 0 ]; then
- splash_err "Unable to create splash cache - switching to verbose.";
- splash_verbose;
- return "${retval}";
- fi
- }
- [splash_verbose] => () { /bin/true
- }
- [splash] => () { local event="$1";
- shift;
- if [ "${event}" = "rc_init" ]; then
- splash_setup "force";
- else
- splash_setup;
- fi;
- [ "${SPLASH_MODE_REQ}" = "off" ] && return;
- if [ "${event}" = "rc_init" ]; then
- if [ "${RUNLEVEL}" = "S" -a "$1" = "sysinit" ]; then
- splash_cache_prep 'start' || return;
- else
- if [ "${RUNLEVEL}" = "6" -o "${RUNLEVEL}" = "0" ]; then
- if ! touch "${spl_cachedir}/message" 2> /dev/null; then
- splash_cache_prep 'stop' || return;
- fi;
- fi;
- fi;
- fi;
- local args="";
- if [ "${event}" = "rc_init" -o "${event}" = "rc_exit" ]; then
- args="$* ${RUNLEVEL}";
- else
- if [ "${event}" = "svc_started" -o "${event}" = "svc_stopped" ]; then
- if [ -z "$2" ]; then
- args="$* 0";
- else
- args="$*";
- if [ "$2" != "0" ]; then
- if [ "${event}" = "svc_started" ]; then
- event="svc_start_failed";
- else
- event="svc_stop_failed";
- fi;
- fi;
- fi;
- else
- args="$*";
- fi;
- fi;
- splash_profile "pre ${event} ${args}";
- if [ -x "/etc/splash/${SPLASH_THEME}/scripts/${event}-pre" ]; then
- /etc/splash/"${SPLASH_THEME}"/scripts/${event}-pre ${args};
- fi;
- case "$event" in
- svc_start)
- splash_svc_start "$1"
- ;;
- svc_stop)
- splash_svc_stop "$1"
- ;;
- svc_started)
- splash_svc "$1" "start"
- ;;
- svc_stopped)
- splash_svc "$1" "stop"
- ;;
- svc_start_failed)
- splash_svc_fail "$1" "start"
- ;;
- svc_stop_failed)
- splash_svc_fail "$1" "stop"
- ;;
- svc_input_begin)
- splash_input_begin "$1"
- ;;
- svc_input_end)
- splash_input_end "$1"
- ;;
- rc_init)
- splash_init "$1" "${RUNLEVEL}"
- ;;
- rc_exit)
- splash_exit "${RUNLEVEL}"
- ;;
- critical)
- splash_verbose
- ;;
- esac;
- splash_profile "post ${event} ${args}";
- if [ -x "/etc/splash/${SPLASH_THEME}/scripts/${event}-post" ]; then
- /etc/splash/"${SPLASH_THEME}"/scripts/${event}-post ${args};
- fi;
- return 0
- }
- [splash_profile] => () { if [ "${SPLASH_PROFILE}" = "on" ]; then
- echo "$(cat /proc/uptime | cut -f1 -d' '): $*" >> "${spl_cachedir}/profile";
- fi
- }
- [chvt] => () { local ntty=$1;
- printf "\e[12;${ntty}]"
- }
- [PHP_FCGI_CHILDREN] => 1
- [FCGI_ROLE] => RESPONDER
- [SERVER_SOFTWARE] => lighttpd/1.4.20
- [SERVER_NAME] => 192.168.8.106
- [GATEWAY_INTERFACE] => CGI/1.1
- [SERVER_PORT] => 80
- [SERVER_ADDR] => 192.168.8.106
- [REMOTE_PORT] => 3309
- [REMOTE_ADDR] => 192.168.8.116
- [SCRIPT_NAME] => /mythweb/mythweb.php
- [PATH_INFO] => /tv/list
- [PATH_TRANSLATED] => /data/srv/httpd/htdocs/tv/list
- [SCRIPT_FILENAME] => /data/srv/httpd/htdocs/mythweb/mythweb.php
- [DOCUMENT_ROOT] => /data/srv/httpd/htdocs
- [REQUEST_URI] => /mythweb/tv/list
- [REDIRECT_URI] => /mythweb/mythweb.php/tv/list
- [QUERY_STRING] =>
- [REQUEST_METHOD] => GET
- [REDIRECT_STATUS] => 200
- [SERVER_PROTOCOL] => HTTP/1.1
- [HTTP_ACCEPT] => image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */*
- [HTTP_REFERER] => http://192.168.8.106/mythweb/mythweb.php
- [HTTP_ACCEPT_LANGUAGE] => en-us
- [HTTP_USER_AGENT] => Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)
- [HTTP_ACCEPT_ENCODING] => gzip, deflate
- [HTTP_HOST] => 192.168.8.106
- [HTTP_CONNECTION] => Keep-Alive
- [HTTP_COOKIE] => mythweb_tmpl=default; mythweb_skin=default; mythweb_id=co7n23id297jijvi0mm46c3en5
- [DB_SERVER] => localhost
- [DB_NAME] => mythconverg
- [DB_LOGIN] => mythtv
- [DB_PASSWORD] => mythtv
- [ORIG_SCRIPT_FILENAME] => /data/srv/httpd/htdocs/mythweb/mythweb.php/tv/list
- [ORIG_PATH_TRANSLATED] => /data/srv/httpd/htdocs/tv/list
- [PHP_SELF] => /mythweb/mythweb.php/tv/list
- [REQUEST_TIME] => 1320597140
- [URI] => /mythweb/mythweb.php/tv/list
- [STATUS] => 200
- [HTTP_PORT] => 80
- )
- ==========================================================================
- $constant_list["user"]: Array
- (
- [ERROR] => 512
- [E_ASSERT_ERROR] => 4096
- [FATAL] => 256
- [PHP_MIN_VERSION] => 5.1
- [WARNING] => 1024
- [WebDBSchemaVer] => 2
- [dupsin_all] => 15
- [dupsin_ex_generic] => 64
- [dupsin_ex_repeats] => 32
- [dupsin_newepisodes] => 16
- [dupsin_oldrecorded] => 2
- [dupsin_recorded] => 1
- [error_email] =>
- [gb] => 1073741824
- [hostname] => mythtv
- [http_host] => 192.168.8.106
- [kb] => 1024
- [max_stars] => 4
- [mb] => 1048576
- [module] => tv
- [modules_path] => ./modules
- [num_time_slots] => 36
- [prefer_channum] => 1
- [rectype_always] => 4
- [rectype_channel] => 3
- [rectype_daily] => 2
- [rectype_dontrec] => 8
- [rectype_finddaily] => 9
- [rectype_findone] => 6
- [rectype_findweekly] => 10
- [rectype_once] => 1
- [rectype_override] => 7
- [rectype_weekly] => 5
- [root] => /mythweb/
- [root_url] => http://192.168.8.106/mythweb/
- [searchtype_keyword] => 3
- [searchtype_manual] => 5
- [searchtype_people] => 4
- [searchtype_power] => 1
- [searchtype_title] => 2
- [skin] => default
- [skin_img_url] => http://192.168.8.106/mythweb/skins/default/img/
- [skin_url] => http://192.168.8.106/mythweb/skins/default/
- [star_character] => ★
- [stream_url] => http://192.168.8.106:80//mythweb/
- [tb] => 1099511627776
- [timeslot_blocks] => 3
- [timeslot_size] => 300
- [timeslotbar_skip] => 20
- [tmpl] => default
- [tmpl_dir] => modules/tv/tmpl/default/
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement