Delete HKLM or HKCR and you loose LOTS of data ;)

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

Did you import the product XML?

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

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

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

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

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