On Wed, Sep 14, 2016 at 10:27:32AM +0200, Antoine Nguyen wrote:
> >Do make sure that your tests with the sql CLI really make the same
> >query against the same database:
> >
> > SELECT name FROM admin_domain WHERE name='<utf-8-domain>' AND
> > type='domain' AND enabled=1
> >
> I've enabled queries logging. Here is the result :
>
> 160914 8:24:14 57 Query SELECT name FROM admin_domain WHERE
> name='gaël.com' AND type='domain' AND enabled=1
> 160914 8:24:31 60 Connect modoboa@localhost as anonymous on modoboa
> 60 Query SELECT name FROM admin_domain WHERE
> name='gaël.com' AND type='domain' AND enabled=1
> 60 Quit
>
> The first query was executed using mysql shell and it returns 1 row. The
> second query was executed by postmap and returns nothing whereas we can see
> they are the same...
Do post the "Connect" string for *both* queries.
--
Viktor.