[TYPO3-english] Run something regullary

Xavier Perseguers typo3 at perseguers.ch
Sun Aug 8 15:49:19 CEST 2010


Hi,

>>>> I cannot reproduce this problem with unit test using DBAL trunk. Could
>>>> you please make sure you have the latest released version of DBAL (by
>>>> having latest stable release of TYPO3 for your branch) and then, if
>>>> problem persists, please let me know which version of DBAL (or TYPO3)
>>>> you have.
>>> TYPO3 v 4.3.5
>>> DBAL v 1.0.5
>>> Sheduler v 1.0.0
>> Really strange...
> Sorry, I was wrong about what query produces this error (I'm really sad
> about it, sorry again!). I've just checked code one more time and found
> that query is here: scheduler/mod1/index.php:927
>
>          $query = array(
>              'SELECT'  =>  '*',
>              'FROM'    =>  'tx_scheduler_task',
>              'ORDERBY' =>  'nextexecution'
>          );
>
>          $res = $GLOBALS['TYPO3_DB']->exec_SELECT_queryArray($query);
>
> I copy this query to my own extension and it generates the same error
> because parseWhereClause is called with empty string.
>
> Hope you still can help me. :)

Yes, glad to see that there is no problem in DBAL :-) The query is 
invalid, it should read:

$query = array(
     'SELECT'  => '*',
     'FROM'    => 'tx_scheduler_task',
     'WHERE'   => '1=1',
     'ORDERBY' => 'nextexecution'
);

Please try and (as it should work) create a new issue on either 
scheduler's bug tracker (if there is one) or in Core.

Regards,
Xavier


More information about the TYPO3-english mailing list