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.0 Release Testing »
  • Query in MySQL not ever ending
Pages: [1]

Author Topic: Query in MySQL not ever ending  (Read 8202 times)

jase700

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 3
Query in MySQL not ever ending
September 24, 2009, 03:26:25 pm
SELECT COUNT( DISTINCT (
civicrm_activity.id
) ) AS count
FROM civicrm_activity
LEFT

This process is showing up multiple times in mysql and seems to be running forever without being able to stop.  It says the status is "Sending Data".

This occurs every time I try and click on the menu item for CiviCRM in Joomla (components menu)
« Last Edit: September 24, 2009, 03:30:34 pm by jase700 »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Query in MySQL not ever ending
September 29, 2009, 03:00:23 pm
Can you give more details how to replicate this behavior?

If possible can try to replicate this on http://sandbox.civicrm.org

thanks,
Kurund
Found this reply helpful? Support CiviCRM

jase700

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 3
Re: Query in MySQL not ever ending
October 01, 2009, 05:54:39 am
Thing is I'm not really sure how to replicate it.  All that happens is that I click on the menu option in Joomla for CiviCRM and it never comes up.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Query in MySQL not ever ending
October 01, 2009, 09:23:20 am
Are you sure your CiviCRM install was successful? Try logout / login and clear your browser cache. If that does not work, may be try reinstalling..


Hth

Kurund
« Last Edit: October 01, 2009, 09:25:45 am by Kurund Jalmi »
Found this reply helpful? Support CiviCRM

jase700

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 3
Re: Query in MySQL not ever ending
October 01, 2009, 05:14:21 pm
This issue appears when I try and click on the civicrm menu item in the components menu in joomla. 

This menu item link just won't go anywhere.  option=com_civicrm

i've reinstalled several times and each time at the end it just refuses to rebuild the menus..

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Query in MySQL not ever ending
October 01, 2009, 05:59:26 pm
You should check with your server person regarding MySQL error.

Kurund
Found this reply helpful? Support CiviCRM
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.0 Release Testing »
  • Query in MySQL not ever ending

This forum was archived on 2017-11-26.