White page + SQL error...

[ProfWer]

i have problem...
http://xlia.profwer.com

I see only text:

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 ')' at line 4


       SELECT c.id_cms, cl.link_rewrite, cl.meta_title
       FROM ps_cms c
       LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
       WHERE c.id_cms IN ()

in PA it's ok!
I use Prestashop 1.2.1

[CYTechnologies]

The issue is with the blank IN command

WHERE c.id_cms IN ()

Did you remove any CMS pages recently?

[ProfWer]

I did'nt remove anything.... maybe I have to activate something? (how?)

// edit
solved... I had empty page in CMS, w write 3 pages in PA and it's ok....

[cathymarc]

SOLVED: my fault, I have a .eu domain for german, this was not setting ISO_lang properly

I have same problem (and so do many others, from what I see on forum, and no solution).

In my case, I have a multilingual installation on Apache. I use Friendly URLs, and I made some mods to allow different domain names for each language: the only mods I made are on .htaccess, on Tools.php and on Link.php.

Site works in French and Spanish, but not in German where I get

SELECT c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 0)
WHERE c.id_cms IN ()

I have made no changes to CMS.

Can you give us some hint as to where this query is being executed from?

thanks

Mike