It seems that specific mysql funtions are used. I'm using postgresql and get the following errors:

I have no idea wath those funstion do!

Is there any chance tose function will be ported to postgresql?

If I can help or test please let me know.

warning: pg_query() [function.pg-query]: Query failed: ERROR: Function std(integer) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts in /drupal/includes/database.pgsql.inc on line 84.

user warning: query: SELECT AVG(timer) AS avg, STD(timer) AS se FROM accesslog WHERE timestamp > 1143842400 AND timestamp <= 1143849600 in /drupal/includes/database.pgsql.inc on line 103.

CommentFileSizeAuthor
#1 graphstat.module11.36 KBDriesK

Comments

DriesK’s picture

DriesK commented
StatusFileSize
new graphstat.module11.36 KB

Hi Erwin,

I changed the sql, it should work both in mysql and postrgresql now (according to the postgres manual, that is). I don't have postgresql installed, so I can't test. I didn't know whether you know how to apply a patch, so I just uploaded the complete module file. Can you copy this file into your graphstat directory and give it a try?

DriesK’s picture

DriesK commented

oh, and what that function does is calculating the standard deviation of page generation time.

erwin’s picture

erwin commented

Hello Dries,

I installed the module and all seems to work well, haven't seen any errors.

Please let me know if you want code tested against a postgresql database, I'm willing to help (ofcourse)..

DriesK’s picture

DriesK commented
Status: Active » Fixed

Fix has been committed to cvs, thanks for testing. If I have some other postgres issue that needs testing I'll let you know!

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)