actually i got a problem with installing the backup, i got the backup of my database but as you people know it wouldnt be connected unless we install it just the way it must be. So i installed a fresh copy of SMF 2.0.4 and then changed the database info inside my backup database and then put them all together, seemingly they does work except one thing. When i click the home page this is what it shows.
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'ifnull'
Except the home page everything is working.
How do i fix the above error as it is been a headache for me since two days.