[horde] installing ansel 2.0.2

[Michael J Rubinsky]

Quoting Andreas Schulze <sca at andreasschulze.de>:

> Am So, 12.05.2013, 23:18 schrieb Andreas Schulze:
>
>>> 2013-05-12T17:24:50+00:00 ERR: HORDE [horde] SQL QUERY FAILED:
>>> SQLSTATE[HY000]: General error: 1 RIGHT and FULL OUTER JOINs are  
>>> not currently supported
>
>
> Hi all,
>
> I got ansel still not running here.
> Using one of these fantastic searchengines advised in this forum :-)  
> I found a possible reason.
>
> http://www.horde.org/apps/ansel/docs/INSTALL claim
> "Any database supported by Horde_Db will work"
>
> I use sqlite.
>
> But http://www.sqlite.org/omitted.html claim
> "LEFT OUTER JOIN is implemented, but not RIGHT OUTER JOIN or FULL  
> OUTER JOIN."
>
>
> I expect, that sqlite is just *not* the right database backend for ansel.
> Could one of the developers confirm?


First off, I will assume you are running Horde 4? Ansel 2.x is not  
compatible with Horde 5. For the not yet released Ansel 3, Ansel no  
longer uses it's own tagging implementation, instead utilizing Horde's  
new (since Horde 5) Content_Tagger system. Content_Tagger has unit  
tests that (at least last I checked) are passing against sqlight.

If you *are* running Horde 4 then it looks like you cannot use sqlite  
with Ansel. Indeed, sqlite would probably be a pretty bad choice to  
run Horde on in general for anything more than a small testing setup.
-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2200 bytes
Desc: PGP Public Key
URL: <http://lists.horde.org/archives/horde/attachments/20130517/6fdcf8c1/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6062 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/horde/attachments/20130517/6fdcf8c1/attachment-0001.bin>