Running on Ubuntu Mysql 5.07, php 5
This seems not directly associated with the upgrade from 6.15.
When searching for an account, I get the basic Account detail but no contacts, etc are shown. At the bottom of the page there is this error:
database failure. Please refer to sugarcrm.log for details.
Looking at the sugarcrm.log this is what I find but I am no closer to fixing the problem.
Tue Jun 14 08:10:02 2011 [27603][1][DEBUG] SugarBean.load_relationships, Loading relationship (modified_user_link).
Tue Jun 14 08:10:02 2011 [27603][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (modified_user_link).
Tue Jun 14 08:10:02 2011 [27603][1][DEBUG] process_full_list_query: query is SELECT schedulers.* , TRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,''))) created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod FROM schedulers LEFT JOIN users jt0 ON
jt0.id= schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 where (schedulers.status='Active') AND schedulers.deleted=0
Tue Jun 14 08:10:02 2011 [27603][1][INFO] Query: SELECT schedulers.* , TRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,''))) created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod FROM schedulers LEFT JOIN users jt0 ON
jt0.id= schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 where (schedulers.status='Active') AND schedulers.deleted=0
Tue Jun 14 08:10:02 2011 [27603][1][INFO] Query Execution Time:0.000432014465332
Tue Jun 14 08:10:02 2011 [27603][1][DEBUG] process_full_list_query: result is mysqli_result Object
I ran repair but no solution found here.
Can anyone suggest a solution?
TIA
Glyn


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks