I get the following error whenever "i18n - content types" is enabled from the list of modules. I've found only on report on this case on this site: www.drupal.org.es/node/2192

# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172.
# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172.
# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172.
# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172.
# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172.
# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172.
# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172.
# user warning: Unknown column 'FALSE' in 'where clause' query: SELECT nt.type, nt.* FROM node_type nt WHERE (FALSE) ORDER BY nt.type ASC in /var/www/news/includes/database.mysql.inc on line 172

Comments

graffx’s picture

graffx commented

Just searched here an answer to the same problem, and I think I found it by myself - the problem is in one of the Multilanguage i18n experimental modules - probably in "i18n - content types" - after disabling this module the error message gone.
But I'd like to see it working too ) Somebody can help us with this?

jose reyero’s picture

jose reyero commented
Priority: Critical » Minor

This will be possibly related to mysql version and the word 'FALSE'. In mine, which is 5.0.24, it works.

This modules needs a lot more work though, and it's experimental, so I switch priority to minor.

moritzz’s picture

moritzz commented
Title: MySQL error "content types" » MySQL error "content types": A Patch?
Version: 5.x-2.0 » 5.x-2.1
Component: Code » Experimental modules
Priority: Minor » Normal
Status: Active » Needs review

According to the german source...

http://www.delphipraxis.net/topic26406_datensaetze+in+tabelle+schneller+...

... not every database seams to know the "WHERE FALSE" clause to return an empty row set. That's why delphipraxis.net uses "WHERE 0=1" instead of "WHERE FALSE". I'm not sure if I got it right, but after changing ...

"return array('where' => 'FALSE');"

... to ...

"return array('where' => '0=1');"

... on line 31 of "i18ncontent.module" everything seams to work.

If the developers of i18n could verify this, this may be a patch.

Have fun,
Moritz

jose reyero’s picture

jose reyero commented
Status: Needs review » Fixed

Thanks, applied the proposed solution here, seems to work.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.