Welcome to Geeklog Tuesday, September 22 2020 @ 04:49 am EDT

Geeklog Forums

How Do You Delete A Journal


Status: offline

UL

Forum User
Junior
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.
 Quote

cosmicinsight

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

Status: offline

destr0yr

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

All times are EDT. The time is now 04:49 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