phpgroupware-users
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Phpgroupware-users] sitemgr...

From: John Burton
Subject: Re: [Phpgroupware-users] sitemgr...
Date: Wed, 11 Sep 2002 10:45:57 -0400
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
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 10, 2002 4:44 PM -0400,
--John Burton <address@hidden> wrote:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 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 0.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/10/02). <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="" class="moz-txt-link-rfc2396E" href="mailto:address@hidden">"mailto:address@hidden">address@hidden</a>
11864 Canon Blvd. - Suite 101 <a class="moz-txt-link-abbreviated"
href="" class="moz-txt-link-rfc2396E" href="mailto:address@hidden">"mailto:address@hidden">address@hidden</a> (personal)          Newport
News, VA 23606 (757) 873-5920 (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 

-- 
John Burton, Ph.D.
Principal Associate              GATS, Inc.  
address@hidden          11864 Canon Blvd - Suite 101
address@hidden (personal)          Newport News, VA 23606
(757) 873-5920 (voice)           (757) 873-5924 (fax)

reply via email to
[Prev in Thread] Current Thread [Next in Thread]