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.

[Chadi]

Upgraded to 3.6.1 and now I get this when I click the link in user control panel..

Database error in vBulletin 3.6.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.entrydate, 
               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_id)
            LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood) 
            WHERE journal_entries.journal_id=72 
                    AND entry_active='1'      
                     
               GROUP BY journal_entries.entry_id
            ORDER BY entrydate DESC 
            LIMIT 0,;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 14 Error Number : 1064

Also, in the instructions it says this:

In Template modifylist
FIND
----------------------------------------------------------------------------------------------------------------------------------
<form action="profile.php" method="post">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="updatelist" />
<input type="hidden" name="userlist" value="ignore" />
<fieldset class="fieldset">
<legend>$vbphrase[ignore_list]</legend>
<div style="padding:$stylevar[formspacer]px">
$ignore_listbits
<div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
<div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
</div>
<div align="center"><input type="submit" class="button" value="$vbphrase[update_ignore_list]" accesskey="s" /></div>
</fieldset>
</form>
</td>
</tr>
----------------------------------------------------------------------------------------------------------------------------------


I cannot find this ...see attached template

[abrecher]

I also upgraded to the latest version. Users get the following when they visit the journal page:

Database error in vBulletin 3.6.1:

Invalid SQL:

### Journal Listing ###
SELECT
journals.lastentry_uids, journals.journal_id, journals.journalname, journals.journaldesc,
journals.journalist, journals.journalist_id, entrycount, commentcount, usertextfield.jbuddylist, ipaddress, journals.lastentry,
journals.lastentry_date, journals.private, journals.whocanview, journals.lastentry_id, journals.status, journals.allowbuddies, journals.journalviews,
journals.journal_totalrating AS totalrating, journals.journal_totalvotes AS totalvotes
FROM journals AS journals
LEFT JOIN usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
WHERE journals.active=1
AND (journals.journalist_id=1 OR journals.private != 1 OR FIND_IN_SET('1', journals.allowedusers))
ORDER BY lastentry_date DESC
LIMIT 0,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 12
Error Number : 1064
Date : Friday, September 15th 2006 @ 06:22:43 PM
Script : http://www.XXXXX.com/journal.php
Referrer :
IP Address : XXXXX
Username : XXXXX
Classname : XXXXX


HELP!!! ;-)

[Renmiri]

Originally Posted by kelekian

I can create more then 1 journal for one single user?!

regards,

Kelekian

I solved that with a new user name and the "Quick account switch" hack

[Lionel]

What seems to be the problem with 3.60? What should I be looking for?
I installed and everything seems to be working....

[thumbsucker]

Same DB errors the others are getting with the 3.6.1 upgrade.

:cross-eyed:

[thumbsucker]

Man someone help fix this please!

[abrecher]

Originally Posted by abrecher

I also upgraded to the latest version. Users get the following when they visit the journal page:

Database error in vBulletin 3.6.1:

Invalid SQL:

### Journal Listing ###
SELECT
journals.lastentry_uids, journals.journal_id, journals.journalname, journals.journaldesc,
journals.journalist, journals.journalist_id, entrycount, commentcount, usertextfield.jbuddylist, ipaddress, journals.lastentry,
journals.lastentry_date, journals.private, journals.whocanview, journals.lastentry_id, journals.status, journals.allowbuddies, journals.journalviews,
journals.journal_totalrating AS totalrating, journals.journal_totalvotes AS totalvotes
FROM journals AS journals
LEFT JOIN usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
WHERE journals.active=1
AND (journals.journalist_id=1 OR journals.private != 1 OR FIND_IN_SET('1', journals.allowedusers))
ORDER BY lastentry_date DESC
LIMIT 0,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 12
Error Number : 1064
Date : Friday, September 15th 2006 @ 06:22:43 PM
Script : http://www.XX.X.com/journal.php
Referrer :
IP Address : XXXXX
Username : XXXXX
Classname : XXXXX


HELP!!! ;-)

Please please someone help me!!

[Adrian Schneider]

Originally Posted by abrecher

Please please someone help me!!

Just a side note - that's a porn site LOL.

[abrecher]

Originally Posted by SirAdrian

Just a side note - that's a porn site LOL.

LOL, I changed the URL...thanks.

Can you help me ??

[Adrian Schneider]

I would personally search for every occurance of "$start,$perpage" and replace $perpage with the number you want. I'm not sure how the settings work - and that would bypass the (not working) settings and use the value you enter.

Once a valid fix is released you can just download a fresh copy of the file.