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 Version 1
Reported by: | TJM | Owned by: | davea |
---|---|---|---|
Priority: | Minor | Milestone: | Undetermined |
Component: | Web - Forums | Version: | 6.3.14 |
Keywords: | Cc: |
Description (last modified by )
If user id exists in subscriptions table but doesn't exist in user 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 userid=, 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.
Fixed formatting.