[hydrostatic]

Originally Posted by KirbyDE

It should, unless you uninstall it.
To be 100% safe, I'd suggest to backup your journals, journal_entries, journal_comments, journal_moods and journal_settings tables first.

When trying to edit moods, there comes an SQL error.

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
DELETE FROM journal_moods WHERE mood_id=1;

MySQL Error  : Table 'blootix_forums.journal_moods' doesn't exist
Error Number : 1146
Date         : Sunday, September 18th 2005 @ 02:45:26 AM
Script       : http://www.blootix.com/forums/admincp/journaladmin.php?do=killmood&mid=1
Referrer     : http://www.blootix.com/forums/admincp/journaladmin.php?do=moderatemoods
IP Address   : ***********
Username     : Blootix
Classname    : vb_database

I think you mistyped something about a TABLE PREFIX. I'll try to find it.

EDIT: Found it. You forgot to do that .TABLE PREFIX. thing with this code:

PHP Code:

$mid = $vbulletin->input->clean_gpc('r', 'mid', TYPE_INT);
        $db->query("DELETE FROM journal_moods WHERE mood_id=".$mid."");
        define('CP_REDIRECT', 'journaladmin.php?do=moderatemoods');
        print_stop_message('journal_mood_deleted_successfully'); 


it should be:

PHP Code:

$mid = $vbulletin->input->clean_gpc('r', 'mid', TYPE_INT);
        $db->query("DELETE FROM ".TABLE_PREFIX."journal_moods WHERE mood_id=".$mid."");
         define('CP_REDIRECT', 'journaladmin.php?do=moderatemoods');
         print_stop_message('journal_mood_deleted_successfully'); 


Am I right?