Hi,

I am trying to upgrade my MySQL to 4.1.7. The upgrade is smooth without a problem, I can see the new database having identical data with the old one, however, all blocks in XOOPS site are blank now(I can see the block title show, but no content).

I tried to debug the program and I found that the code use the following to assign content to the template:

$xoopsTpl->assign('somevar', $somecontent);


I then tried to dig deeper into the class/smarty/Smarty.class.php file. I find out that the $value passed to the function 'assign' is blank. I mean after the variable passed, the $value become blank inside the assign function.

I then try to do:
var_dump($somecontent);
before or after the xoopsTpl->assign code, it shows everything without problem. I am sure that the code can draw the data from database(all data is in $somecontent array). The problem occur only when using the xoopsTpl->assign function, the $value would become blank when passed to assign function.

I then switch back to my old DB, everything back to normal.

I wonder why? Since passing variable in PHP shouldn't have anything related to database version...
Any clue in here? Following is my config, thanks!

PHP 4.3.10
XOOPS 2.0.6

Before:
MYSQL 4.1.0, UTF8 as charaset

After:
MYSQL 4.1.7, UTF8 as charaset


P.S. I tried to empty the template_c folder, no luck