- Previous message: Victor Duchovni: "Re: Programatically changing posfix aliases ?"
- Maybe in reply to: Pierguido: "Re: Long domains"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
|
|
|
From: mouss (no email)
Date: Mon Apr 02 2007 - 16:25:56 EDT
Pierguido wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> mouss wrote:
>
>> Search for "skipped" in
>> http://www.postfix.org/mysql_table.5.html
>>
>> Either remove the row from your table or put something in the
>> description field.
>>
>>
> mysql> SELECT description FROM domain WHERE domain='alephweb.com' and
> backupmx='0' and active='1';
> +-------------+
> | description |
> +-------------+
> | |
> +-------------+
> 1 row in set (0.00 sec)
>
> mysql> SELECT description FROM domain WHERE
> domain='galleriadelsecondorinascimento.com' and backupmx='0' and active='1';
> +-------------+
> | description |
> +-------------+
> | |
> +-------------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> This are two query in mysql...the first one is not working, the second yes.
> UHm...right now, while i was writing, i noticed one thing...i was
> modiying the description of every domain...and i saw that in every
> domain there is a space character...in the long domains not...that is
> probably the reason of the error.
> Now i'll check the application should manage this...maybe a bug.
> Thank you very much for your patience.
>
SELECT 1 FROM domain WHERE ...
is probably what you want.
|
|
|