Not sure what happened but I get this sql error:

"Invalid SQL: SELECT u.username, e.entryid, e.journalid, e.title, e.entry, e.timestamp, e.userid, e.private, e.displayorder, e.mood, e.music, e.comments
FROM journal_entry e
LEFT JOIN user u ON e.userid = u.userid
WHERE e.journalid = 1
ORDER BY e.timestamp DESC LIMIT 10
mysql error: Unknown column 'e.mood' in 'field list'"

Anyone have a suggestion on what I can do to correct this?

Okay, to fix this problem [and this has been corrected in the first post and the file setup] run these two queries:

Im still planing to do a version, waiting on vB 3 RC and some spare time.

Glad to see you got it figured out harleguin :)

I coded up a quick installer that will run the needed querys for you, just upload the attached file to the admin folder and run it. I was going to add template installer functionalty but I dont have the time to escape all the double quotes...

O yea, its not tested because I dont have a version 2 install right now.

Is there a chance we might get a list of modifications for those of us already running modified versions of vBJournal?

I've just updated all of the screenshots [noted in the first message] to make them considerably larger and very readable. You'll be able to see what's added by the new screenshots. Please take the time to look at them.


Thankies. ;)


Oh! And thankies Anime-loo! I've yet to test this installer -- anyone want to give it a whirl before I include it in the zip?

Thanks Harlequin for the added querys. That solved the mysql error.

One other question, when I go to the journal main page on my forum the colors/style are the default ones. However, when I click on "my journal" or "eileen's entry" the pages that come up do not show any styles.

All they show is a white background, a white box with "add entry" and the rest is just plain text.

Is this telling me that I have to work on the templates?

Looking forward to releasing this to my members and thank you

I think that's what it's telling you, and I'm a bit tired after working all day but I'll try to answer this as coherently as possible. :)


The only pages that I have changed are the actual journal "display" templates (the pages with the recent entries on them). Those templates are: journal_deftemp, journal_display, and journal_customtemp1 .. I believe. Every other part of the journal system has been untouched and should pretty well display the same.


But whenever you click your journal and nothing but the 'Add Entry' box pops up, that tells me a few things.


#1. Have you entered an entry in your journal and is it displaying okay on the page with the white background?

#2. Is the custom option selected in your journal config? If so, try linking to an image or typing some words or something in the 'Custom Header' box to see if it displays whenever you look at your journal.

#3. It's entirely possible I'm still leaving something out of the install, so don't fret.


If it is what I think it is and you've selected the 'Custom' option for your journal instead of the 'Alpha' template, then you'd be entirely correct. Your header and footer would just need a little tweaking and working to have it display however you like.

However, if you're selecting the 'Alpha' or 'Default' template and are only receiving what you're telling me, then something is badly wrong and I need to find out what it is immediately.


I can update the journal.php a bit, which I was planning on sooner or later anyway, to tell the user to (atleast) add a custom header.



Look forward to hearing your reply. :)


** EDIT ** : So I decided to fix the custom template white-out problem. I added an admin-set message telling the user that they need to add a header [if the header information does not exist].

I have one entry and on the display entry (the white page) the font is super super small.

Now when I click on "add entry" the forum default style/colors appear as it does on my main journal page.

I tested it using both 'Alpha' and 'default' and I get the same results. Also, after checking the 'Alpha' template, I go back to change template and it reverts back to 'default' (it seems the 'alpha' template is not saved)

DISREGARD above post.

I had a few minutes ago downloaded your updated file and after uploading the journal.php, it shows up now (although those red colors are such a contrast to my soft colors) :)

Thanks so much for helping me out with this and after I get the template style configured and start getting forum members participating, I'll update here