[mythtv-users] #11918: !!NoTrans: SQL Error: Table 'mythconverg.mythweb_sessions' doesn't exist [#1146]!!
Michael T. Dean
mtdean at thirdcontact.com
Wed Oct 23 18:49:38 UTC 2013
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
More information about the mythtv-users
mailing list