Database error in serendipity_event_microformats plugin

[ads]

Hello,

the plugin in $topic uses a MySQL specific SQL command:

Code: Select all

value > (UNIX_TIMESTAMP(NOW()) - 432000)

PostgreSQL (don't know about other databases) has no "unix_timestamp" function, one can use:

Code: Select all

value > (extract(epoch from now())::integer - 432000)

If i do a grep in the blog directory i see 4 other occurences of UNIX_TIMESTAMP.

[garvinhicking]

Hi!

When "value" is a string field, how would the SQL statement need to look like for proper integer casting for pgsql?

Regards,
Garvin

[ads]

Code: Select all

value::integer

or

Code: Select all

cast(value as integer)

[garvinhicking]

Hi!

Okay, thanks. I'll try to patch up the plugins that use this.


Regards,
Garvin

[ads]

I only have PG 8.2 running which is not as strict as 8.3 with implicit casts. maybe someone else can test your patch on PG 8.3 too.