The report module (AOR_Reports) does not work properly any more. AFAIK, we did not upgrade or change anything on the server.
I can create new reports and access the report list (URL : YOUR_SERVER/?action=ajaxui#ajaxUILoc=index.php%3Fmodule%3DAOR_Reports%26action%3Dindex)
However, accessing any report (for example the following) produce the following error :
YOUR_SERVER/index.php?action=ajaxui#ajaxUILoc=index.php%3Fmodule%3DAOR_Reports%26offset%3D1%26stamp%3D1386623359077129900%26return_module%3DAOR_Reports%26action%3DDetailView%26record%3D3ed68426-e1ae-e877-5aa8-52a4bab54a16
Database failure. Please refer to sugarcrm.log for details.
-> Here is the log :
57838 Mon Dec 9 15:48:10 2013 [19157][1][INFO] Query:SELECT count() c FROM (SELECT opportunities.id AS ‘opportunities_id’, opportunities.date_entered AS ‘Date de création0’, opportunities.date_closed AS ‘Dat e de Clôture1’, opportunities.account_id AS ‘Compte2’, opportunities.name AS ‘Nom Affaire3’, opportunities.amount_usdollar AS ‘Montant (devise par défaut)4’, opportunities.assigned_user_id AS 'Assigné à 5 ’ FROM opportunities WHERE opportunities.sales_stage = ‘Closed Won’ AND opportunities.date_closed > DATE_ADD(opportunities.date_closed, INTERVAL - 1 month) AND opportunities.deleted = 0 ) as n
57839 Mon Dec 9 15:48:10 2013 [19157][1][INFO] Query Execution Time:0.00036287307739258
57840 Mon Dec 9 15:48:10 2013 [19157][1][FATAL] Error running count query for AOR_Report List: Query Failed: SELECT count() c FROM (SELECT opportunities.id AS ‘opportunities_id’, opportunities.date_entered AS ‘Date de création0’, opportunities.date_closed AS ‘Date de Clôture1’, opportunities.account_id AS ‘Compte2’, opportunities.name AS ‘Nom Affaire3’, opportunities.amount_usdollar AS ‘Montant (devise par défaut)4’, opportunities.assigned_user_id AS ‘Assigné à 5’ FROM opportunities WHERE opportunities.sales_stage = ‘Closed Won’ AND opportunities.date_closed > DATE_ADD(opportunities.date_closed, INTERVAL - 1 month) AND opportunities.deleted = 0 ) as n: MySQL error 1054: Unknown column ‘opportunities.account_id’ in ‘field list’
There is no MySQL column.
How to fix this and what can have cause this change of behaviour ?
Thanks by advance for any help/idea on how to fix this properly 
Ben