[Typo3-dev] lost templavoila mapping after utf 'fix'

[Sean Ellis]

Sean Ellis wrote:

Hello,

I'm putting this problem aside for the moment. I've tried all the 
configuration possibilities that I can think of, and my understanding of 
the typo3 inner workings isn't up to me tinkering with the source just 
yet from what I see.

I wanted to add a couple more observations though, for the record, 
posterity etc .

1. The particular error that this problem produces is:

TemplaVoila ERROR:

Template Object could not be unserialized successfully.
Are you sure you saved mapping information into Template Object with UID 
"1"?

2. Starting with an entirely fresh site, fresh templavoila install, 
using a database set with  CHARACTER SET utf8 COLLATE utf8_general_ci, 
localconf settings of:

$TYPO3_CONF_VARS["SYS"]["multiplyDBfieldSize"] = '3';   //  Modified or 
inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS["BE"]["forceCharset"] = 'utf-8';   //  Modified or 
inserted by TYPO3 Install Tool.

and the 'fix' mentioned below (needed to enter Japanese characters)

With these settings the new site is fine until I enter any Japanese 
characters. In this case I added a string to the title field in the page 
header of a sample page I'd made. Then, error.

rgds

> 
> I'm unable to keep mapping with templavoila when I apply a fix to utf-8 
> handling. The utf workaround consists of a few lines added to 
> /t3lib/class.t3lib_db.php (line ~827).
> 
>          if ($TYPO3_CONF_VARS["BE"]["forceCharset"]=='utf-8') {
>             mysql_query("SET NAMES utf8",$this->link);
>             mysql_query("SET CHARACTER_SET utf8",$this->link);
>         }
> 
> I've tried a few things to clear this up, with no luck so far. Can 
> anyone more knowledgable provide a clue about templavoila's relationship 
> to the database that might cause these results?
> 
> Remapping, or creating new templavoila template object and data 
> structures hasn't helped.
> 
> Some more details here:
> 
>  http://bugs.typo3.org/view.php?id=1262
> 
> One thing that I've not tried yet is re-installing the extension after 
> introducing the modified class.t3lib_db.php.
> 
> Another non-templavoila site doesn't seem to show any problems with the 
> edit above. I say _seem_ because both sites are in development, and not 
> receiving the closest scrutiny,
> 
> ta,
> 
> Sean