Re: Using DB to cache METARs ?

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

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