1
I get some warnings like these after I installed a XOOPS 2.2.6 on an older PHP 4.3.9 and MySQL 4.1.20 box.
Result is that the content of the site and blocks are empty. The theme is showed and admin parts which don't use Smarty are working.
I traced the cause of this error to the query for the template, which doesn't find the records.
le="color: #000000"><?php SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
In phpMyAdmin are no result records returned and no syntax errors are flagged.
When only one part is used of the where clause as in
le="color: #000000"><?php SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' ) ORDER BY tpl_refid
le="color: #000000"><?php SELECT * FROM xoops_tplfile WHERE (tpl_file = 'system_block_user.html') ORDER BY tpl_refid
There are 2 and 39 records in the results, with the targeted record in both sets.
Strange is that without the order clause the record is found:
le="color: #000000"><?php SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html')
Someone has a clue for this phenomena?
