Re: smsd sometimes duplicates messages to mysql -database

[Lukasz Michalski]

On Saturday 03 of March 2007 07:55:34 Ari Arokoski wrote:
> Hello,
>
> Has anyone solved the this problem? Occasionally smsd inserts the same row
> twice in to msql database.
>
> I tried to fix this by adding a wait time after the message deletion. I
> thought that the reason is that the mobile is not deleting he message fast
> enough, so SMSD reads the message again before it is actually deleted from
> mobile.
>
> If anybody has solution to this, I would appreciate it.
>

The simplest one:
Create UNIQUE index on inbox table that prevent this.

Regards,
Łukasz