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 »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Staged bulk contributions gone in test DB
Pages: [1]

Author Topic: Staged bulk contributions gone in test DB  (Read 628 times)

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Staged bulk contributions gone in test DB
July 11, 2013, 10:23:33 am
After migrating a civi DB from prod to test, clicking 'Enter records' on a contribution batch yields blank results (on test).

Where are these staged batches stored? (I see the batch entry in civicrm_batch...)

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Staged bulk contributions gone in test DB
July 11, 2013, 08:06:05 pm
"Staged" batches are stored in civicrm_cache table and with civicrm_cache.group_name = 'batch entry'.
Protect your investment in CiviCRM by  becoming a Member!

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: Staged bulk contributions gone in test DB
July 11, 2013, 08:54:38 pm
Thanks, Dave!

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: Staged bulk contributions gone in test DB
July 29, 2013, 12:40:59 pm
Since they are in civicrm_cache, does that mean they are lost if one upgrades from e.g. 4.2.9 to 4.3.5?

I'm currently seeing that in my tests, but have not yet found the code to confirm this.  (Don't need the code, just the confirmation.)

Thanks!

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: Staged bulk contributions gone in test DB
July 29, 2013, 12:50:16 pm
Nevermind.  Just found CRM_Core_Config::clearDBCache() that has the line: 'TRUNCATE TABLE civicrm_cache'

But dumping civicrm_cache in 4.2.9 and re-loading it in 4.3.5 doesn't save refill the cached batch entries.  Any ideas/pointers on this?  (still looking...)

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Staged bulk contributions gone in test DB
July 29, 2013, 01:12:43 pm
If they show up in the cache table I would think they would show up in the UI if the corresponding batch is present and in Open status. ???
Protect your investment in CiviCRM by  becoming a Member!

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Staged bulk contributions gone in test DB
July 29, 2013, 01:44:38 pm
http://issues.civicrm.org/jira/browse/CRM-13066 is for tracking the cache table issue
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Staged bulk contributions gone in test DB

This forum was archived on 2017-11-26.