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.

[Snake]

What are you talking about? This works just fine on 3.6.x.

[grundybin]

It is not recommended to use mySQL 4.1+
kurs HTML
They are probably all using MySQL 5

[soletrader]

This hack works great for 3.6.0 but with just one problem.

I no longer see the attachment function on the reply box. Is this supposed to happen?

[agiacosa]

So, is this working with 3.6.1?

[Chadi]

Originally Posted by agiacosa

So, is this working with 3.6.1?

No, not for me nor many others.

Apparently we're not getting an update/fix from the coder.

[voteforbird]

It's working on 3.6.1 for me! Question: how can I change it so that in Who's Online it displays everyone on the forums as well, and not just the blogs?

[voteforbird]

Also, when I uncomment the report button, it goes to a blank page. Is there a fix for this?

[Chadi]

Originally Posted by 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

Please help on this. I've been w/o the journal for 5 days now. Its critical on my site. I really would appreciate some help.

[:Judge:]

I am also getting an error now after the 3.6.1 upgrade?

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         : Wednesday, September 20th 2006 @ 01:14:39 AM
Script       : http://www.cecilcountyx.com/forums/journal.php
Referrer     : http://www.cecilcountyx.com/
IP Address   : 
Username     :
Classname    : vb_database

[DS MrSinister]

Template modifylist edit what I use For 3.6.1 seems to work so far

Find

<tr valign="top">
						<td id="ignorelist1">$ignorelistbits1</td>
						<td id="ignorelist2">$ignorelistbits2</td>
					</tr>
					   <tr>
   <td>

Add Below

   <tr>
   <td>
   <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="jbuddy" />					
   <fieldset class="fieldset">
   	<legend>$vbphrase[journal_buddy_list]</legend>
	<div style="padding:$stylevar[formspacer]px">
		$jbuddy_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_journal_buddies]" accesskey="s" /></div>
   </fieldset>					
   </form>				
   </td>
   </tr>

Also download the file find here for 3.6+

https://vborg.vbsupport.ru/showpost....postcount=1323