There is an SQL error contained on line 993 when using the NOW() call.
VALUES (:nid, :vid, NOW(), :categories, :nodes, :view, :view_args)",

Comments

danielb’s picture

danielb commented

What is the SQL error? I don't see a problem. What kind of database are you running?

danielb’s picture

danielb commented

I suppose we could use REQUEST_TIME instead of NOW() anyway, if that's causing issues

danielb’s picture

danielb commented
Status: Active » Needs review

I changed it to REQUEST_TIME

<?php
    db_query(
      "INSERT"
      . " INTO {nap_products}"
      . " (nid, vid, entry_date, categories, nodes, view, view_args)"
      . " VALUES (:nid, :vid, :now, :categories, :nodes, :view, :view_args)",
      array(
        ':nid' => $nid,
        ':vid' => $vid,
        ':now' => REQUEST_TIME,
        ':categories' => $categories,
        ':nodes' => $nodes,
        ':view' => $view,
        ':view_args' => $view_args,
      )
    );
?>

See how that goes for you. It's committed and will appear in the next dev snapshot.
If you're happy with that, I will make another release.

jasonkryst’s picture

jasonkryst commented

I've been using SQLite as a database, I will test out your latest dev snapshot and let you know.

jasonkryst’s picture

jasonkryst commented

This issue is resolved. Thank you very much for your support!

danielb’s picture

danielb commented
Status: Needs review » Fixed

sweet

danielb’s picture

danielb commented
Status: Fixed » Needs work

It seems making this change breaks the query for others.
Were you using sqlite or something?

danielb’s picture

danielb commented
Status: Needs work » Closed (fixed)

#1648668: PDOExeception : SQLSTATE[22007]