search

voroojax / waf-fle

Automatically exported from code.google.com/p/waf-fle
0 stars 0 forks source link

Deleted events remains in database #14

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Open Events
2. Mark checkbox of event to delete
3. Click delete

What is the expected output? What do you see instead?
Event is deleted from event table, but in table events_full_sections event 
remains.

What version of the product are you using? On what operating system?
0.6.0 rc2, RHEL5

Please provide any additional information below.
Debug is in attached file

Original issue reported on code.google.com by juraj.sa...@gmail.com on 25 Jan 2013 at 11:50

Attachments:

GoogleCodeExporter commented 9 years ago 
Fix: 
In file functions.php edit SQL statement in function deleteEvent. I think 
correct SQL is:
DELETE events, events_messages, events_messages_tag, events_full_sections  FROM 
events LEFT JOIN events_messages ON events.event_id = events_messages.event_id 
LEFT JOIN events_messages_tag ON events
_messages.msg_id = events_messages_tag.msg_id LEFT JOIN events_full_sections ON 
events.event_id  = events_full_sections.event_id WHERE 1 AND events.preserve = 
0 AND events.event_id = :event_id'

Original comment by juraj.sa...@gmail.com on 25 Jan 2013 at 1:18

GoogleCodeExporter commented 9 years ago 
The ' at the end is mistake :-) Sorry

Original comment by juraj.sa...@gmail.com on 25 Jan 2013 at 1:21

GoogleCodeExporter commented 9 years ago

Original comment by klaub...@gmail.com on 5 Feb 2013 at 9:24

GoogleCodeExporter commented 9 years ago 
I have confirmed the problem, thanks for open this issue.

It'll be fixed on next release.

Original comment by klaub...@gmail.com on 5 Feb 2013 at 9:40

GoogleCodeExporter commented 9 years ago 
Fixed.

Thanks,

Original comment by klaub...@gmail.com on 26 Feb 2013 at 12:03