[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-users] sitemgr...
|
From: |
Brian Johnson |
|
Subject: |
Re: [Phpgroupware-users] sitemgr... |
|
Date: |
Wed, 11 Sep 2002 15:03:28 +0000 |
A little brief, but Chris is right - check that your nested quotes within (and
around) the SQL statement don't cancel themselves out
ie use " ' ' " not " " " "
Chris Weiss (address@hidden) wrote*:
>
>" 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
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>