Welcome to Geeklog, Anonymous Friday, July 19 2024 @ 02:35 am EDT

Geeklog Forums

How Do You Delete A Journal

Status: offline


Forum User
Registered: 09/09/04
Posts: 22
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?

Status: offline


Forum User
Full Member
Registered: 07/06/02
Posts: 324
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

All times are EDT. The time is now 02:35 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content