TinyPortal

For those who are experiencing problems after installing TP (0.95b) on a working UTF-8 SMF (1.1RC3) installation, this SQL query (in an phpmyadmin window) will solve your problems.

ALTER TABLE smf_tp_articles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_blocks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_dlmanager CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_settings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_variables CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

You'll have to manually edit the block names or other TP content by hand afterwards.

You'll need to save your language files in UTF-8 and rename them to TP***yourlanguage-utf8.php and upload them to Themes/default/languages directory as well.


If you already have BIG problems with SMF1.1RC3 UTF-8, pay attention that you SAVE the sqldump with a text editor that can export in UTF-8 format (good old Windows Notepad does that).

thanks brother. works and with TinyPortal v0.9.6beta

Thanks, thought it might help someone. Cost me days and nights to successfully move my existing installation to server with a never MySQL version.