Get warnings when displaying a theme in a view

twen - July 13, 2007 - 13:45
Project:View - Theme
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

Hello !

I just installaed view-theme, affected the garland theme to a view (named 'minutes'). When I'm displaying this view ( /minutes ) I get these warning messages.

* 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 'IN ('')) AND node.nid = 2' at line 1 query: SELECT count(node.nid) FROM honeypod_node node WHERE (. IN ('')) AND node.nid = 2 in /home/olivier/honeypod.info/includes/database.mysql.inc on line 172.
* 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 'IN ('')) AND node.nid = 3' at line 1 query: SELECT count(node.nid) FROM honeypod_node node WHERE (. IN ('')) AND node.nid = 3 in /home/olivier/honeypod.info/includes/database.mysql.inc on line 172.
* 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 'IN ('')) AND node.nid = 4' at line 1 query: SELECT count(node.nid) FROM honeypod_node node WHERE (. IN ('')) AND node.nid = 4 in /home/olivier/honeypod.info/includes/database.mysql.inc on line 172.
* 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 'IN ('')) AND node.nid = 5' at line 1 query: SELECT count(node.nid) FROM honeypod_node node WHERE (. IN ('')) AND node.nid = 5 in /home/olivier/honeypod.info/includes/database.mysql.inc on line 172.

And the selected theme (garland) is not displayed.

When I'm disabling the module, I don't get any warnings anymore.

I disabled than uninstall the module. Check if the {view_theme} table is removed (it's not), I'm deleting it. Reinstalling the module,I still get the warning message.

Using Drupal 5.1, all module up to date. View - Theme of 2007 june 19th

Hope this helps.

 
 

Drupal is a registered trademark of Dries Buytaert.