LinHES Forums http://forum.linhes.org/ |
|
borqed mythweb - help http://forum.linhes.org/viewtopic.php?f=6&t=20360 |
Page 1 of 1 |
Author: | Too Many Secrets [ Sun Oct 11, 2009 10:43 am ] |
Post subject: | borqed mythweb - help |
So I was doing, I dont know what. And anyway, fried mythweb. I've googled this without much success. here's what i get. any help appreciated. I've tried unchecking and rechecking the mythweb in the setup. Code: Fatal Error at /data/srv/httpd/htdocs/mythweb/objects/Database/Query/mysql.php, line 83:
SQL Error: Table 'mythweb_sessions' already exists [#1050] If you choose to submit a bug report, please make sure to include a brief description of what you were doing, along with the following backtrace as an attachment (please don't paste the whole thing into the ticket). Backtrace: datetime: 2009-10-11 09:41:56 (PDT) errornum: 256 error type: User Error error string: SQL Error: Table 'mythweb_sessions' already exists [#1050] filename: /data/srv/httpd/htdocs/mythweb/objects/Database/Query/mysql.php error line: 83 ========================================================================== Backtrace: file: /data/srv/httpd/htdocs/mythweb/objects/Database/Query/mysql.php line: 83 class: function: trigger_error type: args: Array ( [0] => SQL Error: Table 'mythweb_sessions' already exists [#1050] [1] => 256 ) file: /data/srv/httpd/htdocs/mythweb/objects/Database.php line: 261 class: Database_Query_mysql function: execute type: -> args: Array ( [0] => Array ( ) ) file: /data/srv/httpd/htdocs/mythweb/includes/db_update.php line: 37 class: Database function: query type: -> args: Array ( [0] => CREATE TABLE mythweb_sessions ( id VARCHAR(128) PRIMARY KEY NOT NULL DEFAULT "", modified TIMESTAMP, data BLOB NOT NULL DEFAULT "", INDEX (modified) ) ) file: /data/srv/httpd/htdocs/mythweb/includes/init.php line: 39 class: function: require_once type: args: Array ( [0] => /data/srv/httpd/htdocs/mythweb/includes/db_update.php ) file: /data/srv/httpd/htdocs/mythweb/mythweb.php line: 20 class: function: require_once type: args: Array ( [0] => /data/srv/httpd/htdocs/mythweb/includes/init.php ) ========================================================================== $_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.1.10 [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PORT] => 80 [SERVER_ADDR] => 192.168.1.10 [REMOTE_PORT] => 59887 [REMOTE_ADDR] => 192.168.1.12 [REMOTE_USER] => mythtv [AUTH_TYPE] => Basic [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => [SCRIPT_FILENAME] => /data/srv/httpd/htdocs/mythweb/mythweb.php [DOCUMENT_ROOT] => /data/srv/httpd/htdocs [REQUEST_URI] => /mythweb/mythweb.php [QUERY_STRING] => [REQUEST_METHOD] => GET [REDIRECT_STATUS] => 200 [SERVER_PROTOCOL] => HTTP/1.1 [HTTP_HOST] => 192.168.1.10 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729) [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5 [HTTP_ACCEPT_ENCODING] => gzip,deflate [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7 [HTTP_KEEP_ALIVE] => 300 [HTTP_CONNECTION] => keep-alive [HTTP_REFERER] => http://192.168.1.10/ [HTTP_COOKIE] => mythweb_id=c87a17018fb44f785ffc1ad1787bf611 [HTTP_AUTHORIZATION] => Basic bXl0aHR2OnpkMTIxMXNjb3Q= [HTTP_CACHE_CONTROL] => max-age=0 [DB_SERVER] => localhost [DB_NAME] => mythconverg [DB_LOGIN] => mythtv [DB_PASSWORD] => mythtv [PHP_SELF] => /mythweb/mythweb.php [PHP_AUTH_USER] => mythtv [PHP_AUTH_PW] => zd1211scot [REQUEST_TIME] => 1255279316 [STATUS] => 200 ) |
Author: | tjc [ Sun Oct 11, 2009 11:12 am ] |
Post subject: | |
Have you tried dropping the table and rerunning the script? I seem to remember encountering something like this with earlier R6 alphas and letting it recreate the table(s) did the trick. |
Author: | Too Many Secrets [ Sun Oct 11, 2009 3:26 pm ] |
Post subject: | |
THANKS! I went into webmin and pulled up mythweb_sessions, hit drop table. Then Code: sv restart lighttpd and I'm back.
|
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |