Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
fixing problems in eGroupWare with MaxDB

fixing problems in eGroupWare with MaxDB

2007-06-25       - By Ralf Becker

 Back
Reply:     1     2     3  

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.

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=mysql@(protected)