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 »
  • 2.2 Release Testing »
  • CiviMail accounts protocol list empty
Pages: [1]

Author Topic: CiviMail accounts protocol list empty  (Read 2965 times)

phani

  • I’m new here
  • *
  • Posts: 28
  • Karma: 3
    • namahatta.org DB
CiviMail accounts protocol list empty
January 14, 2009, 07:13:12 am
after upgrading my test site to 2.2, when i try to edit the mail account under CiviMail configuration, the select box for profiles is empty. on the sandbox this box is filled with the available protocols, i.e., imap, etc.

any suggestions what i'm missing here? do the scripts stll need to be edited as in the 2.1 version with experimental php mailing functions?

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: CiviMail accounts protocol list empty
January 15, 2009, 05:45:29 am
Seems to be bug in upgrade, will fix it before next alpha.
Currently you will have to manually make entries in db for mail prototypes. Fire below sql in you phpmyadmin or sql terminal.

Quote
INSERT INTO `civicrm_option_group` (`name`, `label`, `description`, `is_reserved`, `is_active`) VALUES
('mail_protocol', NULL, 'Mail Protocol', 0, 1);

SELECT @option_group_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol';

INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) VALUES
( @option_group_id_mp, 'IMAP', '1', 'IMAP', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
( @option_group_id_mp, 'Maildir', '2', 'Maildir', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
( @option_group_id_mp, 'POP3', '3', 'POP3', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
( @option_group_id_mp, 'In Person', '1', 'in_person', NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL);

HTh

Kurund
« Last Edit: January 15, 2009, 05:48:39 am by Kurund Jalmi »
Found this reply helpful? Support CiviCRM

phani

  • I’m new here
  • *
  • Posts: 28
  • Karma: 3
    • namahatta.org DB
Re: CiviMail accounts protocol list empty
January 15, 2009, 09:09:46 am
thank you very much!

i did that, ran the queries via phpMyAdmin, and the options were added to the option-group.
what i don't understand in the sql you provided: why do you assign the value '1' twice, once for 'IMAP', then again for something called 'In Person' ?

the duplicate values are added ok, but this makes the optioni 'IMAP' inaccessible. is this a typo, or some reason i don't understand?


PS: there's no 4th option in the sandbox.
« Last Edit: January 15, 2009, 09:16:27 am by phani »

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: CiviMail accounts protocol list empty
January 15, 2009, 11:01:56 am

thats a typo. The 4th option was mistakenly "cut-n-pasted". Please delete that (and fix your IMAP entry)

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

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: CiviMail accounts protocol list empty
January 15, 2009, 08:33:40 pm
oops, that's a typo. Correct sql

Quote
INSERT INTO `civicrm_option_group` (`name`, `label`, `description`, `is_reserved`, `is_active`) VALUES
('mail_protocol', NULL, 'Mail Protocol', 0, 1);

SELECT @option_group_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol';

INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) VALUES
( @option_group_id_mp, 'IMAP', '1', 'IMAP', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
( @option_group_id_mp, 'Maildir', '2', 'Maildir', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
( @option_group_id_mp, 'POP3', '3', 'POP3', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL);

Kurund
Found this reply helpful? Support CiviCRM

phani

  • I’m new here
  • *
  • Posts: 28
  • Karma: 3
    • namahatta.org DB
Re: CiviMail accounts protocol list empty
January 15, 2009, 08:42:06 pm
thanks again. lobo's reply made that clear already. (i had assigned a value of 4 to the strange option and wasn't planning to use it, so no harm done.)

phani.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • CiviMail accounts protocol list empty

This forum was archived on 2017-11-26.