[mythtv] mythweather-revamp testable yet?

Lucien D. ldunning at gmail.com
Mon Aug 21 04:47:46 UTC 2006


Subqueries were added with mysql 4.1, I'm guessing ur using an older version.
If you upgrade that problem should go away.  If myth is supposed to support
older mysql versions, I can change it to not use a subquery.

However, there are currently no sources providing data for anywhere outside the
US.  So while I applaud your bravery in wanting to try it out, you'll probably
want to wait a few more weeks :)


On 16:04 Mon 21 Aug     , Robin Gilks wrote:
> Greetings
> Should the Mythweather revamp be testable yet? I get the following error
> and never get past the "Screen cannot be used, not all required data is
> supplied by existing sources" popup whenever I try to activate any screen.
> 2006-08-21 14:11:08.469 MSqlQuery: SELECT sourceid, source_name,
> update_timeout, retrieve_timeout, path, author, version, email, types FROM
> weathersourcesettings WHERE hostname='zeus' AND sourceid IN (SELECT
> DISTINCT weathersourcesettings_sourceid FROM weatherdatalayout);
> 2006-08-21 14:11:08.470 You have an error in your SQL syntax.  Check the
> manual that corresponds to your MySQL server version for the right syntax
> to use near 'SELECT DISTINCT weathersourcesettings_sourceid FROM
> weatherdata QMYSQL3: Unable to execute query
> I'd really like to give this a tryout as the existing weather stuff is
> useless due to the errors it makes in timezones and days of the week (up
> to 3 days off sometimes) - at least here in New Zealand it is!
> -- 
> Robin Gilks
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev

More information about the mythtv-dev mailing list