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 11:12:59 -0400
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0

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="" class="moz-txt-link-rfc2396E" href="mailto:address@hidden">"mailto:address@hidden">address@hidden</a>

11864 Canon Blvd. - Suite 11 <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 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
  

-- 
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]