Error on line 166 in i18noverview.module
drq - April 30, 2008 - 06:44
| Project: | Internationalization |
| Version: | 6.x-1.x-dev |
| Component: | Experimental modules |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
I tried Translation Overview module. On pages of a language overview as
admin/content/translation_overview/zh-hans get error
* user warning: Table node' doesn't exist query: SELECT COUNT(*) FROM node n LEFT JOIN node nt ON n.nid = nt.tnid AND nt.language = 'ru' WHERE n.type IN ('ru') AND ((n.nid = n.tnid OR n.tnid = 0) AND (n.language != '')) in /public_html/db/sites/all/modules/i18n/i18noverview/i18noverview.module on line 166.
* user warning: Table 'node' doesn't exist query: SELECT n.nid, n.title, n.type, n.language, n.status, n.created, n.tnid, nt.nid AS t_nid, CASE WHEN n.language = 'ru' THEN '4 LOCAL' WHEN nt.translate = 0 THEN '3 DONE' WHEN nt.tnid IS NULL THEN '2 MISS' WHEN n.nid = n.tnid THEN '1 OLD' ELSE 'unknown' END AS translation_status, 0 AS i18n FROM node n LEFT JOIN node nt ON n.nid = nt.tnid AND nt.language = 'ru' WHERE n.type IN ('firm') AND ((n.nid = n.tnid OR n.tnid = 0) AND (n.language != '')) ORDER BY translation_status ASC LIMIT 0, 30 in /public_html/db/sites/all/modules/i18n/i18noverview/i18noverview.module on line 166.This errors only for site with many languages and database prefix.
Change all table name in queries from node to {node}
#1
good catch.
#2
oh, i've got commit access...
#3
Automatically closed -- issue fixed for two weeks with no activity.