Results 1 to 2 of 2

Thread: Database error CE6.2

  1. #1
    glynd is offline Sugar Community Member
    Join Date
    Jul 2009
    Posts
    51

    Default Database error CE6.2

    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

  2. #2
    glynd is offline Sugar Community Member
    Join Date
    Jul 2009
    Posts
    51

    Default Re: Database error CE6.2 - fixed

    Just to let you know that it now works but I have not that sure how I fixed it.
    I ran repaired and flushed some of the the tables and then restart apache and mysql I also ran check in the upgrade wizard and again, reset the permissions in /var/www/sugarcrm (to 777) and now it all works again.
    Sorry to be more specific but one of these actions fixed it.

    Cheers
    Glyn

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database error - Diff - database & vardefs
    By cmacholz in forum Developer Help
    Replies: 35
    Last Post: 2011-09-21, 09:32 AM
  2. Database Error
    By evp in forum Help
    Replies: 3
    Last Post: 2009-11-11, 10:21 AM
  3. Error Installing 5.2 on 1and1 Managed Hosting Database error
    By nyichiban in forum Installation and Upgrade Help
    Replies: 3
    Last Post: 2009-03-04, 04:31 PM
  4. Database error
    By rlugo in forum Help
    Replies: 7
    Last Post: 2007-10-12, 04:11 PM
  5. Replies: 1
    Last Post: 2006-06-27, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •