From owner-freebsd-www@FreeBSD.ORG Mon Apr 2 11:07:22 2012 Return-Path: Delivered-To: freebsd-www@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 5A69E1065670 for ; Mon, 2 Apr 2012 11:07:22 +0000 (UTC) (envelope-from owner-bugmaster@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 444EE8FC1A for ; Mon, 2 Apr 2012 11:07:22 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q32B7MpS046981 for ; Mon, 2 Apr 2012 11:07:22 GMT (envelope-from owner-bugmaster@FreeBSD.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q32B7L8K046979 for freebsd-www@FreeBSD.org; Mon, 2 Apr 2012 11:07:21 GMT (envelope-from owner-bugmaster@FreeBSD.org) Date: Mon, 2 Apr 2012 11:07:21 GMT Message-Id: <201204021107.q32B7L8K046979@freefall.freebsd.org> X-Authentication-Warning: freefall.freebsd.org: gnats set sender to owner-bugmaster@FreeBSD.org using -f From: FreeBSD bugmaster To: freebsd-www@FreeBSD.org Cc: Subject: Current problem reports assigned to freebsd-www@FreeBSD.org X-BeenThere: freebsd-www@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: FreeBSD Project Webmasters List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 02 Apr 2012 11:07:22 -0000 Note: to view an individual PR, use: http://www.freebsd.org/cgi/query-pr.cgi?pr=(number). The following is a listing of current problems submitted by FreeBSD users. These represent problem reports covering all versions including experimental development code and obsolete releases. S Tracker Resp. Description -------------------------------------------------------------------------------- o www/166496 www HP-UX manual pages are mangled o www/164096 www PR submission form has no field labelled synopsis o www/161174 www Make http://www.freebsd.org/cgi/search.cgi search GNAT o www/159291 www Error 404 - when I try to send-pr over freebsd.org/es/ s www/157076 www freebsd-wireless mailing list not shown on web All Lis o www/149446 www [patch] improve misleading title of "report a bug" o www/145917 www SVG at logo.html is broken s www/140580 www svnweb file logs are useless s www/129923 www Need stylesheet for FreeBSD Subversion DAV tree s www/111791 www FreeBSD website messes up while using "links" browser s www/103522 www Search interface oddity s www/73551 www [request] fix list archive 'quoted-printable' corrupti s www/51135 www Problems with the mailing-lists search interface 13 problems total. From owner-freebsd-www@FreeBSD.ORG Tue Apr 3 20:09:29 2012 Return-Path: Delivered-To: www@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 883F21065670 for ; Tue, 3 Apr 2012 20:09:29 +0000 (UTC) (envelope-from bounce@vikingpchealth.com) Received: from vdc.vikingpc.org (unknown [IPv6:2604:7800:0:1:2063:daff:fe01:f2e3]) by mx1.freebsd.org (Postfix) with ESMTP id 28A838FC14 for ; Tue, 3 Apr 2012 20:09:28 +0000 (UTC) Received: from centos ([127.0.0.1] helo=pccleanuppro.com) by vdc.vikingpc.org with esmtp (Exim 4.69) (envelope-from ) id 1S8aCH-00045f-W7 for www@freebsd.org; Fri, 16 Mar 2012 12:40:10 -0400 To: www@freebsd.org Message-ID: <1738004e2eefbabf96d6efe06236052e@pccleanuppro.com> From: "DigitalTV" MIME-Version: 1.0 X-Mailer-LID: 7 X-Mailer-RecptId: 298038 X-Mailer-SID: 27 X-Mailer-Sent-By: 1 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - vdc.vikingpc.org X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - vikingpchealth.com Content-Type: text/plain; format=flowed; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: Watch tv on your pc X-BeenThere: freebsd-www@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: noreply@vikingpchealth.com List-Id: FreeBSD Project Webmasters List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Date: Tue, 03 Apr 2012 20:09:29 -0000 X-Original-Date: Fri, 16 Mar 2012 12:16:57 -0400 X-List-Received-Date: Tue, 03 Apr 2012 20:09:29 -0000 DigitalTVforPC Stop paying monthly subscription fees. DigitalTVforPC 2 delivers more channels than satellite TV & cable combined without all the hardware charges, pay-per view costs, and monthly fees. Start Watching Instantly! Get Worldwide news, sports, feature-lenght movies, full TV episodes, and more on your PC from anywhere in the world! Stop paying monthly fees. Learn how. " A lot easier to install than I thought. I was watching live TV on my PC in minutes. Impressive." Louis M. - Sacramento, Ca With DigitalTVforPC you get many advantages: Over 2,318 LIVE TV Channels! Unlimited Viewing No Hardware No Monthly Fees No Subscription No Contract Get MORE with DigitalTVforPC Our software technology leverages the power of our playback engine and proprietary entertainment database to connect you directly to hundreds of live digital channels from across the world. Viewing these channels is simple , allowing you to watch all you want, wherever you want whenever your PC is connected to the Internet. All at no extra cost! Imagine watching 2,318 live channels whenever you want, wherever you want all at the convenience and comfort of your desktop or laptop computer! This message was intended for: %www@freebsd.org% Unsubscribe me from this list Click this link to unsubscribe: http://pccleanuppro.com/vem/unsubscribe.php?M=298038&C=615126db177a7d4c402e6e45b7d5dc9f&L=7&N=27 From owner-freebsd-www@FreeBSD.ORG Thu Apr 5 08:20:08 2012 Return-Path: Delivered-To: freebsd-www@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id CC84B106566C for ; Thu, 5 Apr 2012 08:20:08 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 9DAFA8FC16 for ; Thu, 5 Apr 2012 08:20:08 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q358K8Jf096528 for ; Thu, 5 Apr 2012 08:20:08 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q358K85U096527; Thu, 5 Apr 2012 08:20:08 GMT (envelope-from gnats) Resent-Date: Thu, 5 Apr 2012 08:20:08 GMT Resent-Message-Id: <201204050820.q358K85U096527@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-www@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Veselin Slavov Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 0AB77106566B for ; Thu, 5 Apr 2012 08:14:17 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from red.freebsd.org (red.freebsd.org [IPv6:2001:4f8:fff6::22]) by mx1.freebsd.org (Postfix) with ESMTP id EA20B8FC12 for ; Thu, 5 Apr 2012 08:14:16 +0000 (UTC) Received: from red.freebsd.org (localhost [127.0.0.1]) by red.freebsd.org (8.14.4/8.14.4) with ESMTP id q358EGjU045439 for ; Thu, 5 Apr 2012 08:14:16 GMT (envelope-from nobody@red.freebsd.org) Received: (from nobody@localhost) by red.freebsd.org (8.14.4/8.14.4/Submit) id q358EG9E045423; Thu, 5 Apr 2012 08:14:16 GMT (envelope-from nobody) Message-Id: <201204050814.q358EG9E045423@red.freebsd.org> Date: Thu, 5 Apr 2012 08:14:16 GMT From: Veselin Slavov To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: www/166662: www/asterisk-stat - pgsql select substring() problem X-BeenThere: freebsd-www@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: FreeBSD Project Webmasters List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Apr 2012 08:20:09 -0000 >Number: 166662 >Category: www >Synopsis: www/asterisk-stat - pgsql select substring() problem >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-www >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Thu Apr 05 08:20:08 UTC 2012 >Closed-Date: >Last-Modified: >Originator: Veselin Slavov >Release: 7.4-STABLE >Organization: >Environment: FreeBSD server.slavof.net 7.4-STABLE FreeBSD 7.4-STABLE #57: Mon Mar 12 14:33:42 EET 2012 vess@server.slavof.net:/usr/obj/usr/src/sys/server i386 >Description: 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) >How-To-Repeat: http://127.0.0.1/asterisk-stat/cdr.php?s=1 Choose any period and click search. >Fix: patch file attached Patch attached with submission follows: --- call-log.php.orig 2012-04-05 10:48:18.000000000 +0300 +++ call-log.php 2012-04-05 10:48:29.000000000 +0300 @@ -229,7 +229,7 @@ /************************/ - $QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)"; //extract(DAY from calldate) + $QUERY = "SELECT substr(cast(calldate as text),1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substr(cast(calldate as text),1,10)"; //extract(DAY from calldate) //echo "$QUERY"; >Release-Note: >Audit-Trail: >Unformatted: From owner-freebsd-www@FreeBSD.ORG Thu Apr 5 08:57:33 2012 Return-Path: Delivered-To: freebsd-www@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 2FFE31065678; Thu, 5 Apr 2012 08:57:33 +0000 (UTC) (envelope-from linimon@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 030958FC18; Thu, 5 Apr 2012 08:57:33 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q358vWJT034552; Thu, 5 Apr 2012 08:57:32 GMT (envelope-from linimon@freefall.freebsd.org) Received: (from linimon@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q358vW31034548; Thu, 5 Apr 2012 08:57:32 GMT (envelope-from linimon) Date: Thu, 5 Apr 2012 08:57:32 GMT Message-Id: <201204050857.q358vW31034548@freefall.freebsd.org> To: linimon@FreeBSD.org, freebsd-www@FreeBSD.org, freebsd-ports-bugs@FreeBSD.org From: linimon@FreeBSD.org Cc: Subject: Re: ports/166662: www/asterisk-stat - pgsql select substring() problem X-BeenThere: freebsd-www@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: FreeBSD Project Webmasters List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Apr 2012 08:57:33 -0000 Synopsis: www/asterisk-stat - pgsql select substring() problem Responsible-Changed-From-To: freebsd-www->freebsd-ports-bugs Responsible-Changed-By: linimon Responsible-Changed-When: Thu Apr 5 08:56:54 UTC 2012 Responsible-Changed-Why: ports PR. The 'www' category is for problems with the FreeBSD.org website. http://www.freebsd.org/cgi/query-pr.cgi?pr=166662 From owner-freebsd-www@FreeBSD.ORG Fri Apr 6 10:50:53 2012 Return-Path: Delivered-To: www@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 1C8B8106566B for ; Fri, 6 Apr 2012 10:50:53 +0000 (UTC) (envelope-from talbright@brigadoonsoftware.com) Received: from server.brigadoon.com (server.brigadoonsoftware.com [68.170.144.230]) by mx1.freebsd.org (Postfix) with ESMTP id DAF198FC08 for ; Fri, 6 Apr 2012 10:50:52 +0000 (UTC) Received: from ool-18bbb54d.dyn.optonline.net ([24.187.181.77]:46500 helo=[192.168.1.8]) by server.brigadoon.com with smtp (Exim 4.77) (envelope-from ) id 1SG6km-00066S-GT for www@freebsd.org; Fri, 06 Apr 2012 06:50:52 -0400 Message-Id: <1XHjOytSPhBWWwBqKmo4BDmFfWlGK7BOEoGmM67yJHzn@brigadoonsoftware.com> Mime-Version: 1.0 From: Tim Albright To: www@freebsd.org Date: Fri, 6 Apr 2012 06:50:51 -0400 X-Mailer: MBM v2.7-US X-Bounce-Tracking-Info: Content-type: text/plain; charset=iso-8859-1; format=flowed Content-transfer-encoding: quoted-printable X-ACL-Warn: { X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - server.brigadoon.com X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - brigadoonsoftware.com X-Source: X-Source-Args: X-Source-Dir: Cc: Subject: Laptop Theft a Problem on Campus? We Can Locate & Recover Your Missing Computer Worldwide X-BeenThere: freebsd-www@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: FreeBSD Project Webmasters List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 06 Apr 2012 10:50:53 -0000 =08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08= =08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08=08= =08=08=08=08=08=08Greetings, Our award PC PhoneHome and MacPhoneHome is the NUMBER ONE stand-alone computer tracking and recovery software in the world to both the Windows and Mac communities! We are currently protecting over 1,500,000 computers worldwide=2E Our recovery rate is better than 99% over the last thirteen years=2E= =2E=2E We are offering a SPECIAL SPRING DISCOUNT to students,faculty and institutions=2E We will soon be releasing PhoneHome protection for iPad, iPhone, and iPod Touch as well as for Android Tablets and Android Phones=2E Version 4=2E0 will offer our users multi-lingual installation and documentation in English, Spanish, Portuguese, Italian, French and German language=2E Version 4=2E0 will also silently snap the picture of whoever is sitting at the computer and send you a picture of the thief if your computer is lost or stolen=2E PLUS=2E=2E=2E Stay tuned for the release of USB PhoneHome, a brand new application that will protect and provide PhoneHome protection to all your USB devices such as: Thumb Drives, External Hard Drives, External Backup Disks & Firewire External Storage Devices=2E Every time a PC PhoneHome or MacPhoneHome protected computer makes an Internet connection, it sends a stealth email message containing its exact location to a pre-determined email address of the user's choice and to our Worldwide Command Center=2E In the event your computer goes missing, all you need to do is make a police report and contact us= =2E We do the rest=2E Your missing computer is returned to you with the help of our recovery agents, local police services and global ISPs=2E A single copy of PC PhoneHome and MacPhoneHome normally retails for $29=2E95 USD and allows the user to protect one computer from loss or theft=2E Please visit: http://www=2Ebrigadoonsoftware=2Ecom/purchase=2Ehtml today to purchase and download your copy of PC PhoneHome/MacPhoneHome Whether you're trying to protect one hundred computers or twenty thousand we have the right license plan for you=2E Information on our product line is available for download directly from our web site at: http://www=2Ebrigadoonsoftware=2Ecom If you require any additional information, please contact me directly= =2E Best regards Tim Albright VP - Sales Brigadoon Software, Inc=2E 119 Rockland Center Suite 250 Nanuet, New York 10954 USA Tel: +1-845-624-0909 Fax: +1-845-624-0990 Skype: brigadoon_ny Email: talbright@brigadoonsoftware=2Ecom Web: http://www=2Ebrigadoonsoftware=2Ecom To be excluded from future emails, please type "Remove"=20 in the subject line and reply to this message=2E Please include all email aliases you are using=2E