[mythtv-users] mythweb fails when searching for "other showing of a program"

[Bill Meek]

On Tue, 2010-11-30 at 00:10 -0800, Oz Dror wrote:
...

Hi;

To be sure, when recreating this issue, do you:

 Select Upcoming Recordings,
  Click on a program
   Click on "Find other showings of this program"

The above works for me (running trunk at 27372.)

I'm on ubuntu 10.04 and 10.10, dpkg -l php5 should
show you're on 5.3.2-1ubuntu4.5 or later, right?

If you're up for it, load the failing page, add the
echo below and then reload the failing page.  The
SQL query will print on the top line.  You can then
run the query manually, to see if the error string
in your initial post is related. Remove the echo!

  modules/tv/classes/Channel.php
         // Query (Line 70)
    -------> echo($sql); <--------
             $sh = $db->query($sql);
             $channel_list = array();
             while ($chanid = $sh->fetch_col())

Since you mentioned that other mythweb pages are working, maybe the
old IP address issue isn't important for now.

But, FYI, here's mine, mc0 is my Master Backend, ofc0 is a Slave
Backend:

mysql> SELECT * FROM settings WHERE value LIKE '%ServerIP';
+-----------------+---------------+----------+
| value           | data          | hostname |
+-----------------+---------------+----------+
| MasterServerIP  | 192.168.2.200 | NULL     |
| BackendServerIP | 192.168.2.200 | mc0      |
| BackendServerIP | 192.168.2.204 | ofc0     |
+-----------------+---------------+----------+

Take care,

Bill Meek