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 Ageless)

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.

Change History (1)

comment:1 Changed 16 years ago by Ageless

Description: modified (diff)

Fixed formatting.

Note: See TracTickets for help on using tickets.