Opened 16 years ago
Last modified 16 years ago
#753 closed Defect
create_post() causes db error when non-existent user is subscribed to a thread. — at Initial Version
Reported by: | TJM | Owned by: | davea |
---|---|---|---|
Priority: | Minor | Milestone: | Undetermined |
Component: | Web - Forums | Version: | 6.3.14 |
Keywords: | Cc: |
Description
If user id exists in [b]subscriptionsb table but doesn't exist in [b]userb table (happened on my project after I've deleted spammers accounts) create_post() causes db erros, because it tries to execute query 'query: replace into enigma.notify set [b]userid=b, create_time=1223811818, type=4, opaque=2' which fails.
Solution: check if user exists before calling notify_subscriber(), if it doesn't then remove entry from subscriptions table.