DB Error after upgrade

[bloc]

What kind of error do you see?

[shane is my name]

Hey Bloc.
if you are talking to me, I see the following 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 'IFNULL(mem.real_name,art.author) as real_name FROM smf_tp_articles AS art
LEFT' at line 2
File: /home/nyxtre2/public_html/hiphopforums/Sources/TPortal.php
Line: 1847

I get that error when trying to view the HOME page, when I have html / javascript blocks activated...   

http://www.tinyportal.net/index.php?topic=32345.new;topicseen#new

but If I turn them off, the error goes away, and my HOME page works again.

[bloc]

That error suggests theres a problem with showing an article in a block..are there just HTML blocks on frontpage or do you have other types too?

[shane is my name]

hmm you're right. yes I had various types of blocks on.
I didnt trouble shoot enough, I had just turned off all blocks, and saw my HOME page worked again, so I knew it had something to do with blocks.. I then jumped the gun and thought it was the html/javascript blocks since those blocks were giving me trouble (I couldnt make changes on some blocks... even if i didnt make a change, but just pressed SAVE, it still gave me the below error on SAVE:   

at line 1File: /public_html/hiphopforums/Sources/TPortalAdmin.php
Line: 2362

So I just assumed it was them that were causing the issue..  Im sorry ALL! 
Now I can't even re-create the Home page error... I keep adding articles, and changing frontpaget settings, but no combination is re-creating it.. 

[GhostRider2110]

Hmmm Not much better luck with the 1B5.1...  didn't get DB error, but some other things...  Lost the front page, it switched to showing the forums and the version ref on the screen never updated.  Will have to play around and see where I messed it up.  Thanks --Mitch