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.

Change History (0)

Note: See TracTickets for help on using tickets.