Re: Using DB to cache METARs ?

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

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