Getting this error when using indepage module with drupal 5.7 and the recommended 5.x module:

; $Id: README.txt,v 1.1.2.1 2008/05/12 15:56:41 nancyw Exp $

user warning: Unknown column 'warcraft_warcraftdojo.t.vid' in 'on clause' query: SELECT COUNT(*) FROM node n LEFT JOIN term_node t USING (nid) INNER JOIN node_revisions r USING (nid, vid) WHERE type='story' AND t.tid=1 in /home/warcraft/public_html/includes/database.mysql.inc on line 172.
user warning: Unknown column 'warcraft_warcraftdojo.t.vid' in 'on clause' query: SELECT n.*, r.teaser FROM node n LEFT JOIN term_node t USING (nid) INNER JOIN node_revisions r USING (nid, vid) WHERE type='story' AND t.tid=1 ORDER BY title ASC LIMIT 0, 10 in /home/warcraft/public_html/includes/database.mysql.inc on line 172.
warning: Invalid argument supplied for foreach() in /home/warcraft/public_html/includes/theme.inc on line 786.
warning: Invalid argument supplied for foreach() in /home/warcraft/public_html/includes/theme.inc on line 811.

Comments

jblnyc’s picture

jblnyc commented
Title: Unknown column error » Unknown column error in indexpage module on drupal 5.7
Category: support » bug
nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Assigned: Unassigned » nancydru
Status: Active » Postponed (maintainer needs more info)

Hmm, I'll need to look at the code, but I think I see the problem. Let me take a wild guess here: You're using MySql 4.x?

Are you also using i18n by any chance?

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Postponed (maintainer needs more info) » Fixed

I just committed a change that I think will fix this. It isn't happening on my site (MySql 5.0.22), so you'll have to let me know if it takes care of it for you. This will be in the 5.x-1.x-dev release that will roll out around midnight GMT (8pm ET).

jblnyc’s picture

jblnyc commented

Thanks! I tested the fix on my system and it works like a champ. I am using MySQL 4.x but that's just because my hosting provider doesn't offer 5.x yet. :)

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

Great. Thanks for letting me know.

BTW, Drupal 7 (due this summer) requires MySql 5+ and PHP 5.2+. Time to get your host off their duffs, or find a new host.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Fixed » Closed (fixed)