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) »
  • Adding missing indexes after upgrade v 1.9 to 4.05
Pages: [1]

Author Topic: Adding missing indexes after upgrade v 1.9 to 4.05  (Read 840 times)

Denver Dave

  • Ask me questions
  • ****
  • Posts: 471
  • Karma: 9
Adding missing indexes after upgrade v 1.9 to 4.05
October 04, 2011, 09:00:36 am
We've recently upgraded from CiviCRM 1.9 to 4.05.  Occasionally, we get a message that an index is missing and usually the process runs anyway.  Here is an example when doing a test that allows contacts to update their profile from a link in a mailing - the mailing and the link works.

Notice: Undefined index: hash in CRM_Utils_Token::getContactTokenReplacement() (line 573 of /home/healthcare/www/www/sites/all/modules/civicrm/CRM/Utils/Token.php).

I'm suspecting that the indexes were just not created during the upgrade process.  Is there a place that the indexes are documented and I could just add them with phpmyadmin?    I suppose I could install a new version as a test and look at the indexes, but wondered if there might be an easier way to find out about the missing indexes.

Thanks.

= = = =
another example:
Notice: Undefined index: country-Primary in CRM_Profile_Form::formRule() (line 757 of /home/healthcare/www/www/sites/all/modules/civicrm/CRM/Profile/Form.php).
« Last Edit: October 04, 2011, 12:55:55 pm by Denver Dave »

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: Adding missing indexes after upgrade v 1.9 to 4.05
October 04, 2011, 02:33:17 pm
You can ignore notices, it won't affect any functionality, you can also turn off reporting to write to log.

Kurund
Found this reply helpful? Support CiviCRM

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Adding missing indexes after upgrade v 1.9 to 4.05
October 05, 2011, 06:28:33 am
Dave, what Kurund means is that those warnings are actually about undefined indexes in a PHP array, and have nothing to do with your database. They are small issues in the CiviCRM core code base that generate warnings, which are not errors. They can be ignored, and they should be fixed for CiviCRM 4.1.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Denver Dave

  • Ask me questions
  • ****
  • Posts: 471
  • Karma: 9
Re: Adding missing indexes after upgrade v 1.9 to 4.05
October 05, 2011, 08:38:10 am
Thanks for clearing that up - I won't bother searching another database for indexes.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Adding missing indexes after upgrade v 1.9 to 4.05

This forum was archived on 2017-11-26.