[mythtv] mythweather-revamp testable yet?

[Lucien D.]

Robert,

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 :)

Lucien

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