View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: borqed mythweb - help
PostPosted: Sun Oct 11, 2009 10:43 am 
Offline
Joined: Fri Oct 20, 2006 12:04 pm
Posts: 905
Location: LA, CA
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
)




Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 11, 2009 11:12 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 11, 2009 3:26 pm 
Offline
Joined: Fri Oct 20, 2006 12:04 pm
Posts: 905
Location: LA, CA
THANKS!

I went into webmin and pulled up mythweb_sessions, hit drop table. Then
Code:
sv restart lighttpd
and I'm back.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 22 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu