Issue with Scheduler Duplicates not prevented.

[guyt101z]

Using Webservices to populate scheduler for outgoing SMS. Most Providers block duplicates if sent within a period so this is definitely an important feature to prevent that also don't want to waste time and resources duplicating messages by mistake.. This link has some info to fix. hope it helps someone who can add this fix.

http://www.phponwebsites.com/2014/03/Avoid-duplicate-values-storing-in-table-using-php-and-mysql.html

[antonraharja]

Can you give me step by step how to produce this bug ?

anton

[guyt101z]

It can be done using the sender page. Send identical message more than once to the same number scheduled for same time and it will add to the sender queue.I think should not allow this at least the scheduled sending time should be different.

[antonraharja]

ok, its a little more complex than that link describes, theres smslog_id and remote smslog_id involves.

anyway, its a good idea to do this, I'll see what I can do

[guyt101z]

I do not think the database method in that link will work to fix this issue it is a bit complex. My idea is to convert message and the destination number to a hash then use a check function to ensure it is not repeated. within a period of time. this may require another table in the database but i think this will be a quick easy fix.