Bug 166662
| Summary: | www/asterisk-stat - pgsql select substring() problem | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Ports & Packages | Reporter: | vess | ||||||
| Component: | Individual Port(s) | Assignee: | Michael Scheidell <scheidell> | ||||||
| Status: | Closed FIXED | ||||||||
| Severity: | Affects Only Me | ||||||||
| Priority: | Normal | ||||||||
| Version: | Latest | ||||||||
| Hardware: | Any | ||||||||
| OS: | Any | ||||||||
| Attachments: |
|
||||||||
Even better - optimized query with order: $QUERY = "SELECT cast(calldate as date) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY cast(calldate as date) order by 1 desc"; //extract(DAY from calldate) Responsible Changed From-To: freebsd-www->freebsd-ports-bugs ports PR. The 'www' category is for problems with the FreeBSD.org website. Maintainer: I am assuming you didn't get a copy of this, due to the original submitters mistaken category. Please check this patch, and decide if you want to approve it. I would suggest a PORTREVISION bump (at least), and if this patch is needed, send it upstream? -- Michael Scheidell, CTO >*| * SECNAP Network Security Corporation d: +1.561.948.2259 w: http://people.freebsd.org/~scheidell Responsible Changed From-To: freebsd-ports-bugs->scheidell I'll take it. Maintainer feedback timeout. For audit, could everyone please test the attached patch? (curl 'http://www.freebsd.org/cgi/query-pr.cgi?pr=ports%2F166662&getpatch=2' | patch -EuNI) Veselin: to avoid confusion, this appears to apply your second QUERY. jfkimura: do you approve this patch? (note, I did bump PORTREVISION, this will force a rebuild for mysql as well as pgsql users, but it looks like this is the safest thing to do) -- Michael Scheidell, CTO SECNAP Network Security Corporation http://people.freebsd.org/~scheidell ______________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.spammertrap.com/ ______________________________________________________________________ State Changed From-To: open->feedback Ask for maintainer approval. State Changed From-To: feedback->closed No response. Don't know what submitter or maintainer wants to do. Closeing pr. scheidell 2012-06-09 11:10:50 UTC
FreeBSD ports repository
Modified files:
www/asterisk-stat Makefile
Added files:
www/asterisk-stat/files pgsql__patch-call.log.php
Log:
- Fix pgsql select substring() problem
- pet portlint (gd.4 to gd.[4-9] in LIB_DEPENDS)
- Bump PORTREVISION
PR: ports/166662
Submitted by: Veselin Slavov <vess@slavof.net>
Reviewed by: scheidell@ (me)
Approved by: F. Kimura <jfkimura@yahoo.co.jp> (maintainer)
Revision Changes Path
1.15 +3 -2 ports/www/asterisk-stat/Makefile
1.1 +9 -0 ports/www/asterisk-stat/files/pgsql__patch-call.log.php (new)
_______________________________________________
cvs-all@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/cvs-all
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
-------- Original Message -------- Subject: Re: ports/166662: www/asterisk-stat - pgsql select substring() problem Date: Sat, 9 Jun 2012 16:04:48 +0900 From: F. Kimura <jfkimura@yahoo.co.jp> Reply-To: F. Kimura <jfkimura@yahoo.co.jp> To: scheidell@FreeBSD.org <scheidell@FreeBSD.org>, vess@slavof.net <vess@slavof.net> I was not using e-mail for a month. Sorry. If possible, I want to accept this PR. // Fumihiko Kimura |
PG_VERSION = 9.0 While using statustics page for 'cdr report', 'RED TOTAL BAR TABLE' at the bottom not displayed. Here is part of /var/log/message: Apr 5 10:22:37 server postgres[34881]: [2-1] ERROR: function pg_catalog.substring(timestamp with time zone, integer, integer) does not exist at character 8 Apr 5 10:22:37 server postgres[34881]: [2-2] HINT: No function matches the given name and argument types. You might need to add explicit type casts. Apr 5 10:22:37 server postgres[34881]: [2-3] STATEMENT: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE (calldate) >= ('2012-01-01') AND (calldate) <= ('2012-03-31 23:59:59') GROUP BY substring(calldate,1,10) Fix: patch file attached Patch attached with submission follows: How-To-Repeat: http://127.0.0.1/asterisk-stat/cdr.php?s=1 Choose any period and click search.