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 »
  • 4.4 Release Testing »
  • civicrm_activity_target missing?
Pages: [1]

Author Topic: civicrm_activity_target missing?  (Read 1643 times)

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
civicrm_activity_target missing?
November 06, 2013, 02:46:39 am
Presumably as a result of my upgrade to 4.4 I have started to have problems with CiviMail bulk mail, which fails with the message that the database table does not exist. The table it's looking for is civicrm_activity_target which doesn't, now, exist in my database.

Should I have it, and is there any reason I would have come to lose it?

The problem wasn't immediately obvious with the upgrade, but came up when I tried to change from a maximum of 99 mails per mailing to "0" (i.e. all, on a list of just under 800 mails).

Ed

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: civicrm_activity_target missing?
November 06, 2013, 05:45:52 am
civicrm_activity_target contact has be dropped in 4.4. Can you please give details to replicate this issue? Are you able to replicate this on demo ?

Kurund
Found this reply helpful? Support CiviCRM

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: civicrm_activity_target missing?
November 06, 2013, 12:39:08 pm
@edp - sounds like you have a piece of CiviCRM code OR extension OR module OR query (eg views) which is still looking for old table names.

* Did you remove the old CiviCRM files before installing 4.4?
* Did you update any custom_php files which were copied to custom_php during 4.3?
* Do you have any extensions, modules or views which might be doing this?
@xurizaemon ● www.fuzion.co.nz

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Re: civicrm_activity_target missing?
November 06, 2013, 01:58:56 pm
Thanks both.

I tried disabling all extensions, and removing all things in the customisation folder except one template override. Still getting the error.

Looking at the backtrace below it appears to relate to a file called:
administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/MailingJob.php
which I still have, and that still refers (in the copy on my system) to civicrm_activity_target so I assume that anything that uses that code is doomed to failure. The 4.4 code I downloaded (joomla alt) also seems to contain that file with that reference too. Is that it?

backTrace

#0 /home/x/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/x/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/x/administrator/components/com_civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...")
#4 /home/x/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...")
#5 /home/x/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -18, NULL, NULL, "SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...", "DB_Error", TRUE)
#6 /home/x/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'mrc_dbname.civicrm_activity_target' doesn't exist")
#7 /home/x/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/x/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...")
#9 /home/x/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...")
#10 /home/x/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...")
#11 /home/x/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(158): DB_DataObject->query("SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...")
#12 /home/x/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(947): CRM_Core_DAO->query("SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...", TRUE)
#13 /home/x/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/MailingJob.php(941): CRM_Core_DAO::singleValueQuery("SELECT id FROM civicrm_activity_target WHERE activity_id = 18721 AND target_c...")
#14 /home/x/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/MailingJob.php(718): CRM_Mailing_BAO_MailingJob->writeToDB((Array:0), (Array:10), Object(CRM_Mailing_BAO_Mailing), "20131106102730")
#15 /home/x/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/MailingJob.php(553): CRM_Mailing_BAO_MailingJob->deliverGroup((Array:99), Object(CRM_Mailing_BAO_Mailing), Object(Mail_mail), "20131106102730", (Array:0))
#16 /home/x/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/MailingJob.php(174): CRM_Mailing_BAO_MailingJob->deliver(Object(Mail_mail), NULL)
#17 /home/x/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/Mailing.php(2680): CRM_Mailing_BAO_MailingJob::runJobs(NULL, NULL)
#18 /home/x/administrator/components/com_civicrm/civicrm/api/v3/Job.php(323): CRM_Mailing_BAO_Mailing::processQueue()
#19 /home/x/administrator/components/com_civicrm/civicrm/api/api.php(87): civicrm_api3_job_process_mailing((Array:1))
#20 /home/x/administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(132): civicrm_api("Job", "process_mailing", (Array:1))
#21 /home/x/administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(88): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#22 /home/x/administrator/components/com_civicrm/civicrm/CRM/Utils/System.php(1540): CRM_Core_JobManager->execute(FALSE)
#23 [internal function](): CRM_Utils_System::executeScheduledJobs((Array:3))
#24 /home/x/components/com_civicrm/civicrm/CRM/Core/Invoke.php(289): call_user_func((Array:2), (Array:3))
#25 /home/x/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:12))
#26 /home/x/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#27 /home/x/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:3))
#28 /home/x/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#29 /home/x/libraries/joomla/application/component/helper.php(383): require_once("/home/marlow/www/www/administrator/components/com_civicrm/admin.civicrm.php")
#30 /home/x/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent("/home/marlow/www/www/administrator/components/com_civicrm/admin.civicrm.php")
#31 /home/x/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#32 /home/x/administrator/index.php(46): JAdministrator->dispatch()
#33 {main}

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civicrm_activity_target missing?
November 06, 2013, 02:15:49 pm

argh

can u please file an issue. we'll try and get a fix out with 4.4.1

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civicrm_activity_target missing?
November 06, 2013, 02:22:28 pm

can you also try and ensure that this patch works
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Re: civicrm_activity_target missing?
November 06, 2013, 02:38:10 pm
Patch looks good, thanks.
Filed as http://issues.civicrm.org/jira/browse/CRM-13717
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.4 Release Testing »
  • civicrm_activity_target missing?

This forum was archived on 2017-11-26.