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 »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Some Questions about CiviMail Settings
Pages: [1] 2

Author Topic: Some Questions about CiviMail Settings  (Read 6977 times)

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Some Questions about CiviMail Settings
November 30, 2007, 03:02:34 pm
When creating a New Mailing, there is an option to test the mailing, that is Option 4. I have done this and I do receive the result of the test so I assume my mail configuration (CiviMail and SMTP) is set up correctly. I then try to send the mailing (immediately). This is not working. The mail is still sitting in the queue well beyond the time that is displayed.

The time that is displayed next to the scheduled mail is the time of my local server, Australian Eastern Daylight Time. The SMTP server is somewhere in the USA but I am not sure of the time zone. I think the time that the mail is processed should be relative to the time of my server but somebody correct me if I am wrong.

The problem is then, why is the mail queue not being processed by the SMTP server?  If the test worked, why doesn't the queue get processed?

Thanks

P. S.

After my original post I tried to do a test mailing to me as an individual and to a group. I got a whole screen of error messages. Here is a snippet. Can someone give me a clue about where to start looking for the problem?

# warning: Missing argument 2 for CRM_Core_DAO::executeQuery(), called in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php on line 798 and defined in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 656.
# warning: Invalid argument supplied for foreach() in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 696.
# warning: Missing argument 2 for CRM_Core_DAO::executeQuery(), called in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php on line 819 and defined in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 656.
# warning: Invalid argument supplied for foreach() in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 696.
# warning: Missing argument 2 for CRM_Core_DAO::executeQuery(), called in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php on line 798 and defined in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 656.
# warning: Invalid argument supplied for foreach() in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 696.
# warning: Missing argument 2 for CRM_Core_DAO::executeQuery(), called in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php on line 819 and defined in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 656.
# warning: Invalid argument supplied for foreach() in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 696.
# warning: Missing argument 2 for CRM_Core_DAO::executeQuery(), called in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php on line 798 and defined in /var/www/fareast.podzone.net/sites/all/modules/civicrm/CRM/Core/DAO.php on line 656.
« Last Edit: November 30, 2007, 03:52:57 pm by Ozyank »

Networker

  • Guest
Re: Some Questions about CiviMail Settings
November 30, 2007, 04:24:07 pm
Hi,
We seem to have the same problem.  Test mail works, but nothing else.  The queue fills up, but no entry has a "Scheduled Start Date".  And I do not see any errors anywhere.  We're running ver 1.7 hosted on Site5.

Networker

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Some Questions about CiviMail Settings
November 30, 2007, 04:32:23 pm
This is 1.9

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: Some Questions about CiviMail Settings
November 30, 2007, 04:51:11 pm
This is already fixed. Do upgrade to latest stable release.

kurund
Found this reply helpful? Support CiviCRM

Networker

  • Guest
Re: Some Questions about CiviMail Settings
November 30, 2007, 08:46:46 pm
I've isolated my problem to the civimail.cronjob.php file. (I think)  When I run it from a command prompt I get this:

[marionde@brahma bin]$ ~/public_html/modules/civicrm/bin/civimail.cronjob.php
~/public_html/modules/civicrm/bin/civimail.cronjob.php: line 1: ?php: No such file or directory
~/public_html/modules/civicrm/bin/civimail.cronjob.php: line 3: /aquota.user: Permission denied
~/public_html/modules/civicrm/bin/civimail.cronjob.php: line 4: +-------------------------------------+: command not found
~/public_html/modules/civicrm/bin/civimail.cronjob.php: line 5: syntax error near unexpected token `|'
~/public_html/modules/civicrm/bin/civimail.cronjob.php: line 5: ` |                      CiviCRM version 1.7                                                 
|'
[marionde@brahma bin]$

When I look at the file I can not find which directory they are talking about in line1.  Nor which permission I need to change for line3. 

I'm equally lost on line4 and 5.

Any ideas?

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Some Questions about CiviMail Settings
November 30, 2007, 09:33:01 pm
I'm not sure if Networker's question is related.

Why was the earlier version released if it was not working? These errors indicate a big flaw in the software to me. Why was it not caught before?

I have not upgraded yet. I would like to know if anyone has had the same problem before then upgraded and found it now works.

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: Some Questions about CiviMail Settings
November 30, 2007, 09:51:09 pm

1. CiviCRM IS an open source product. We rely on the community to help with development, bug fixes, features, documentation and much more.

2. Did you participate in the QA of the alpha/beta releases? If not, why not?

3. All software products have bugs and issues. We do try hard to find and fix issues before a release. If you have ideas on how to better improve our QA process, please step up and offer your time and services and help us make the next releases even better (though i suspect they will still not be bug free)

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

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Some Questions about CiviMail Settings
December 01, 2007, 02:44:04 am
Dear Lobo,

No, I did not participate in the Alpha or Beta process. I am an end user of the product and I do appreciate the efforts of the many people who try to make it work for the rest of us in the community. My interest is not so much in the software development process as it is in what the software will do for my organisation. I am very happy to participate within the bounds of my time and technical limitations.

I am afraid I stepped on a political toe here. My organisation is expecting that CiviCRM and CiviMail will work for us. We are not software engineers but a few of us, like myself, have some skills and are very happy to help but need a guiding hand.

The CiviMail component is critical to the success of our project. It is not working as expected and I need to know how to make it work and I will do whatever I can to participate in that process. I just need to know where to go from here.

So, back to my original question. What can I do and what information can I provide to help debug this thing?

Regards,

Dennis

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: Some Questions about CiviMail Settings
December 01, 2007, 07:48:16 am

As kurund mentioned, please download the latest version and see if that works. If that does not, repeat the same process on our demo server and see if you can reproduce the same bugs on the demo server. If so, please file an issue on the issue tracker. If not, it might be an install / environment issue


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

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Some Questions about CiviMail Settings
December 01, 2007, 12:03:58 pm
Will do that today on my local server which was cloned from the server at Development Seed set up for Democrats Abroad. The symptoms are the same on both servers now.

Dennis

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Some Questions about CiviMail Settings
December 01, 2007, 01:45:05 pm
This installation is 1.9 something. How do I confirm the exact build? Also, do I need to run the database upgrade script? The upgrade instructions are referring to an upgrade from 1.8 to 1.9.

Thanks again

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Some Questions about CiviMail Settings
December 02, 2007, 12:07:31 am
This is now getting frustrating. I would like to know how to upgrade from 1.9???? to 1.9???? as suggested earlier in this post. When I attempted to just copy over the latest files I got database errors, which indicate to me that I need to update the database but I don't know how. The online instructions only talk about upgrading from 1.8 to 1.9.

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: Some Questions about CiviMail Settings
December 02, 2007, 07:40:59 am

To upgrade a 1.9 release to the latest 1.9 release you just need to copy the files. Please cut and paste the database errors you get. That will help us a bit more to figure out whats happening

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

msn

  • I post frequently
  • ***
  • Posts: 152
  • Karma: 6
  • Please talk to the other site
Re: Some Questions about CiviMail Settings
December 02, 2007, 09:47:43 am
Hello Ozyank,

Did you try to search on keywords in the forum?
For time problems (local, server, php, mysql) you would have found http://forum.civicrm.org/index.php/topic,303.0.html
There are also forum items about civimail.cronjob.php.

Maybe 'old' forum items can help you. Good luck,

Martin

Open source is not only taking it is also giving

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Some Questions about CiviMail Settings
December 02, 2007, 11:42:14 am
I probably should have split this into two posts, one relating to the original time issue and another relating to the other errors. Thanks for the hints about searching for keywords. I was more focussed on the critical problem and had not followed up on the time issue. This was my first posting.

To respond to Lobo, I'll reinstall tonight and document the database errors.

Dennis
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Some Questions about CiviMail Settings

This forum was archived on 2017-11-26.