CiviCRM Community Forums (archive)

I'm completely at a loss and don't know where to start.   I've received error messages before that contained more info before that helped me troubleshoot but this doesn't really give me a whole lot of info to work with.

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

I believe this started occurring after upgrading from 3.4 to 4.1.2.  Our system works most of the time but once a day i would try restarting and clearing everything and hope it temporarily fixes it (restart php-fpm, restart memcache, restart apache, restart mysql, clear caches, delete template_c).  It just happened again and it's not "fixing" it this time.  Does anyone have ideas what's causing this?  Thanks.

I have my sort_buffer_size set to 536870912 so it doesn't look like that's the problem.

I looked at the drupal logs and this comes up several times for several users around the same time the problem occurred.

Missing argument 1 for CRM_Utils_System_Drupal6::cmsRootPath(), called in /usr/local/www/drupal/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php on line 829 and defined in /usr/local/www/drupal/sites/all/modules/civicrm/CRM/Utils/System/Drupal6.php on line 592.
When i search, people only run into that when their civicrm.settings.php is not correct.  I have 'CIVICRM_UF' set correctly to 'Drupal6' in my civicrm.settings.php so that doesn't appear to be it.

The server location and paths didn't change from my upgrade but i double checked and everything seems to be in the right place.  After this occurred yesterday and restarting all services, things began working again but the issue has reoccurred again today.  If it always worked or never worked would be fine but this sometimes is killing me

Since others don't seem to be coming up with this leads me to think this may be a config issue?  I'll keep trying to narrow things down.

Thanks for the advice though Dave!

You might try putting a backtrace - write to log - in CRM/Core/Error.php just above line 533 (where that function returns). I think if you do:

CRM_Core_Error::backtrace('Trap DB Error', TRUE);

... that should push the backtrace to the CivicRM log file.

I'm a bit suspicious that there's some DB read-write problem (hard disk issues or ??) since it's sporadic. Did you do more googling on that error?

Can you nail down the exact operation which triggers this (is it during Find Duplicates or when merging 2 contacts? which exact dedupe rule is being used? ...) Then grab a copy of the DB error w/ the invalid query and paste it here.

Since we're not sure whether this is an upgrade-related issue... you might also try the same operation (including configuring the dedupe rule which is being used on your site if it's not "out of the box") - on the public demo and see if you can trigger it there. If you can that will make it much easier to debug and hopefully fix.

found a similar error -
vanilla install of drupal 6.26 and civicrm 4.1.3
load sample data
edit a contact and upload photo for contact.
upon saving it gives the error

warning: Missing argument 1 for CRM_Utils_System_Drupal6::cmsRootPath(), called in /work/projects/testsites/testyvb2/www/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php on line 867 and defined in /work/projects/testsites/testyvb2/www/sites/all/modules/civicrm/CRM/Utils/System/Drupal6.php on line 613.

Might be a bug in the Drupal 6 / CiviCRM 4.1 code. Can you replicate on the D6 demo?

http://drupal6.demo.civicrm.org/

If so, please investigate and file an issue with a patch.