This is true, but the error message apparently does not reflect the exact
syntax. Digging a little deeper I found that indeed, attribute
'catsupdated' was not in the specified table. In fact, the table was
empty. The problem appears to be not with this part of the code, but the
fact that the table was not initialized properly....
John
Brian Johnson wrote:
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
_______________________________________________
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