1
Hi everyone.
PHP: 4.3.10
MySQL: 4.1.7
Apache: 2.0.53
OS: W2K Server
I just installed XOOPS and I can't seem to get it going. Homepage is mostly empty, just the header and the menu entries Login and Main Menu, but these blocks don't have any content, and neither does the main area.
After checking all the FAQs about this, I enabled the MySQL query log, and tested the queries one by one, until I got to the following query (this is a test install with all default names, don't worry about my putting the real table names here):
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_login.html') ORDER BY tpl_refidThis query doesn't return any data, and so the block template is not loaded.
I checked the tables and checked the install scripts, and they are properly loaded, i.e., the xoops_tplsource has the source for the login block and proper IDs.
After a bit more checking, I came to the conclusion that it fails on the condition
tpl_tplset = 'default'If I run the query in PHPMyAdmin with
tpl_tplset LIKE 'default'it returns the proper result.
I have the database in MyISAM and UTF-8, and I've tried changing the collation of the table to Latin1, but to no avail.
I'm stumped. ???? HELP!