An upgrade note -

The Journal homepage listing is intended to show only journals that have been updated in the past 30 days using this code
Since I had some older journals I brought in from vb2.2.6, I had only one journal showing up on this list, and it was one that was CREATED in the last week or so.

This heading should probably be changed to "Active Journals - last 30 days" and if it had a link to VIEW ALL JOURNALS, that would be good, too.

If you take out that code snippet above from the query, you'll get all the journals.

Regards,

Matt

A bug -

It looks like the errorjournalnotuser template included in the XML is messed up. Mine came through like this:

Consequently you won't get any message if you are not the owner of the journal or comment and click edit

Not that many? There are 38 journal templates in the XML!

It looks like maybe not all of them are used in Journal.php. But it also looks like a couple might be missing, too. These show up in journal.php but not in the XML file

error_no_journal',
error_journal_invalid

and this one is borked:

error_journal_not_user

The easiest way to get this working is to use the Style Manager's import utility. Select Download/Upload Styles,

1. Add a new style under one of your existing ones to copy its attributes. Name it Journal or something.

2. then under Import Style XML File browse to the XML file included in the attachment above
3. Merge into style - choose the style you duplicated
4. Ignore Style Version
5. Select allow user selection if you want it selectable (can change later)
6. Click Import

Now select that style and see if it works!

Regards,
Matt

Oops another bug

Or maybe non-included feature would be more accurate.

1. If you click discuss, it shows you a page with all the comments on it, not a page specific to the journal entry you clicked discuss on. I am not sure if the comment you enter will even be tracked in the database against the entry. Ryangel's old journal did not behave this way and the discussion thread was specific to a post.

2. Not a bug again, but a missing feature - there used to be a count of comments next to each journal entry so you could see if it was worth checking out.

Regards,

Matt

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views
FROM journal j
LEFT JOIN user u ON u.userid = j.userid
WHERE j.enabled = 1 AND j.entries > 0 AND j.timestamp >= 1093403293
ORDER BY username
mysql error: Table 'mysql_db.user' doesn't exist

mysql error number: 1146






thats my mysql error...

nvm i fixed it, you should try considering making an variable for the thing before the table name, like mines was _vb3_ as an preffix. took me few min to edit and add my prefixes.

Anybody have a link to show this up & running?

Never mind. ;)

I've installed it now on two different 3.0.3 sites with no problems. Installation of the templates was painless.

Will this work for version 3.0.7? There is another one on vb org but it looks like it may still have major bugs to work out and I am afraid to try and install it....me being a noobe at PHP and VB.....

I'm sorry but does this work with 3.07? Thanks