to_do Module warning
Eingetragen von datenrettung (605)am 04.08.2009 - 15:07 Uhr in
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY deadline' at line 1 query: SELECT COUNT(n.title) FROM node AS n JOIN to_do AS td ON n.vid = td.vid JOIN to_do_assigned_users AS tdau ON tdau.vid = n.vid WHERE (td.deadline <= (CURRENT_DATE() + INTERVAL 7 DAY) OR td.priority = 3) AND n.type = 'to_do' AND tdau.uid = 1 AND n.status = 1 AND td.item_status != ORDER BY deadline in /var/www/drupal/sites/all/modules/to_do/to_do.module on line 1398.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY deadline' at line 1 query: SELECT COUNT(n.title) FROM node AS n JOIN to_do AS td ON n.vid = td.vid JOIN to_do_assigned_users AS tdau ON tdau.vid = n.vid WHERE n.type = 'to_do' AND tdau.uid = 1 AND n.status = 1 AND td.item_status != ORDER BY deadline in /var/www/drupal/sites/all/modules/to_do/to_do.module on line 1398.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY deadline LIMIT 0, 5' at line 1 query: SELECT DISTINCT(n.nid), n.title, UNIX_TIMESTAMP(td.deadline) AS deadline, td.item_status, td.priority FROM node AS n JOIN to_do AS td ON n.vid = td.vid JOIN to_do_assigned_users AS tdau ON tdau.vid = n.vid WHERE (td.deadline <= (CURRENT_DATE() + INTERVAL 7 DAY) OR td.priority = 3) AND n.type = 'to_do' AND tdau.uid = 1 AND n.status = 1 AND td.item_status != ORDER BY deadline LIMIT 0, 5 in /var/www/drupal/sites/all/modules/to_do/to_do.module on line 1398.Hat jemand eine aehnliche oder die selbe Warnung bei Einsatz von to_do?
- Anmelden oder Registrieren um Kommentare zu schreiben
Was sagt denn die Moduldatei
am 05.08.2009 - 15:22 Uhr
Was sagt denn die Moduldatei in Zeile 1398, wenn es die denn gibt?
Hab das Modul nicht installiert, deshalb die Frage.
Zeile 1398: return
am 06.08.2009 - 16:09 Uhr
Zeile 1398:
return db_query(db_rewrite_sql($sql));