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/