Opened 16 years ago

Closed 16 years ago

#753 closed Defect (fixed)

create_post() causes db error when non-existent user is subscribed to a thread.

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 (2)

comment:1 Changed 16 years ago by Ageless

Description: modified (diff)

Fixed formatting.

comment:2 Changed 16 years ago by davea

Resolution: → fixed
Status: new → closed

(In [16191]) - web: avoid error if subscribed user doesn't exist

fixed #753

Note: See TracTickets for help on using tickets.