CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.1 Release Testing »
  • First Launch of Relationship Report causes error
Pages: [1]

Author Topic: First Launch of Relationship Report causes error  (Read 2914 times)

thesamim

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
First Launch of Relationship Report causes error
December 07, 2009, 04:39:34 pm
First time I try to invoke the relationship report, or if I haven't been using CiviCRM for a while ( > 15 minutes) I get an error message. If I immediately do it again, no error and I see every relationship in the system (5054 records, which doesn't seem excessive to me.) Perhaps the report should not launch before criteria are set? System information at bottom of post.

If this is not the correct way to post about an error, please point me in the right direction.

Procedure:
Click on "Reports"
Click on "Relationships Report"

Error:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">

<head>
  <title>Relationship Report</title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <base href="/administrator/components/com_civicrm/civicrm/" />
  <style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css);</style>
  <style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/extras.css);</style>
</head>

<body>

<div id="crm-container" lang="en" xml:lang="en">

<div class="messages status">
  <dl>
  <dt><img src="/administrator/components/com_civicrm/civicrm/i/Error.gif" alt="unrecoverable error" /></dt>
  <dd>
      Sorry. A non-recoverable error has occurred.      <p></p>
    <hr style="solid 1px" />
    <p>DB Error: unknown error</p>
      <p>Database Error Code: Server shutdown in progress, 1053</p>
      <p><a href="http://grace.hakunamatataweb.net/administrator/" title="Main Menu">Return to home page.</a></p>
  </dd>
  </dl>
</div>

</div>
</body>
</html><p>Error Details:</p><p><pre>Array
(
    [callback] =&gt; Array
        (
           
  • =&gt; CRM_Core_Error
    • [1] =&gt; handle
            )

       
Code: [Select]
=&gt; -1
    [message] =&gt; DB Error: unknown error
    [mode] =&gt; 16
    [debug_info] =&gt; SELECT SQL_CALC_FOUND_ROWS contact_civireport.display_name as civicrm_contact_display_name_a, contact_civireport.id as civicrm_contact_id, contact_b_civireport.display_name as civicrm_contact_b_display_name_b, contact_b_civireport.id as civicrm_contact_b_id, email_civireport.email as civicrm_email_email_a, relationship_type_civireport.label_a_b as civicrm_relationship_type_label_a_b 
        FROM civicrm_relationship relationship_civireport
 
             INNER JOIN civicrm_contact contact_civireport
                        ON ( relationship_civireport.contact_id_a =
                             contact_civireport.id )

             INNER JOIN civicrm_contact contact_b_civireport
                        ON ( relationship_civireport.contact_id_b =
                             contact_b_civireport.id )

             

             LEFT  JOIN civicrm_address address_civireport
                         ON (( address_civireport.contact_id =
                               contact_civireport.id  OR
                               address_civireport.contact_id =
                               contact_b_civireport.id ) AND
                             address_civireport.is_primary = 1 )

             LEFT  JOIN civicrm_relationship_type relationship_type_civireport
                        ON ( relationship_civireport.relationship_type_id  =
                             relationship_type_civireport.id  ) 
             LEFT JOIN civicrm_email email_civireport
                       ON ( contact_civireport.id =
                            email_civireport.contact_id AND
                            email_civireport.is_primary = 1 ) WHERE ( 1 )   GROUP BY relationship_civireport.id     LIMIT 0, 50 [nativecode=1053 ** Server shutdown in progress]
    [type] =&gt; DB_Error
    [user_info] =&gt; SELECT SQL_CALC_FOUND_ROWS contact_civireport.display_name as civicrm_contact_display_name_a, contact_civireport.id as civicrm_contact_id, contact_b_civireport.display_name as civicrm_contact_b_display_name_b, contact_b_civireport.id as civicrm_contact_b_id, email_civireport.email as civicrm_email_email_a, relationship_type_civireport.label_a_b as civicrm_relationship_type_label_a_b 
        FROM civicrm_relationship relationship_civireport
 
             INNER JOIN civicrm_contact contact_civireport
                        ON ( relationship_civireport.contact_id_a =
                             contact_civireport.id )

             INNER JOIN civicrm_contact contact_b_civireport
                        ON ( relationship_civireport.contact_id_b =
                             contact_b_civireport.id )

             

             LEFT  JOIN civicrm_address address_civireport
                         ON (( address_civireport.contact_id =
                               contact_civireport.id  OR
                               address_civireport.contact_id =
                               contact_b_civireport.id ) AND
                             address_civireport.is_primary = 1 )

             LEFT  JOIN civicrm_relationship_type relationship_type_civireport
                        ON ( relationship_civireport.relationship_type_id  =
                             relationship_type_civireport.id  ) 
             LEFT JOIN civicrm_email email_civireport
                       ON ( contact_civireport.id =
                            email_civireport.contact_id AND
                            email_civireport.is_primary = 1 ) WHERE ( 1 )   GROUP BY relationship_civireport.id     LIMIT 0, 50 [nativecode=1053 ** Server shutdown in progress]
    [to_string] =&gt; [db_error: message=&quot;DB Error: unknown error&quot; code=-1 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;SELECT SQL_CALC_FOUND_ROWS contact_civireport.display_name as civicrm_contact_display_name_a, contact_civireport.id as civicrm_contact_id, contact_b_civireport.display_name as civicrm_contact_b_display_name_b, contact_b_civireport.id as civicrm_contact_b_id, email_civireport.email as civicrm_email_email_a, relationship_type_civireport.label_a_b as civicrm_relationship_type_label_a_b 
        FROM civicrm_relationship relationship_civireport
 
             INNER JOIN civicrm_contact contact_civireport
                        ON ( relationship_civireport.contact_id_a =
                             contact_civireport.id )

             INNER JOIN civicrm_contact contact_b_civireport
                        ON ( relationship_civireport.contact_id_b =
                             contact_b_civireport.id )

             

             LEFT  JOIN civicrm_address address_civireport
                         ON (( address_civireport.contact_id =
                               contact_civireport.id  OR
                               address_civireport.contact_id =
                               contact_b_civireport.id ) AND
                             address_civireport.is_primary = 1 )

             LEFT  JOIN civicrm_relationship_type relationship_type_civireport
                        ON ( relationship_civireport.relationship_type_id  =
                             relationship_type_civireport.id  ) 
             LEFT JOIN civicrm_email email_civireport
                       ON ( contact_civireport.id =
                            email_civireport.contact_id AND
                            email_civireport.is_primary = 1 ) WHERE ( 1 )   GROUP BY relationship_civireport.id     LIMIT 0, 50 [nativecode=1053 ** Server shutdown in progress]&quot;]
)
</pre></p><p></p>[/tt]


[tt]PHP Built on:    Linux polo.websitewelcome.com 2.6.28.9 #41 SMP Fri Nov 27 22:14:58 CST 2009 i686
Database Version: 5.1.30
Database Collation: utf8_general_ci
PHP Version: 5.2.11
Web Server: Apache/2.2.14 (Unix) mod_ssl/2.2.14 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Web Server to PHP interface: cgi-fcgi
Joomla! Version: Joomla! 1.5.15 Stable [ Wojmamni Ama Mamni ] 05-November-2009 04:00 GMT
User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6 (.NET CLR 3.5.30729) [/tt]

[tt]Powered by CiviCRM 3.1.beta1. CiviCRM is openly available under the GNU Affero General Public License (GNU AGPL).[/tt]

Sunil

  • I post frequently
  • ***
  • Posts: 131
  • Karma: 23
  • The community around a product more important than the product itself?
    • CiviCRM
Re: First Launch of Relationship Report causes error
December 08, 2009, 11:11:11 pm
hi
Quote
Database Error Code: Server shutdown in progress, 1053
This error might be because of unoptimized SQL on large DATA
http://www.phpbb.com/community/viewtopic.php?f=1&t=1008865#p5874785

I have modified the Relationship.php file for Relationship Report
Take backup of your CRM/Report/Form/Contact/Relationship.php file, and override attached file.
Run the Report for various combination and report back to us with status.

Sunil
The community around a product more important than the product itself?

thesamim

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
Re: First Launch of Relationship Report causes error
December 12, 2009, 01:19:11 pm
Fixed! Thanks!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.1 Release Testing »
  • First Launch of Relationship Report causes error

This forum was archived on 2017-11-26.