[mythtv-users] #11918: !!NoTrans: SQL Error: Table 'mythconverg.mythweb_sessions' doesn't exist [#1146]!!

[Alan Marchiori]

I just ran into this same issue. I had a system running mythbuntu 12.04.4
that I upgraded to mythbuntu 14.04. It did prompt to update the db
schema, I said Yes. Everything seemed to be working fine until trying to
open mythweb, then I get the error above.

I found the update script here:
https://github.com/MythTV/mythweb/blob/master/includes/db_update.php

What worked for me was to drop the table and recreate:
mysql> drop table if exists mythweb_sessions;
Query OK, 0 rows affected, 1 warning (0.47 sec)

mysql> CREATE TABLE mythweb_sessions ( id VARCHAR(128) PRIMARY KEY NOT NULL
DEFAULT "", modified TIMESTAMP, data BLOB NOT NULL DEFAULT "", INDEX
(modified) );
Query OK, 0 rows affected, 1 warning (0.04 sec)

After that, mythweb works fine (and everything else is still working as far
as I can tell). This seems to be a bug, possibly in the 12.04.4 to 14.04
process.



On Wed, Oct 23, 2013 at 2:49 PM, Michael T. Dean <mtdean at thirdcontact.com>
wrote:

> On 10/23/2013 02:15 PM, Oz Dror wrote:
>
>>  I used ubuntu 13.10.
>>  Initialy apache2 did not run I had to edit
>>  /etc/apache2/sites-enabled/mythweb.conf in line 30 and remove the -all
>>  Now that i can start apache. I got the error bove in the web page.
>>
>>  in the apache eror log I get the following error:
>>
>>  [Wed Oct 23 09:29:59.526219 2013] [:error] [pid 19627] [client
>> 192.168.0.15:58571] PHP Warning:  date(): It is not safe to rely on the
>>  system's timezone settings. You are *required* to use the date.timezone
>>  setting or the date_default_timezone_set() function. In case you used any
>>  of those methods and you are still getting this warning, you most likely
>>  misspelled the timezone identifier. We selected the timezone 'UTC' for
>>  now, but please set date.timezone to select your timezone. in
>>  /usr/share/mythtv/mythweb/includes/errors.php on line 161
>>  [Wed Oct 23 09:29:59.526857 2013] [:error] [pid 19627] [client
>> 192.168.0.15:58571] PHP Warning:
>>  require(modules/_shared/tmpl/tmpl/footer.php): failed to open stream: No
>>  such file or directory in
>>  /usr/share/mythtv/mythweb/modules/_shared/tmpl/_errors/fatal.php on line
>>  43
>>  [Wed Oct 23 09:29:59.526883 2013] [:error] [pid 19627] [client
>> 192.168.0.15:58571] PHP Fatal error:  require(): Failed opening required
>>  'modules/_shared/tmpl/tmpl/footer.php'
>>  (include_path='/usr/local/share/mythtv/bindings/php/:/
>> usr/share/mythtv/bindings/php/:.:/usr/share/php:/usr/share/pear')
>>  in /usr/share/mythtv/mythweb/modules/_shared/tmpl/_errors/fatal.php on
>>  line 43
>>  [Wed Oct 23 09:29:59.527127 2013] [:error] [pid 19627] [client
>> 192.168.0.15:58571] PHP Fatal error:  SQL Error: Table
>>  'mythconverg.mythweb_sessions' doesn't exist [#1146] in
>>  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php on line 79
>>
>>
>> It looks like my database schemata is broken. Any help will be
>> appreciated.
>>
>
> Thanks for switching to the users list.
>
> Is this a first-time install of MythTV?  Did you restore a database backup
> or anything?  Basically, someone has dropped a table that should exist (and
> though I can help you get it back, it's important to figure out how you
> lost that table).  So, if you can think of any way you may have lost that
> table, I'd appreciate your letting me know.
>
> If you can't think of anything, it's possible that you're running MySQL
> with a (MySQL) user that doesn't have sufficient permissions to create the
> table, so you got the real failure the first time you tried using MythWeb
> and are now getting a different failure message because it's no longer
> trying to create the table (i.e. you didn't capture/notice the real error
> on a previous run).
>
> And, it's also possible that all is good, but whatever prevented your
> Apache from running properly had some effect that caused the initial
> failure.
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140715/58b7ee2f/attachment.html>