Welcome to Geeklog, Anonymous Saturday, October 17 2026 @ 01:57 pm EDT

Comments for Geeklog 1.8.0 BETA 2

Geeklog 1.8.0 BETA 2 | 2 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Geeklog 1.8.0 BETA 2 PostgreSQL problems

Authored by: Brian McCane on Wednesday, May 04 2011 @ 11:09 am EDT

I attempted to install this geeklog beta on a FreeBSD server using my existing PostgreSQL server. Some of the administrator utitlities I have tried do not work because they are calling the MySQL function UNIX_TIMESTAMP() which does not exists on PostgreSQL.

For PostgreSQL the equivalent functions are:

UNIX_TIMESTAMP() => 'FLOOR(EXTRACT(EPOCH FROM now()))'
UNIX_TIMESTAMP(foo) => 'FLOOR(EXTRACT(EPOCH FROM foo))'

If fractional seconds are acceptable, you can eliminate the 'FLOOR' function.

Geeklog 1.8.0 BETA 2 PostgreSQL problems

Authored by: Roccivic on Sunday, May 15 2011 @ 07:58 am EDT

I can't reproduce this problem. Exactly what doesn't work?
I did find a call to UNIX_TIMESTAMP() in the DB_save() function, but I can't find any problems relating to this...

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks