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) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DB Errors after "successful" upgrade to 4.5.2
Pages: 1 [2]

Author Topic: DB Errors after "successful" upgrade to 4.5.2  (Read 1761 times)

Rob Hills

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: Drupal 7.3
  • MySQL version: 5.6
  • PHP version: 3.0
Re: DB Errors after "successful" upgrade to 4.5.2
November 26, 2014, 05:07:53 am
Hi Dave,

Quote from: davej on November 26, 2014, 02:56:51 am
Sorry that didn't work out, could you try this patch instead, against the original version?
That's fine, I understand how difficult it is to debug an issue that you can't easily reproduce.  I'm delighted to report that your latest patch has resolved the issue for me.

Quote from: davej on November 26, 2014, 02:56:51 am
Also did you try setting up the prefixes for the Civi tables in settings.php, as I described in my comment of 18th Nov? That shouldn't be necessary with this new patch, but is another way to get it working if you're not able to patch immediately. It's something you would need to do anyway if you wanted to use Civi Views integration at some point.

I hadn't done this before now, as I wanted to be able to prove that your patch fixed my primary issue.  Now that I've proven that, I will go and sort out the configuration issue.

Many thanks,
Rob Hills
Waikiki, Western Australia

hwcb

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.5.4
  • CMS version: Drupal
  • MySQL version: 5.1.54
  • PHP version: 5.4.24
Re: DB Errors after "successful" upgrade to 4.5.2
November 29, 2014, 09:22:23 am
Thanks, Dave!

After upgrading from 4.4 to 4.5, I had the same problem Rob described. I applied your patch, and it fixed it.

nickholden

  • I post occasionally
  • **
  • Posts: 111
  • Karma: 1
  • CiviCRM version: 4.4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5.32
  • PHP version: 5.4
Re: DB Errors after "successful" upgrade to 4.5.2
December 01, 2014, 02:13:06 am
Thanks, Dave. I didn't realise the module was attempting to access both the Drupal and Civi databases in a single query. Given that the architecture allows the two systems to have dbs on completely different database servers that probably isn't a future proof approach. Your patch certainly solved the problem for me. No more error messages on log in. Nice work.

Will the fix make it into the next 4.5.x release, or will it wait for 4.6?

davej

  • Ask me questions
  • ****
  • Posts: 404
  • Karma: 21
Re: DB Errors after "successful" upgrade to 4.5.2
December 01, 2014, 03:24:05 am
I've created a pull request against the 7.x-4.4 civicrm-drupal branch, in the hope that this fix can go into 4.4.x LTS as well as 4.5 .

See https://issues.civicrm.org/jira/browse/CRM-15644?focusedCommentId=67901&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-67901

Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DB Errors after "successful" upgrade to 4.5.2

This forum was archived on 2017-11-26.