Questions around the TYPO3 integration and plugins as well as Flow and NeosCMS
Forum rules: Always add your TYPO3/Flow, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#2686 by goerch
14 Apr 2016, 13:26
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
#2687 by aimeos
14 Apr 2016, 13:33
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)?
#2688 by goerch
14 Apr 2016, 14:34
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
Attachments
screen-aimeos2.jpg
screen-aimeos2.jpg (85.69 KiB) Viewed 982 times
screen-aimeos.jpg
screen-aimeos.jpg (108.6 KiB) Viewed 982 times
#2689 by aimeos
14 Apr 2016, 15:20
goerch wrote:The cronjob started every 5 minutes, but the task frequency is set 60 seconds. Could this be the problem?


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:But the aimeos task gives me nothing, only the notice, that the task is running.


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?
#2690 by goerch
14 Apr 2016, 17:19
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=system_txschedulerM1&moduleToken=652e89104afb7566d1bcc6a6e62857755fdef2ea&tx_scheduler[execute][]=4". Crazy ...

Jörg
#2691 by aimeos
14 Apr 2016, 19:53
Extremely strange! Is there any error message in the Apache error log?
#2692 by goerch
15 Apr 2016, 09:13
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
#2693 by aimeos
15 Apr 2016, 10:08
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?


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.
#2694 by goerch
15 Apr 2016, 10:19
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
#2695 by aimeos
16 Apr 2016, 11:52
goerch 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.


Interesting question :-)
The guys from the Aimeos company should be able to help you with that specific problem:
https://aimeos.com/usd/aimeos-gmbh/contact/