PostgreSQL error with categories at trunk@34914

[Anthony_Messina]

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.

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

[Anthony_Messina]

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

[Ralf_Becker_Stylite]

Hi Anthony,

should be fixed with r34949.

Thanks for reporting

Ralf

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.

---

WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

---

Geschäftsführer Andre Keller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951

---

Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers