sqlite - PDOException: SQLSTATE[HY000]: General error: 1 no such function: NOW

Hello

there is a problem with advpoll and sqlite. Namely in the function advpoll_get_poll_info_blocks($blocks) on line 955.

for the module to be compatible the query should be split up or date("Y-m-s H:i:s", time()) would have to be used.

PDOException: SQLSTATE[HY000]: General error: 1 no such function: NOW: SELECT n.title, n.nid FROM {node} n LEFT JOIN {field_data_advpoll_dates} d ON d.revision_id = n.vid LEFT JOIN {field_data_advpoll_closed} c ON c.revision_id = n.vid LEFT JOIN {field_data_advpoll_options} o ON o.revision_id = n.vid WHERE n.type = 'advpoll' AND o.advpoll_options_value = 'block' AND n.status = 1 AND c.advpoll_closed_value = 'open' AND d.advpoll_dates_value < NOW() AND d.advpoll_dates_value2 > NOW() ORDER BY n.created DESC; Array ( ) in advpoll_get_poll_info_blocks() (line 969 of [...]\modules\advpoll\advpoll.module).