Re: Using DB to cache METARs ?

[Phil P. <phi...@sw...>]

For some reason at least some (most likely all) of the ICONS were 
currupted when I downloaded them via CVS, copying back the set I 
received from the 2.2.0 release works fine.

Now all I need to do is FSCK with the {select an icon} code so that it 
correctly shows DAYTIME icons for my location and I'm set.

Thanks,
Phil P

Phil Pierotti wrote:

> Downloaded the updates via CVS:
> 
>     MySQL access is now working :-)
>     MySQL access is now caching :-) :-)
> 
> For some reason, I'm no longer getting the ICONS displayed, though this 
> could easily be some random stupidity in how I've scripted it into my 
> site. (sigh)
> 
> Thanks Very Muchly!
> 
> Phil P
> 
> Phil Pierotti wrote:
> 
>> Just to be clear, by this you mean you've fixed the timestamping/cache 
>> problem for MySQL and the NULL database?
>>
>> In that case, did you see my other post about issues getting MySQL 
>> access to work?
>>
>> [ after much actually reading the configuration page, I realized I 
>> needed to physically (ie manually) copy the defaults file to my 
>> phpweather (eg in order to enable debug) -sigh- obviously not enough 
>> coffee yesterday]
>>
>> DEBUG=everything shows me:
>>
>> Fatal error: SQL-statement failed: CREATE TABLE pw_metars( icao 
>> char(4) NOT NULL, time timestamp(14), metar varchar(255) NOT NULL, 
>> timestamp timestamp(14), PRIMARY KEY (icao)
>> MySQL said You have an error in your SQL syntax near '' at line 6 (1064).
>>
>> When I configure for MySQL database access, and then use the Create 
>> Tables page.
>>
>> Thanks,
>> Phil P
>>
>> Martin Geisler wrote:
>>
>>> Phil Pierotti <phi...@sw...> writes:
>>>
>>>
>>>> Hopefully someone out there can gimme a hand to work this one out.
>>>
>>>
>>>
>>>
>>> I've just resend my earlier responce to the list, I really don't know
>>> why, but it never made it through. :-/
>>>
>>> And to follow up on that, I've updated CVS so that things should work
>>> again for the MySQL and null databases.
>>>
>>> The rest is a mess --- we have a half-implemented archiving feature
>>> that someone needs to rewrite.  Any chance you could do that, Etienne?
>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IBM Linux Tutorials.
>> Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
>> Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
>> Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
>> _______________________________________________
>> PHPWeather-devel mailing list
>> PHP...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpweather-devel
>>
>>
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> _______________________________________________
> PHPWeather-devel mailing list
> PHP...@li...
> https://lists.sourceforge.net/lists/listinfo/phpweather-devel
> 
>