26

(5 replies, posted in Need Help)

After changing the Email settings in the administration setting section from PHP to SMTP, the emails started being delivered to the email addresses in the list.  However, it does not send emails to any yahoo email addresses. At first I thought that the issue was that the emails needed to be sent to a domain email address only, but that is not the case.  I have read somewhere that yahoo email owners will sometimes not receive emails from some locations.

27

(5 replies, posted in Need Help)

Roel,

Since I can't upload anything to this forum, I have sent you an email with two screen shots that show it is not working.  Look forward to your response.

Fred

28

(5 replies, posted in Need Help)

Roel,

Now that we have resolved the problem of the cron job not being sent out, I have set up another calendar that I am hoping to use for my NFL football pool that I run on an annual basis. It is based on the MySQL database and not on the SQLite database.

Yes, the cronjob summary did say that email notifications were sent to the recipients in the text file which is why I was wondering why none of them received notifications. The problem may be that I was trying to run the cron job 24 hours and 30 minutes before the event time, but after midday.  I will try it again tomorrow morning to see if that makes a difference.

BTW, should the text file be displayed with the .txt extension or without in the To: section of the event window...?  I tried it both ways but don't know which one I should be using.

As always, thanks for your help.

Fred

29

(5 replies, posted in Need Help)

I am testing the module that sends email notifications to a list of people announcing an event. After reading the instructions, I set up a test text file with email addresses on separate lines and placed the file in the reciplists folder of the application.

I then set up an event, placed the text file name in the To: line of the event window and placed 1 day before the event as the time to send notifications.

The results were that I received a conjob summary and a changes list at the email address assigned for the application, but none of the addresses in the text list received a notification.  Where am I going wrong?

Fred

30

(24 replies, posted in Need Help)

Yes, it is working...I am getting the email notifications. As a matter of fact I am getting them at two different email addresses although I thought I had changed them all to be sent to the one email. I am going to try to find out why it is still sending to both of them and report back. 

I wanted to thank everyone that helped get this problem resolved and happy that it was a small matter that caused it in the first place.

Fred

31

(24 replies, posted in Need Help)

I believe the problem has been solved...the IP Address that I had in there was incorrect and when corrected, the notifications started coming through.  I am now testing the actual events instead of test events and will post the results tomorrow as that is when the cron job is scheduled.  I am making an assumption that if no events are scheduled, the notification will still arrive except that it will state no events are scheduled?

32

(2 replies, posted in Need Help)

That's what everyone is saying, but in my case it is not working and I keep getting the same failed error.

33

(24 replies, posted in Need Help)

Schwartz,

Since the file Roel sent me works with the cronjob provider, I would assume the lcalcron.php file would work as well since it is from the same provider.  BTW, the provider I am using is cron-job.org and I believe you provided the IP Address for it?

Since the cron job doesn't run, there is no log file entry, therefore no IP Address information, but as stated above, if it works for the file Roel sent me the IP Address should be correct. BTW, the luxcal log file contains the following information:

- Aborted. - OK. - OK. - OK. - Aborted. - Aborted. - Aborted. - Aborted. - Aborted. - Aborted. - Aborted. - OK. - Aborted. - Aborted. - Aborted. - Aborted. - Aborted. - OK. - Aborted.

34

(2 replies, posted in Need Help)

I was just wondering if my cron job problem is related to a path problem? 

In most cases, a webhost has a public_html folder and all website information would be entered in folders under that public_html folder.  As an example, the luxcalendar application would be in a folder set up as follows:

public_html/luxcal/

On the webhost that I am running lux calendar, there is no public_html folder, so the lux calender application is set up as follows:

/luxcal/

In looking at the lcalcron.php file, is it possible that the paths are set up based on the lux cal being in the public_html/luxcal/ folder and that is why it is failing?  I don't know enough about this to tell but thought it was worth a post.

35

(24 replies, posted in Need Help)

Everything worked...

I received a notification that an event had changed
I received a notification when I ran the cron job by hand
I received a notification of Cron Job Summary

IT DID NOT WORK WHEN I RAN THE CRON JOB AUTOMATICALLY USING THE lcalcron.php FILE

Roel provided me with a small testcron.php file that is working. The frustration keeps mounting. Hopefully this can be resolved.

36

(24 replies, posted in Need Help)

Well, changing the email address to one with the domain address sent the email.  It did not fix the cron job problem however...still getting the same error:

http://www.fredswebportal.com/fsptracker/lcalcron.php
Status
302 Found

Can't figure out why it is not working.

BTW, changing the email address to the domain's email address worked for both the MYSQL and MYSQLite versions.

37

(24 replies, posted in Need Help)

Thanks for the heads up Dan, I will certainly check that out. I wonder if that would fix my problem of not getting the email notifications?

EDIT:  I was just thinking however, that I have other applications on this domain and I have not had the same problem with sending emails. I will check into and report back.

38

(24 replies, posted in Need Help)

Roel,

I followed your suggestions exactly and here are the results.
1(a). Created an event for tomorrow and checked the Send mail now and did not receive an email.
  (b). Went back to settings and checked the Remote button and ran the lcalcron.php file from the browser...
  (c)  got a blank page but no email notification
  (d)  changed the URL to the correct one

Set up a cron job to run this morning and received the same error message I have been receiving...Fetched URL
http://www.fredswebportal.com/fsptracker/lcalcron.php
Status
302 Found

BTW, I tried the Test Email button in the settings in the first section. It said that an email was sent but I have not received one.  I tried it with both PHP mailer and smtp modules.

Now comes your second suggestion and after re-reading it, I may have found the problem myself.  You ask that I provide temporary FTP access, which I can do but then you ask for access to the mysqlite db and that is where I noticed that the mysqlite db is in a folder marked db in the root folder of the calendar application, so you will be able to access it without having any credentials.  when I installed the calendar using the mysqlite db, it did not ask for any log in credentials.  Is that where the db is supposed to be?

Send me your email address to fbonani@yahoo.com and I will provide FTP access.

BTW, I have friends in Brussels, how far do you live from there?

UPDATE:  I sent you the FTP credentials to your email address...I found it.

Fred

39

(24 replies, posted in Need Help)

Roel,

Unfortunately, it is still not working.  Here is what I have done so far:

1. Moved the tables from the original database to a database that does not have any tables with 'settings' in the name of the table, i.e. xxx_settings
2. Set up a Todo event for tomorrow at 9PM and had the cron job set to run at 8:45 AM this morning.
3. The settings in the calendar admin have been set using the IP Address with the IP address of cron-job.com
4. Received the same error message at cron-job.com as I received yesterday.
5. I changed the calendar admin to show remote and ran the lcalcron.php file manually and received a blank page...nothing in either of the logs

At this point, I don't know what else I can do to make this work...the calendar will be useless to me if this module does not work.  I am open to any suggestions you may have.

Fred

UPDATE: I just noticed that after running the lcalcron.php file manually from my browser, I did get a notification at my email address (in the spam folder) that you can see online at:
http://www.fredswebportal.com/luxcal/cron.png

Any ideas why the cron-job is not working? Also, I am concerned that the image states it did not find any reminders or changes...does that mean that it would not send a notification if it is a birthday or reminder?

40

(24 replies, posted in Need Help)

Roel,

You are very kind and as I have already stated, your support is top of the line.  OK, here are my thoughts and you can let me know if they are doable.

1. I actually believe this will be the best solution...separating the databases of Admidio and LuxCal. I can probably put the tables from the LuxCal application into another database. I assume that I will be able to just export the database information (and data) to an sql file and then import it into the other database.  I would then have to update the lcconfig.php file with the new database information. If that is not possible, let me know.

2. You are correct in that future upgrades will make this option an unneeded  headache.

3. I don't believe that my webhost has SQLite available.

41

(24 replies, posted in Need Help)

Scwartz,

Thanks for your quick response also...this application certainly does a great job with support.  Okay, I think we may be getting closer to a possible solution.

After changing the setting to "remote" and running the lcalcron.php file from my browser, I received the following message on the screen:  "SQL error. See 'logs/sql.log' "
When looking in the logs/sql.log file, this is what shows:
             2018.05.04 15:17:48 Script: /luxcal/lcalcron.php - SQL query error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'
Query string: SELECT `name`,`value` FROM `alumni_settings`

Have no idea why it is pointing to alumni_settings, which is a table of the Admidio application I have installed on the same server and which is using the same database.
My webhost limits the number of databases I can have so I have to use the same databases for different applications.

BTW, the cron-jog.org again shows the same message:

Fetched URL http://www.fredswebportal.com/luxcal/lcalcron.php
Status 302 Found

Please let me know if you need any other information.

42

(2 replies, posted in Need Help)

Again, thank you for your quick response and resolution to my question.  Your response was very clear and easy to adapt.  It works just like I wanted it to.

43

(2 replies, posted in Need Help)

Is it possible to get a similar page that displays a list of todo items? The page display2.php shows a list of upcoming events and would like to have a similar page for todo lists.

44

(24 replies, posted in Need Help)

I am trying to set up an email notifications when a birthday, reminder or todo event takes place but I have not been able to get it work. I have set up a cronjob with an outside agence (cron-org.org) and I keep getting the following message:
Fetched URL http://www.fredswebportal.com/luxcal/lcalcron.php
Status 302 Found.
Additional info:
On the Settings page, in the section Periodic Functions, I selected Cron job host = IP Address with 136.243.171.254 as the IP Address
The Status 302 Found message is coming from cron-jpb.org
The file lcalcron.php file is present in the calendar root folder

Any assistance will be much appreciated.