[TYPO3-english] No template found after conversion to UTF8...

Dmitry Dulepov dmitry at typo3.org
Thu Feb 19 15:56:55 CET 2009


Hi!

Andrew Plank wrote:
> 1. Duplicate the filesystem of the site to be cloned to the new server.
> 2. Using phpMyAdmin, export the database. Convert the sql script to UTF8
> from iso-8859-1 using iconv.

Well... Same wrong way, even after I told you where to search for the right way...

> $TYPO3_CONF_VARS['SYS']['setDBinit'] = "SET NAMES utf8;\nSET CHARACTER
> SET utf8;\nSET SESSION character_set_server=utf8;";   
> 
> Notice the extra "SET CHARACTER SET utf8" statement.

I noticed. This particular statement corrupted many tables already.

> HOWEVER... If you try to map a TV template with that extra setDBinit
> statement added in step 9, it won't save it. But if it's not there,
> you'll get the dreaded "No template found!" error in the FE!

Thanks to the statement above, which messes up character sets. You are not the first one who is hit with it.

> So this is a solution if you don't mind altering localconf.php before
> and after each and every mapping change in TV.
> 
> Dmitry... Can you think of a reason why this should be the case? Is it
> by design? Or just incidental to the way in which the T3 DB mechanism
> works, or is it a bug? It would be great to get your input. If it is
> possible to create a workaround for this - perhaps as a bugfix in the
> next TV?

Everything works correctly if you do it correctly. Please, do what I told you in the previous post. It takes several keystrokes in a browser search bar to find the right solution in our bug tracker. I really do not understand why you went with iconv again after you were told it is a wrong way :(

You go the wrong way, it does not work and you think it is a bug... :(

This post is not to offend you or anything like that. It is just disappointing to me when people consciously and deliberately make the same mistake twice.

-- 
Dmitry Dulepov
TYPO3 core team
"Sometimes they go bad. No one knows why" (Cameron, TSCC, "Dungeons&Dragons")


More information about the TYPO3-english mailing list