[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