Cronjob Handler

[Ahmed SamirParticipantTopics: 0Replies: 1Total Posts: 1]

i install 6.3.4 version

and config SMTP to Enable Cornjobs to send EMAIL

crontab on my server add only this command

* * * * * /usr/bin/curl -s http://10.40.40.200/eduTrac-SIS/cron/cronjob?password=XXX

and config all cronjob handlers in edutrac system edit the url

but not send email

log cron tab is :

Running: http://10.40.40.200/eduTrac-SIS/cron/runEmailQueue/

Connecting to cronjob

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 637Total Posts: 641]

Bugs.

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Teja MajetyModeratorTopics: 12Replies: 204Total Posts: 216]

Thanks, Parker <span style=”background-color: #f5f6f5;”>I think</span> that solved the issue , I just checked the error log and it didn’t have any recent logs generated. Is this generally a bug or did I just miss the updated files during update/installation?

Even just before this, I found issue with SQL interface, I couldn’t view the SQL interface screen as before happened with staff screen. Though it has been solved as you have suggested in the previous forum. Am I missing all these updated files or these are just bugs?

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 637Total Posts: 641]

It backs up the database and save it in /tmp/, but you should really do your own backups instead of relying on the system to do backups for you. So, you can continue to ignore that cronjob handler.

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 637Total Posts: 641]

A query that is returning null is being called too early. For the runEmailHold route in cron.router.php, move the following lines:

$query = $r['savedQuery'];
$hold1 = $app->db->query($query);

After this line:

if (count($q2) <= 0) {

 

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Teja MajetyModeratorTopics: 12Replies: 204Total Posts: 216]

Hi,

Recently i created all the cron handlers listed except some of them like backup and purge crons which i don’t want. The problem here is after creating the cron handlers, i keep receving error logs.

[18-Oct-2016 14:00:01 Europe/Dublin] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty' in /var/www/html/Liten/Orm.php:247
Stack trace:
#0 /var/www/html/Liten/Orm.php(247): PDOStatement->execute(Array)
#1 /var/www/html/app/routers/cron.router.php(612): Liten\Orm->query(NULL)
#2 [internal function]: {closure}()
#3 /var/www/html/Liten/Liten.php(506): call_user_func_array(Object(Closure), Array)
#4 /var/www/html/Liten/Liten.php(448): Liten\Liten->handle(Array, true)
#5 /var/www/html/config.php(161): Liten\Liten->run()
#6 /var/www/html/index.php(27): include('/var/www/html/c...')
#7 {main}
thrown in /var/www/html/Liten/Orm.php on line 247

This error is generating for every 30 minutes, and the only crons i have for 30 minutes are “Process Email Hold” and “Process Email Queue”.

Are these handlers related to communication management? where they manage emails and templates etc. I don’t have anything in my communication management, I mean didn’t create any template or mail yet.

So, is this error normal until I have something in communication management?

You need to login in order to like this post: click here

[Michael WilliamsMemberTopics: 2Replies: 38Total Posts: 40]

This reply has been marked as private.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 637Total Posts: 641]

Do you have two installations of eduTrac SIS installed? Are they trying to use the same database?

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Michael WilliamsMemberTopics: 2Replies: 38Total Posts: 40]

This reply has been marked as private.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 637Total Posts: 641]

@Michael Williams, I need the FTP details to where eduTrac SIS is installed.

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Michael WilliamsMemberTopics: 2Replies: 38Total Posts: 40]

This reply has been marked as private.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 637Total Posts: 641]

If this is a production site, can you post a private reply and give me FTP details for server and super admin account details for eduTrac SIS?

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Michael WilliamsMemberTopics: 2Replies: 38Total Posts: 40]

See attached

Attachments:

You must be logged in to view attached files.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 637Total Posts: 641]

Do you have two versions of the plugin installed by chance?

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Michael WilliamsMemberTopics: 2Replies: 38Total Posts: 40]

using the SMTP plugin is not working.  I get the following when trying to activate the pluging:

 

The plugin etsis-smtp.plugin.php has been deactivated because your changes resulted in a fatal error.

The following function is already defined elsewhere: etsis_smtp_page

 

I am using EduTracSiS version 6.2.9

You need to login in order to like this post: click here