SMF Support > Install and Upgrade Help

Database

(1/4) > >>

Victorinyang1:
when i want to post  on my shout box, it tells me
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/u369350200/public_html/Sources/Subs-Portal.php
Line: 1251
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.2, while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php

how can i stop this?

ziycon:
How did you upgrade from 2.0.1 to 2.0.2, was it through the SMf admin interface or by uploading the files to your server?

Victorinyang1:
Through smf admin interface.

ziycon:
It basically means that there is a check being run on your database and one of the values being used has an encoding of utf8_unicode_ci and the other value has an encoding of utf8_general_ci which is why your getting the error. You'll need to have a look at your database and see what the default encoding is for the overall database and update any incorrect encoding settings on any table columns.

Victorinyang1:
Where can i look for it

Navigation

[0] Message Index

[#] Next page