Problem with Scheduler
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Problem with Scheduler
hello, its me again.
i have some trouble with the scheduler. The cronjob starts all e-mail - relevant actions for shop. But no mail will send. The status is green, "currently running". When i start it manuell, the order confirmation mail will be send. According to the topic from crazyforster 31.3.2016 could it be the same problem?
System: Typo3 6.2.9, Aimeos 16.4.1 updated yesterday from 16.2.0 b34 . By the way, this is the first time i try to work with scheduler and aimeos, and yes, a parallel scheduler test task is working well. (sending every 5 minutes an e-mail notification).
Maybe you can help me?
Jörg
i have some trouble with the scheduler. The cronjob starts all e-mail - relevant actions for shop. But no mail will send. The status is green, "currently running". When i start it manuell, the order confirmation mail will be send. According to the topic from crazyforster 31.3.2016 could it be the same problem?
System: Typo3 6.2.9, Aimeos 16.4.1 updated yesterday from 16.2.0 b34 . By the way, this is the first time i try to work with scheduler and aimeos, and yes, a parallel scheduler test task is working well. (sending every 5 minutes an e-mail notification).
Maybe you can help me?
Jörg
Re: Problem with Scheduler
Can you post a screenshot of your Aimeos e-mail scheduler task settings?
Are any related error messages in the logs (either look at admin interface -> Overview -> second panel or directly into the madmin_log table)?
Are any related error messages in the logs (either look at admin interface -> Overview -> second panel or directly into the madmin_log table)?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Problem with Scheduler
Here is the screenshot. I looked madmin_log, nothing to see, in sys_log ifound the following entry: "[scheduler]: Start execution. Class: Aimeos\Aimeos\Scheduler\Task\Email6, UID: 4". The timestamp is today. It seems, that in the syslog there is no "[scheduler] Task executed". The cronjob started every 5 minutes, but the task frequency is set 60 seconds. Could this be the problem? Testing this configuration with test-task it was no problem, task status go to "Late, will run with next execution". And then after 5 minutes or so, it was executed. But the aimeos task gives me nothing, only the notice, that the task is running. See screeshot 2.
Thanks a lot. Jörg
Thanks a lot. Jörg
- Attachments
-
- screen-aimeos2.jpg (85.69 KiB) Viewed 8124 times
-
- screen-aimeos.jpg (108.6 KiB) Viewed 8124 times
Re: Problem with Scheduler
No, not at all. This is quite normal in most setups. The only thing you shouldn't do is to allow the Aimeos tasks to run in parallel! (checkbox in the second screenshot)goerch wrote:The cronjob started every 5 minutes, but the task frequency is set 60 seconds. Could this be the problem?
The task is in an error state. What's displayed if you move the mouse over the red light image left of the task ID in the list of scheduler tasks? Does it work if you execute the Aimeos e-mail task by hand?goerch wrote:But the aimeos task gives me nothing, only the notice, that the task is running.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Problem with Scheduler
OK, the red button on the left side of the task-id seems to be a stop -button. On mouseover it gives me "stop". The right green dot gives me "currently running". When i click on the red button i will asked "Are you sure you want to mark this task as not running? Note that this will not stop the actual script (if unsure please refer to the manual)." Confirming ok it gives me the 404-error-page of the frontend. The called url is "http://www.XXX.com/typo3/mod.php?M=syst ... ecute][]=4". Crazy ...
Jörg
Jörg
Re: Problem with Scheduler
Extremely strange! Is there any error message in the Apache error log?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Problem with Scheduler
So, the next information:
Its a nginx Server, in the log-files there is only an error about a preview image which can't be found.
Then i check the detail-shop page, disable the login for this page and have a look in plugin catalog-detail plugin. There was a missing information about "catalog-page with session-plugin". i added this info.
The i start the scheduler per hand and voila, there is an error message: "Execution of task "Planer für Aimeos Shop E-Mails (aimeos)" failed with the following message: Executing statement "UPDATE madmin_queue SET cname = '320286284709b51408840fa49c1079a4', rtime = '2016-04-15 10:59:58' WHERE queue = 'customer/email/account' AND rtime < '2016-04-15 10:59:58' LIMIT 1" failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.madmin_queue' doesn't exist". And in fact, there is no madmin_queue in database. Could it be, that version 16.4.1 have a madmin_queue, and 16.2.0 b34 has not? Then, i think have to start the update script per hand?
Jörg
Jörg
Its a nginx Server, in the log-files there is only an error about a preview image which can't be found.
Then i check the detail-shop page, disable the login for this page and have a look in plugin catalog-detail plugin. There was a missing information about "catalog-page with session-plugin". i added this info.
The i start the scheduler per hand and voila, there is an error message: "Execution of task "Planer für Aimeos Shop E-Mails (aimeos)" failed with the following message: Executing statement "UPDATE madmin_queue SET cname = '320286284709b51408840fa49c1079a4', rtime = '2016-04-15 10:59:58' WHERE queue = 'customer/email/account' AND rtime < '2016-04-15 10:59:58' LIMIT 1" failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.madmin_queue' doesn't exist". And in fact, there is no madmin_queue in database. Could it be, that version 16.4.1 have a madmin_queue, and 16.2.0 b34 has not? Then, i think have to start the update script per hand?
Jörg
Jörg
Re: Problem with Scheduler
I guess, you've uploaded the new Aimeos version by hand instead of downloading it in the extension manager from the TER. In this case, TYPO3 doesn't execute the update script automatically and yes, you now have to do it by hand.goerch wrote:Could it be, that version 16.4.1 have a madmin_queue, and 16.2.0 b34 has not? Then, i think have to start the update script per hand?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Problem with Scheduler
So adding the madmin_queue solved the scheduler problem, but i think i have a misconfiguration.
The detail-page (the uid of this page is set in scheduler-task) with login restriction (set in page setting for the whole page) stops the scheduler doing his job. You can see it in the screenshot i sent yesterday. Disabling the login restriction in detail-page and the scheduler works well. What i want: every user have to login, before he can go to catalog and so on. So there is a page restriction for every page set in page settings. I think now, this is the wrong way, but what is the right way ...
Jörg
The detail-page (the uid of this page is set in scheduler-task) with login restriction (set in page setting for the whole page) stops the scheduler doing his job. You can see it in the screenshot i sent yesterday. Disabling the login restriction in detail-page and the scheduler works well. What i want: every user have to login, before he can go to catalog and so on. So there is a page restriction for every page set in page settings. I think now, this is the wrong way, but what is the right way ...
Jörg
Re: Problem with Scheduler
Interesting questiongoerch wrote:What i want: every user have to login, before he can go to catalog and so on. So there is a page restriction for every page set in page settings.
The guys from the Aimeos company should be able to help you with that specific problem:
https://aimeos.com/usd/aimeos-gmbh/contact/
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star