phpgroupware-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Phpgroupware-users] sitemgr...


From: Chris Weiss
Subject: Re: [Phpgroupware-users] sitemgr...
Date: Wed, 11 Sep 2002 14:47:28 +0000

" should be ' in sql statements


John Burton (address@hidden) wrote*:
>
>
>
>
>
>
>
>Hi Patrick,
>
>I tried your and it appeared to correct that particular problem. There was
>one instance in  class.Pages_SO.inc.php and two in 
>class.Categories_db_SO.inc.php.
> Now I get the error:
>
>
> --      Database error: Invalid
>SQL: SELECT value FROM phpgw_sitemgr_preferences WHERE name="catsupdated"
> PostgreSQL Error: 1 (ERROR:  Attribute 'catsupdated' not found )
>
>File: /var/www/html/FIRST/sitemgr/inc/class.sitePreference_SO.inc.php
>Line: 33Session halted.
>
>thoughts?
>
>John
>
>
>Patrick J. Walsh (mr_e) wrote:
>    Looks like PostgreSQL
>doesn't like the "WHERE 1" clause.  I haven't tested  the latest SiteMgr
>under PostgreSQL so it looks like you're the guinea pig.  Try this: go to
>the sitemgr/inc directory and edit each of the following  files:
>
>class.Pages_SO.inc.php
>class.Categories_db_SO.inc.php
>
>and search through them for "WHERE 1" (without the quotes).  Try changing
> this to "WHERE 1=1" and let me know if that fixes the problem.  If it does,
> I'll update CVS.
>
>..mr_e
>
>
>--On Tuesday, September 1, 22 4:44 PM -4,
>--John Burton <address@hidden> wrote:
>
>  <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.1
>Transitional//EN">
><html>
><head>
>  <title></title>
></head>
><body>
>Greetings,<br>
><br>
>I just CVS'd the "sitemgr" application from the phpgroupware site. I got
>it installed fine and added to my list of applications. I went into the
>"Administration" page and down to "Web Content Manager". I clicked on
>"Site Setup" and got the following error:<br>
><br>
><br>
><!-- </center> --><!-- END sitemgr_header -->       <b>Database
>error:</b>
>Invalid SQL: SELECT page_id FROM phpgw_sitemgr_pages WHERE 1 ORDER BY
>cat_id, sort_order ASC<br>
> <b>PostgreSQL Error</b>: 1 (ERROR:  WHERE clause must return
>type
>boolean, not type integer )<br>
> <br>
><b>File:</b> /var/www/html/FIRST/sitemgr/inc/class.Pages_SO.inc.php<br>
>
><b>Line:</b> 21<b>Session halted.</b><!-- BEGIN
>footer -->             <br>
>                                                                               
>    
     
><br>
>I'm using phpgroupware .9.14 installed on a RedHat 7.3 patched to the
>current "official" RedHat packages. I also did a CVS update as of today
>(9/1/2). <br>
><br>
>Does anyone have any thoughts or suggestions?<br>
><br>
>John<br>
><br>
><pre class="moz-signature" cols="$mailwrapcol">--
>John Burton, Ph.D.
>Principal Associate              GATS, Inc.
><a class="moz-txt-link-abbreviated"
>href="mailto:address@hidden";>address@hidden</a>
>
>11864 Canon Blvd. - Suite 11 <a class="moz-txt-link-abbreviated"
>href="mailto:address@hidden";>address@hidden</a> (personal)         
>Newport
>News, VA 2366 (757) 873-592 (voice)           (757) 873-5924 (fax)
>
></pre>
></body>
></html>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
>
>
>
>
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>





reply via email to

[Prev in Thread] Current Thread [Next in Thread]