Upgraded to 3.6.1 and now I get this when I click the link in user control panel..
Code:
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