Moving Joomla 1.8 problem

[loicb]

Hye fellows.

I'm trying to move a Joomla 1.8 site to another server, and since no content is displayed (the menu and template are good), I've actived debug in configuration.php.
The result is a mismatch in mysql queries between my two installations.

For example:

Old server mysql trace extract:

Code: Select all

14
INSERT INTO jos_jstats_page_request (page_id, hour, day, month, year, ip_id) values (64, HOUR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), 35411)15
SELECT *
 FROM jos_menu
 WHERE id = 5016
SELECT COUNT(a.id)
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-06-28 14:42' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-06-28 14:42' )
 AND a.catid IN ( 22 ) 
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0

New server mysql trace extract:

Code: Select all

13
INSERT INTO jos_jstats_page_request (page_id, hour, day, month, year, ip_id) values (64, HOUR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), 35392)14
SELECT *
 FROM jos_menu
 WHERE id = 5015
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'16
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = '50' )
 ORDER BY ordering

Old server running php5.2, new server running php5.3.
I really don't know Joomla so I don't know where to look, any help appreciated.

Thanks.