| strange problem for mysql |
| by franfran on 2005/1/4 9:35:31 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 |