Re: [eGroupWare-developers] PostgreSQL error with categories at trunk@34914

[Anthony M. <ame...@me...>]

On 05/08/2011 10:22 AM, Anthony Messina wrote:
> Invalid SQL: SELECT COUNT(*) FROM egw_categories  WHERE cat_owner=0:
> ERROR:  operator does not exist: character varying = integer
> LINE 1: SELECT COUNT(*) FROM egw_categories  WHERE cat_owner=0
>                                                             ^
> HINT:  No operator matches the given name and argument type(s). You
> might need to add explicit type casts.
> 
> The offending lines seem to be:
> 
> phpgwapi/inc/class.categories.inc.php:896:              if
> 
> (!$GLOBALS['egw']->db->select(self::TABLE,'COUNT(*)','cat_owner=0',__LINE__,__FILE__)->fetchColumn())
> 
> 
> 
> phpgwapi/inc/class.categories.inc.php:898:
> 
> $GLOBALS['egw']->db->update(self::TABLE,'cat_owner=0',"(cat_owner=-1 OR
> cat_appname='phpgw')",__LINE__,__FILE__);
> 
> 
> Temporarily, modifying 'cat_owner=0' to 'cat_owner::int=0' solves the
> problem, though it appears that the long term goal is to support
> multiple numbers in the cat_owner field.  This method won't work for that.
> 

Replying to my first post as I'm not sure it made it through the list.  -A


-- 
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E