[Tickets #9151] Re: Kronolith, Nag, Mnemo, Turba don't work with Oracle DB

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9151
------------------------------------------------------------------------------
  Ticket             | 9151
  Updated By         | robert at databee.org
  Summary            | Kronolith, Nag, Mnemo, Turba don't work with Oracle DB
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


robert at databee.org (2010-07-27 19:38) wrote:

way better - we're getting close, I think.

Now getting those errors:

Jul 28 01:25:16 HORDE [error] [kronolith] MDB2 Error: not found:  
[Error message: Could not select the database:  
dwo/dbrmz.robbienet.local]
  [pid 8796 on line 1348 of  
"/home/horde/horde-webmail-1.2.6/kronolith/lib/Kronolith.php"]
Jul 28 01:25:16 HORDE [error] [kronolith] MDB2 Error: not found:  
[Error message: Could not select the database:  
dwo/dbrmz.robbienet.local]
  [pid 8742 on line 470 of  
"/home/horde/horde-webmail-1.2.6/lib/Horde/Share/sql.php"]

Have no Idea, what that could mean...

Looking at the log, I found another error:

Jul 28 01:22:43 HORDE [error] [imp] DB Error: unknown error: SELECT  
sentmail_recipient, count(*) AS sentmail_count FROM imp_sentmail WHERE  
sentmail_who = 'rmarz' AND sentm
ail_success = 1 AND sentmail_action in ('new', 'forward', 'reply',  
'redirect') GROUP BY sentmail_recipient ORDER BY sentmail_count DESC  
LIMIT 10 [nativecode=ORA-00933: SQL
  command not properly ended] [pid 4593 on line 120 of  
"/home/horde/horde-webmail-1.2.6/imp/lib/Sentmail/sql.php"]

it is the "LIMIT 10" at the end.
What should that do? Limit the resultset to 10 rows?
"where rownum <10" would do that
I would use no restriction at all and fetch only the first 10 rows...