Author Topic: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6 (Read 2422 times)

flug · August 30, 2012, 07:09:32 pm

Today I followed this procedure:

* Search event participants
* Find all test participants
* "All 26 records" - delete participants - go
* Delete this participant record along with associated participant record(s) - Delete Participants

Result is the following error and no participants deleted.

Any thoughts on what might cause this or troubleshooting?

I tried just selecting one or two or several of the 26 records - same error was received. I tried turning on backtrace but it shows nothing different (I'm guessing Error.php dies before getting to the point of displaying the backtrace).

I tried deleted a real (non-test) participant via the same procedure and it worked fine.

I tried a similar procedure on the CiviCRM 4.2 Drupal 6 demo and it worked fine with no error.

Here is the error:

Quote

Fatal error: Uncaught <table border="1" cellspacing="0"> <tr><td colspan="3" bgcolor="#ff9999"> PEAR_Exception: DB Error: syntax error in unknown on line unknown</td></tr> <tr><td colspan="3" bgcolor="#ff9999">- DB_Error: DB Error: syntax error in unknown on line unknown</td></tr> <tr><td colspan="3" bgcolor="#aaaaaa" align="center">Exception trace</td></tr> <tr><td align="center" bgcolor="#cccccc" width="20">#</td><td align="center" bgcolor="#cccccc">Function</td><td align="center" bgcolor="#cccccc">Location</td></tr> <tr><td align="center">0</td><td>CRM_Core_Error::exceptionHandler(Object(DB_Error))</td><td>unknown:unknown</td></tr> <tr><td align="center">1</td><td>call_user_func(Array, Object(DB_Error))</td><td>/home/OUR/WEB/SITE/DIRECTORY/sites/all/modules/civicrm/packages/PEAR.php:931</td></tr> <tr><td align="center">2</td><td>PEAR_Error->PEAR_Error('DB Error: syntax…', -2, 16, Array, 'SELECT id, item_…')</td><td>/home/mobikefed/www/www/si in/home/OUR/WEB/SITE/DIRECTORY/sites/all/modules/civicrm/CRM/Core/Error.php on line 568

flug · August 30, 2012, 11:36:47 pm

Got these similar errors later on:

Merging two records:

Quote

Fatal error: Uncaught exception 'Exception' with message 'A fatal error was triggered' in /OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Core/Error.php:262
Stack trace:
#0 /OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Contact/Form/Merge.php(185): CRM_Core_Error::fatal('The main contac...')
#1 /OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Core/Form.php(338): CRM_Contact_Form_Merge->preProcess()
#2 /OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Core/StateMachine.php(135): CRM_Core_Form->buildForm()
#3 /OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contact_Form_Merge), 'next', 'Next')
#4 /OUR/WEB/SITE/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Form_Merge), 'next')
#5 /OUR/WEB/SITE/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Merge in /OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Core/Error.php on line 262

Merging two records:

Quote

Fatal error: Uncaught <table border="1" cellspacing="0"> <tr><td colspan="3" bgcolor="#ff9999"> PEAR_Exception: DB Error: syntax error in unknown on line unknown</td></tr> <tr><td colspan="3" bgcolor="#ff9999">- DB_Error: DB Error: syntax error in unknown on line unknown</td></tr> <tr><td colspan="3" bgcolor="#aaaaaa" align="center">Exception trace</td></tr> <tr><td align="center" bgcolor="#cccccc" width="20">#</td><td align="center" bgcolor="#cccccc">Function</td><td align="center" bgcolor="#cccccc">Location</td></tr> <tr><td align="center">0</td><td>CRM_Core_Error::exceptionHandler(Object(DB_Error))</td><td>unknown:unknown</td></tr> <tr><td align="center">1</td><td>call_user_func(Array, Object(DB_Error))</td><td>/OUR/WEB/SITE/sites/all/modules/civicrm/packages/PEAR.php:931</td></tr> <tr><td align="center">2</td><td>PEAR_Error->PEAR_Error('DB Error: syntax…', -2, 16, Array, 'SELECT id, item_…')</td><td>/OUR/WEB/SITE/si in/OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Core/Error.php on line 568

Merging two records:

Quote

Fatal error: Uncaught <table border="1" cellspacing="0"> <tr><td colspan="3" bgcolor="#ff9999"> PEAR_Exception: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc in unknown on line unknown</td></tr> <tr><td colspan="3" bgcolor="#ff9999">- DB_Error: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc in unknown on line unknown</td></tr> <tr><td colspan="3" bgcolor="#aaaaaa" align="center">Exception trace</td></tr> <tr><td align="center" bgcolor="#cccccc" width="20">#</td><td align="center" bgcolor="#cccccc">Function</td><td align="center" bgcolor="#cccccc">Location</td></tr> <tr><td align="center">0</td><td>CRM_Core_Error::exceptionHandler(Object(DB_Error))</td><td>unknown:unknown</td></tr> <tr><td align="center">1</td><td>call_user_func(Array, Object(DB_Error))</td><td>/OUR/WEB/SITE/sites/all/modules/civicrm/packages/PEAR.php:931</td></tr> <tr><td align="center">2</td><td>PEAR_Error->PEAR_Error('DB Error: a515ac…', 'a515ac9c2796ca0e…', 16, Array in/OUR/WEB/SITE/sites/all/modules/civicrm/CRM/Core/Error.php on line 568

Some of these are page source code, by the way, not that page itself.

flug · August 30, 2012, 11:43:57 pm

OK, I figured out one cause of the problem.

In Admin/Manage Extensions I had enabled & installed these two:

ExtendedReport
(eileenmcnaughton-nz.co.fuzion.extendedreport-49d404e)
CiviDiscount Module Extension
(org.civicrm.module.cividiscount)

But Extended Report was giving some errors so I deleted it from the directory (without uninstalling it from the admin page for extensions).

So that was throwing some errors in the Drupal log. I copied the extendedreport extension back into its proper directory and then went into the admin/extensions page and disabled it.

That didn't seem to stop the error (two of the messages pasted above were received after I did that).

However, it gave me an idea and I also disabled the CiviDiscount extension.

At the point the errors seemed to stop.

I worked for about an hour merging some records and also deleted a test participant--both of which had caused the error messages before.

With those extensions disabled, I had no real problems except *once* the system seemed to freeze up for a long time when I submitted a dedupe merge and then when the page finally did appear it was the final error message listed above.

I went back and worked for another hour on merges without the problem happening again.

So the CiviDiscount extension installed definitely seems to instigate the problem more often but there is something deeper going on.

I'm thinking there is a bug somewhere in the error system that causes Pear to throw these errors when it happens. The extensions where simply making this type of error occur much more often.

So (I think) there are two problems:

- those extensions cause some errors
- something in the error system isn't handling those errors, and some other errors, properly

FYI this is CiviCRM 4.2 and Drupal 6.

flug · August 31, 2012, 07:11:13 pm

Here is another clue.

I finally got cron working again after our upgrade to 4.2. (Had to change permissions on cli.php to allow it to execute.)

On its first execution it gave this error:

Quote

Fatal error: Wrong parameters for Exception([string $exception [, long $code [, Exception $previous = NULL]]]) in /home/mobikefed/www/www/sites/all/modules/civicrm/CRM/Core/Error.php on line 262

Line 262 of Error.php is this:

Code: [Select]

throw new Exception("A fatal error was triggered", $code);
I didn't have backtrace on at the time and I couldn't get this error message to replicate. But something is obviously calling the function fatal in Error.php with a $code that isn't in the proper format.

UPDATE: $code is being sent as NULL, which is the cause of the error. I'm still working on getting a backtrace of the code leading up to that error.

UPDATE2: Actually $code being sent as NULL is fine, that's not the cause of the error. I haven't been able to replicate the original uncaught exception error on the cron job.

Eileen · September 02, 2012, 08:06:29 pm

Ok - my take on this is that maybe the exception mode is being changed so that instead of getting a fatal error on your screen you are getting an uncaught exception. I couldn't replicate this turning on the modules but I suspect the underlying error is something else & the extensions are just causing the errors to appear differently.

Have you got debugging on? perhaps there is a backtrace in your log?

Are you using triggers or multilingual?

Eileen · September 02, 2012, 10:26:51 pm

It's possible I hit similar

http://pastebin.com/igK5SJ5d

(in which case it is not drupal 6 specific as this was d7 but there is a loop in the error handling relating to building the menu)

flug · September 06, 2012, 11:13:31 pm

Quote from: Eileen on September 02, 2012, 08:06:29 pm

Ok - my take on this is that maybe the exception mode is being changed so that instead of getting a fatal error on your screen you are getting an uncaught exception. I couldn't replicate this turning on the modules but I suspect the underlying error is something else & the extensions are just causing the errors to appear differently.

Have you got debugging on? perhaps there is a backtrace in your log?

When I have had these errors come up there doesn't seem to be anything written to the log--it exits before getting to the point.

Quote

Are you using triggers or multilingual?

No.

Cyberflyer · April 16, 2013, 03:46:01 pm

I think I have a helpful pointer to the problem.

I am using CIVICRM 4.2 and Drupal 6.

I am getting CRON.php error emails once a day with the following content:

Quote

Fatal error: Wrong parameters for Exception([string $exception [, long $code [, Exception $previous = NULL]]]) in /home/nscfpin0/public_html/sites/all/modules/civicrm/CRM/Core/Error.php on line 262

Long story short, I went to the CiviCRM => Administer CiviCRM => Scheduled Jobs page.

For the job "Geocode and Parse Addresses (Daily)" I found that when I clicked 'Execute Now', the same code would get displayed as a return web page. Why Geocode is throwing an exception, I don't know.

But when Cron runs, I get the HTML as a text.

I've disabled this job.

Can anyone tell me what is happening, exactly?

Possibly related is the system getting screwed up and randomly showing 'File Not Found' to visitors and loosing the menu.

Does anyone know what causes that and could it be related to this issue?

Donald Lobo · April 16, 2013, 08:24:43 pm

can you try and reproduce this error on our demo server running 4.3. You will need to enter your google geocoding key

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6 (Read 2422 times)

flug

Bizarre/broken error message with test participant deletion in 4.2/Drupal 6

flug

Re: Bizarre/broken error message with test participant deletion

flug

Re: Bizarre/broken error message with test participant deletion

flug

Re: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6

Eileen

Re: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6

Eileen

Re: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6

flug

Re: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6

Cyberflyer

Re: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6

Donald Lobo

Re: Bizarre/broken error message with test participant deletion in 4.2/Drupal 6