User warning: unknown column [#495764]

Anaonymous visitors get this warning on most pages:

     * user warning: Unknown column 'n.type' in 'where clause' query: SELECT nid, title FROM node WHERE (( CASE n.type WHEN 'stormexpense' THEN 0 WHEN 'storminvoice' THEN 0 WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormperson' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN 0 WHEN 'stormtimetracking' THEN 0 ELSE 1 END )=1 ) AND ( type = 'blog' AND status = 1 AND created < 1244502789 )ORDER BY created DESC LIMIT 0, 1 in [mysite]/themes/plainscape/template.php on line 231.
     * user warning: Unknown column 'n.type' in 'where clause' query: SELECT nid, title FROM node WHERE (( CASE n.type WHEN 'stormexpense' THEN 0 WHEN 'storminvoice' THEN 0 WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormperson' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN 0 WHEN 'stormtimetracking' THEN 0 ELSE 1 END )=1 ) AND ( type = 'blog' AND status = 1 AND created > 1244502789 )ORDER BY created ASC LIMIT 0, 1 in [mysite]/themes/plainscape/template.php on line 253.

I'm no coder, so unfortunately I'm not able to do any troubleshooting on my own. I've run update.php and cleared the cache. Also, I did a search of the issue queue and didn't find any similar errors that didn't say they weren't already fixed.

Comment	File	Size	Author
#8	template.php_.zip	3.34 KB	kong

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

tiyberius CreditAttribution: tiyberius commented 19 June 2009 at 15:00

I'm getting this too! I restarted the server, cleared the caches, run update.php ... no luck.

Comment #2

Magnity CreditAttribution: Magnity commented 20 June 2009 at 12:15

Are you both using the theme plainscape or a different one?

Comment #3

Magnity CreditAttribution: Magnity commented 23 June 2009 at 09:48

Status:

Active

» Postponed (maintainer needs more info)

(Changed Status - Awaiting more info)

Comment #4

Magnity CreditAttribution: Magnity commented 26 June 2009 at 08:22

Project:	Storm	» Plainscape
Component:	Storm.module	» Code
Status:	Postponed (maintainer needs more info)	» Active

I have had a look through this issue, and believe that it is caused by the SQL queries done by the theme functions in template.php of Plainscape. These call the rewrite sql function (which Storm hooks into for access management), and conflicts with the labelling of the node table by Storm n.

The easiest resolution would I think be if Plainscape could label the table n also even though there is only one db table used in each query.