Topic: How to solving 500 Internal Server Error

[polkomzone]

Dear Developer,
I want to consult about SMF that I use.

When the installation Simple Portal forums but still can not log in after log out and log back in inaccessible.

Then comes a description 500 Internal Server Error

Also I can not access the menu options and features available in SMF

Please check our forum address

http://forum.polkomzone.org

Please give enlightenment and how to deal with this problem

Best Regard,
POLKOMZONE

[Nathaniel]

Moved to a support board.

Any errors in your Server error log that might be more descriptive? 500 is a generic server error, it doesn't really tell us anything about what went wrong.

[polkomzone]

Error found

Database Salah: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/username/public_html/forum/Sources/Subs-Portal.php
Baris: 1293

I Was upgrade from version 1.1.10

[Nathaniel]

This is a bug with the install that will be fixed with the next version of SimplePortal.

In the meantime, changing the collation of the text columns for your 'sp_' tables to the collation that your main SMF tables have (look at the username column of your sp_members table for an example). You can do this with a tool such as PhpMyAdmin.