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

* Your Email Address
* Spam protection	Enter the letters below: .__ .__ . .. .. , [__)\| \\| \|\|_/ \./ [__)\|__/\|__\|\| \ \|
Comment	> 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...
Attachment
Watch this ticket