logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Re: strange behavior with 2.1.5: msg#00189

Subject: Re: strange behavior with 2.1.5
Jorge Bastos wrote:
> Strange,
> I was reading there emails on this "strange" behavior 'cause it happend
> the same (it seems the same) to me.
> When i upgraded to dbmail 2.1.5 from 2.0.9 i've lost some emails that
> had null links (or something), could be this due to, i don't runned
> dbmail-util -by ?

no.

> For now i'm with 2.0.9, and runned dbmail-util -a -y that deleted many
> (really) many messages with null links.
> If i want to upgrade to 2.1.5 to have SORT support, should i upgrade the
> database, with the script inside sql/mysql ? wich one's?

Run all the add_XXX scripts. After that, you need to run dbmail-util -by
once.

> Is the table's type InnoDB mandatory?

For mysql yes! Starting 2.1.x myisam tables are deprecated. Dbmail is
counting on the foreign key restraints provided by innodb.

> Just one more question :-)
> Can i set database+tables+fields to character set=utf8 and
> collation=utf8_general_ci ? doesn't conflit with nothing?

Dbmail tries very hard to be charset neutral. Setting the charset and
collation to match your typical usage pattern will affect only SORT
afaik, and that's very likely just what you want.

> 
> Jorge
> 
> 
> 
> ----- Original Message ----- From: "Matthew Sayler" <sayler@xxxxxxxxxxxxx>
> To: "DBMail mailinglist" <dbmail@xxxxxxxxxx>
> Sent: Wednesday, March 15, 2006 6:03 PM
> Subject: Re: [Dbmail] strange behavior with 2.1.5
> 
> 
>> On Wed, Mar 15, 2006 at 12:34:12PM -0500, Adam Kosmin wrote:
>>
>>> nope, new install :)
>>
>>
>>> >>>Using thunderbird, subject lines are not appearing in the preview
>>> >>>pane.
>>> >>>I've reproduced this error on multiple accounts and see that it is
>>> >>>consistent regardless of folder name (INBOX, Sent, Trash...). The
>>> >>>Subject: header is intact however.
>>
>>
>> Only subject lines missing from the preview pane, or all headers
>> (sender, date, etc.)?
>>
>> If you're on a new install, I bet that you followed the INSTALL
>> instructions...  They need to be updated to tell you to run the
>> appropriate SQL scripts to enable the header cache et all.  I've
>> attached a simple patch to fix the instructions, though the mysql
>> section probably needs to be ammended to say that InnoDB is required (at
>> least as far as the add_header_tables script is concerned).
>>
>> If you add the tables, you will need to do a dbmail-util -by
>>
>> Matt
>>
>>
>>
> 
> 
> --------------------------------------------------------------------------------
> 
> 
> 
>> _______________________________________________
>> Dbmail mailing list
>> Dbmail@xxxxxxxxxx
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> 
> 
> _______________________________________________
> Dbmail mailing list
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> 


-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl


<Prev in Thread] Current Thread [Next in Thread>