fixing problems in eGroupWare with MaxDB

Hi,

a few years ago I got eGroupWare (www.egroupware.org) running with MaxDB. Now one release later there are a few problems, I could not solve:

SELECT * FROM egw_addressbook
WHERE contact_tid='n' AND (egw_addressbook.contact_owner=7 OR contact_private=0 AND egw_addressbook.contact_owner IN (7,0) OR egw_addressbook.contact_owner IS NULL)
ORDER BY n_family<>'' DESC,n_family ASC,n_given ASC,org_name ASC maxdb Error: 37000 ([unixODBC][SAP AG][LIBSQLOD SO][MaxDB] Syntax error or access violation;-3008 POS(214) Invalid keyword or missing delimiter)

That query show the addressbook sorted by family-name (placing the contacts without family name at the end).

I also tried:

SELECT *,n_family<>'' AS others FROM egw_addressbook ...
ORDER BY others DESC,n_familiy ASC,n_given ASC,org_name ASC

But that gives the same error :-)

n_family, n_given and org_name are varchar(40), contact_owner, contact_private are int columns.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

I also noticed a strainge behavior of the odbc driver. Under openSUSE 10.2 (I think the same is true for all SuSE versions) the odbc.ini is usually in /etc/unixODBC. Placing it there does not work with MaxDB. It only works if I symlink /etc/odbc.ini to /etc/unixODBC/odbc.ini. Took me quite a while to find out ...

Ralf
--

Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de Outdoor Unlimited Training GmbH [www.outdoor-training.de] Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany Telefon +49 (0)631 31657-0

--

MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/maxdb?unsub=lists@pantek.com Received on Mon Jun 25 16:33:19 2007