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
)