Mythweb Broken "Unknown table engine 'InnoDB' [#1286]"

[Scott Harris <snharris99@…>]

After updating my system this morning, attempting to browse to MythWeb brings an error screen with a link to submit this bug, and the following back trace....

MythTV 0.24+fixes build 27107 on Mythbuntu 10.04 64Bit.

    datetime:  2010-11-06 19:15:39 (EDT)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: SQL Error: Unknown table engine 'InnoDB' [#1286]!!
    filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
  error line:  83

==========================================================================

Backtrace: 

    file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
    line:  83
   class:  
function:  trigger_error
    type:  
    args:  Array
(
    [0] => SQL Error: Unknown table engine 'InnoDB' [#1286]
    [1] => 256
)

    file:  /usr/share/mythtv/mythweb/classes/Database.php
    line:  263
   class:  Database_Query_mysql
function:  execute
    type:  ->
    args:  Array
(
    [0] => Array
        (
            [0] => Array ( )
        )

)

    file:  /usr/share/mythtv/mythweb/classes/Database.php
    line:  326
   class:  Database
function:  query
    type:  ->
    args:  Array
(
    [0] => SELECT COUNT(screen_id)
                                         FROM weatherscreens
    [1] => Array ( )
)

    file:  /usr/share/mythtv/mythweb/modules/weather/init.php
    line:  25
   class:  Database
function:  query_col
    type:  ->
    args:  Array
(
    [0] => SELECT COUNT(screen_id)
                                         FROM weatherscreens
)

    file:  /usr/share/mythtv/mythweb/classes/Modules.php
    line:  34
   class:  
function:  require_once
    type:  
    args:  Array
(
    [0] => /usr/share/mythtv/mythweb/modules/weather/init.php
)

    file:  /usr/share/mythtv/mythweb/classes/Modules.php
    line:  54
   class:  Modules
function:  load
    type:  ::
    args:  Array ( )
    file:  /usr/share/mythtv/mythweb/mythweb.php
    line:  30
   class:  Modules
function:  getModule
    type:  ::
    args:  Array
(
    [0] => 
)


==========================================================================

$_SESSION: Array
(
    [language] => English
    [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
    [cache_engine] => Cache_Null
    [stream] => Array
        (
            [include_user_and_password] => 
        )

    [prefer_channum] => 1
    [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.25.252] => Array
                (
                    [proto_version] => Array
                        (
                            [last_check_version] => 63
                            [last_check_time] => 1289085339
                        )

                )

            [timezone] => Array
                (
                    [value] => America/Detroit
                    [last_check_time] => 1289085339
                )

        )

)

==========================================================================

$_SERVER: Array
(
    [REDIRECT_STATUS] => 200
    [HTTP_HOST] => localhost
    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.12) Gecko/20101027 Ubuntu/10.04 (lucid) Firefox/3.6.12
    [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] => 115
    [HTTP_CONNECTION] => keep-alive
    [HTTP_COOKIE] => mythweb_id=i82i3uiomn38d21tp9t72tn9i7
    [PATH] => /usr/local/bin:/usr/bin:/bin
    [SERVER_SIGNATURE] => <address>Apache/2.2.14 (Ubuntu) Server at localhost Port 80</address>

    [SERVER_SOFTWARE] => Apache/2.2.14 (Ubuntu)
    [SERVER_NAME] => localhost
    [SERVER_ADDR] => 127.0.0.1
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 127.0.0.1
    [DOCUMENT_ROOT] => /var/www
    [SERVER_ADMIN] => webmaster@localhost
    [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
    [REMOTE_PORT] => 50881
    [REDIRECT_URL] => /mythweb/
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /
    [SCRIPT_NAME] => /mythweb/mythweb.php
    [PHP_SELF] => /mythweb/mythweb.php
    [REQUEST_TIME] => 1289085339
    [STATUS] => 200
    [URL] => /mythweb/
    [HTTP_PORT] => 80
)

==========================================================================

$constant_list["user"]: Array
(
    [ERROR] => 512
    [E_ASSERT_ERROR] => 4096
    [FATAL] => 256
    [PHP_MIN_VERSION] => 5.3
    [WARNING] => 1024
    [WebDBSchemaVer] => 2
    [error_email] => 
    [gb] => 1073741824
    [hostname] => myth-backend
    [http_host] => localhost
    [kb] => 1024
    [max_stars] => 4
    [mb] => 1048576
    [module] => 
    [modules_path] => ./modules
    [num_time_slots] => 36
    [prefer_channum] => 1
    [root] => /mythweb/
    [root_auth_url] => http://localhost/mythweb/
    [root_url] => http://localhost/mythweb/
    [skin] => default
    [skin_img_url] => http://localhost/mythweb/skins/default/img/
    [skin_url] => http://localhost/mythweb/skins/default/
    [star_character] => &#9733;
    [stream_url] => http://localhost:80//mythweb/
    [tb] => 1099511627776
    [timeslot_blocks] => 3
    [timeslot_size] => 300
    [timeslotbar_skip] => 20
    [tmpl] => default
    [tmpl_dir] => modules//tmpl/default/
)

[beirdo]

This is not a problem in MythWeb. You need to turn on innodb support in mysql configuration, and restart mysql. MythWeather? in particular requires innodb (as your errors clearly show).

[Scott Harris <snharris99@…>]

Funny, it was working fine as/is up until this morning. In looking in MYSQL there is no longer a "weatherscreens" table.

[robertm]

You ran updates, by your own admission. There's nothing funny or unexpected, you applied a series of changes without vetting them. Please seek future help on the users mailing list.