<div dir="ltr">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 <div>schema, I said Yes. Everything seemed to be working fine until trying to open mythweb, then I get the error above.<br>
</div><div><div>
<br></div><div>I found the update script here: <a href="https://github.com/MythTV/mythweb/blob/master/includes/db_update.php">https://github.com/MythTV/mythweb/blob/master/includes/db_update.php</a></div><div><br></div><div>
What worked for me was to drop the table and recreate:</div><div><div style="font-family:arial,sans-serif;font-size:13px">mysql> drop table if exists mythweb_sessions;</div><div style="font-family:arial,sans-serif;font-size:13px">
Query OK, 0 rows affected, 1 warning (0.47 sec)</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">mysql> CREATE TABLE mythweb_sessions ( id VARCHAR(128) PRIMARY KEY NOT NULL DEFAULT "", modified TIMESTAMP, data BLOB NOT NULL DEFAULT "", INDEX (modified) );</div>
<div style="font-family:arial,sans-serif;font-size:13px">Query OK, 0 rows affected, 1 warning (0.04 sec)</div></div></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">
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. </div><div style="font-family:arial,sans-serif;font-size:13px">
<br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Oct 23, 2013 at 2:49 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On 10/23/2013 02:15 PM, Oz Dror wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I used ubuntu 13.10.<br>
Initialy apache2 did not run I had to edit<br>
/etc/apache2/sites-enabled/<u></u>mythweb.conf in line 30 and remove the -all<br>
Now that i can start apache. I got the error bove in the web page.<br>
<br>
in the apache eror log I get the following error:<br>
<br>
[Wed Oct 23 09:29:59.526219 2013] [:error] [pid 19627] [client<br>
<a href="http://192.168.0.15:58571" target="_blank">192.168.0.15:58571</a>] PHP Warning: date(): It is not safe to rely on the<br>
system's timezone settings. You are *required* to use the date.timezone<br>
setting or the date_default_timezone_set() function. In case you used any<br>
of those methods and you are still getting this warning, you most likely<br>
misspelled the timezone identifier. We selected the timezone 'UTC' for<br>
now, but please set date.timezone to select your timezone. in<br>
/usr/share/mythtv/mythweb/<u></u>includes/errors.php on line 161<br>
[Wed Oct 23 09:29:59.526857 2013] [:error] [pid 19627] [client<br>
<a href="http://192.168.0.15:58571" target="_blank">192.168.0.15:58571</a>] PHP Warning:<br>
require(modules/_shared/tmpl/<u></u>tmpl/footer.php): failed to open stream: No<br>
such file or directory in<br>
/usr/share/mythtv/mythweb/<u></u>modules/_shared/tmpl/_errors/<u></u>fatal.php on line<br>
43<br>
[Wed Oct 23 09:29:59.526883 2013] [:error] [pid 19627] [client<br>
<a href="http://192.168.0.15:58571" target="_blank">192.168.0.15:58571</a>] PHP Fatal error: require(): Failed opening required<br>
'modules/_shared/tmpl/tmpl/<u></u>footer.php'<br>
(include_path='/usr/local/<u></u>share/mythtv/bindings/php/:/<u></u>usr/share/mythtv/bindings/php/<u></u>:.:/usr/share/php:/usr/share/<u></u>pear')<br>
in /usr/share/mythtv/mythweb/<u></u>modules/_shared/tmpl/_errors/<u></u>fatal.php on<br>
line 43<br>
[Wed Oct 23 09:29:59.527127 2013] [:error] [pid 19627] [client<br>
<a href="http://192.168.0.15:58571" target="_blank">192.168.0.15:58571</a>] PHP Fatal error: SQL Error: Table<br>
'mythconverg.mythweb_sessions' doesn't exist [#1146] in<br>
/usr/share/mythtv/mythweb/<u></u>classes/Database/Query/mysql.<u></u>php on line 79<br>
<br>
<br>
It looks like my database schemata is broken. Any help will be appreciated.<br>
</blockquote>
<br></div></div>
Thanks for switching to the users list.<br>
<br>
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.<br>
<br>
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).<br>
<br>
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.<br>
<br>
Mike<br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/<u></u>listinfo/mythtv-users</a><br>
</blockquote></div><br></div>