Geeklog Forums

I had a user who created a journal and now i want to erase it but if you go into the admin user name and try deleting it using the delete buttons it doesnt delete it. Is there any other way to delete unwanted journals. The person that wrote the journal deleted his/her username.

I'm having the same problem as well! Is there a fix or this or what?

go into mysql and delete it manually. find the jrn_id and je_jrn_id (they should be the same). Let's pretend my je_jrn_id is 26

then do: (this will show you which entries and journals you're about to delete
SELECT je_jrn_id, je_summary FROM gl_journal_entry WHERE je_jrn_id = 26;
SELECT * FROM gl_journal WHERE jrn_id = 26;

To delete it, pretty much the same thing
DELETE FROM gl_journal_entry WHERE je_jrn_id = 26;
DELETE FROM gl_journal WHERE jrn_id = 26;
Should work...

---

-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams