Posted on: 09/13/04 10:39pm
By: UL
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.
How Do You Delete A Journal
Posted on: 10/10/04 06:52am
By: Anonymous (cosmicinsight)
I'm having the same problem as well! Is there a fix or this or what?
How Do You Delete A Journal
Posted on: 10/10/04 10:53am
By: destr0yr
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...