vBJournal for vBulletin 3.5

This is a Port of vB Journal by An-Net

A t t e n t i o n
This Hack is unsupported and incompatible with PHP 5.
You are herby advised to not use it.
If you do have this hack installed it is advised to use vBulletin Blog instead.
You can import current entries to vBulletin Blog via Impex and uninstall this hack afterwards.

[Andreas]

Delete HKLM or HKCR and you loose LOTS of data

[dethfire]

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT journal_entries.entry_id, journal_entries.entrytitle,
journal_entries.entrytext, journal_entries.mood, journal_entries.np, journal_entries.allowbuddies,journal_entries.entry date,
journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image , journal_entries.entry_totalrating,
journal_entries.private, journal_entries.whocanview,
COUNT(journal_comments.comment_text) AS comments
FROM journal_entries AS journal_entries
LEFT JOIN journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_i d)
LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
WHERE journal_entries.journal_id=2
AND entry_active='1'
AND (journal_entries.private != 1 OR FIND_IN_SET('1', journal_entries.allowedusers))
GROUP BY journal_entries.entry_id
ORDER BY entrydate DESC
LIMIT 0,10;

MySQL Error : Unknown column 'journal_entries.np' in 'field list'
Error Number : 1054
Date : Tuesday, November 22nd 2005 @ 02:17:07 PM
Script : http://www.physicsforums.com/journal...howjournal&j=2
Referrer : http://www.physicsforums.com/journal.php
Classname : vb_database

[Andreas]

Did you import the product XML?

[dethfire]

Originally Posted by Andreas

Did you import the product XML?

yeah twice, overwriting the original, the product info screen says it's at beta 1

[Andreas]

Change the version number to "1.0.2 Alpha 3" and import again.
If it still does not work, send me a PM with an ACP login.

[dethfire]

Originally Posted by Andreas

Change the version number to "1.0.2 Alpha 3" and import again.
If it still does not work, send me a PM with an ACP login.

ok that worked, I understand why now, thanks

[Reeve of shinra]

I saw that "# It is not recommended to use mySQL 4.1+" -- is that still true?

I am running 4.1.1 and would like to use this on a new site running 3.5

[dethfire]

Originally Posted by Reeve of shinra

I saw that "# It is not recommended to use mySQL 4.1+" -- is that still true?

I am running 4.1.1 and would like to use this on a new site running 3.5

I'm running 4.0.16 and it works just fine

[Reeve of shinra]

yeah but he is saying NOT to use anything above 4.1 which I am

[Andreas]

Try it. If you get mySQL errors about conflicting collations it does not work, otherwise it does