Hello,
I don't know how can i debug this issue. I created a scheduled task using the php plugin. All is well when i test it using the "Run" button.
Next step was to see if the task is running on specified time. It does, but no information is submited to the database.
So I tried to see what happen with var_dump($query);exit; then i activated the log. Both options run well only if i press the "Run" button, but nothing happen for the scheduled task.
This is the code:
Thank you
I don't know how can i debug this issue. I created a scheduled task using the php plugin. All is well when i test it using the "Run" button.
Next step was to see if the task is running on specified time. It does, but no information is submited to the database.
So I tried to see what happen with var_dump($query);exit; then i activated the log. Both options run well only if i press the "Run" button, but nothing happen for the scheduled task.
This is the code:
Code:
$sql1 = ("LOAD DATA INFILE 'D:/importuri/pc_daily/PC_DAILY.csv' INTO TABLE aplicatii_pc_daily FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (OFFER_ID,OFFER_NAME,OFFER_TYPE,CATEGORY,CATEGORY_BRM,UPDATE_DATE) set UPDATE_DATE = now()");
$db->setQuery($sql1);
$db->query();
Thank you