Error Modulo Cms

[JCMM]

Buenos días,

 

Al entrar en el modulo CMS me sale este error.... 

 

Champ 'ccl.id_shop' inconnu dans where clause

 

SELECT bc.`id_cms_block`, bcl.`name` block_name, ccl.`name` category_name, bc.`position`, bc.`id_cms_category`, bc.`display_store`
            FROM `ps_cms_block` bc
            LEFT JOIN `ps_cms_block_shop` bcs
            ON (bcs.id_cms_block = bc.id_cms_block)
            INNER JOIN `ps_cms_category_lang` ccl
            ON (bc.`id_cms_category` = ccl.`id_cms_category`)
            INNER JOIN `ps_cms_block_lang` bcl
            ON (bc.`id_cms_block` = bcl.`id_cms_block`)
            WHERE ccl.`id_lang` = 1
            AND bcl.`id_lang` = 1
            AND bc.`location` = 0 AND ccl.`id_shop` = 1
            AND bcs.id_shop = 1
            ORDER BY bc.`position`

 

¿sabe alguien porque?

 

Saludos y gracias

[hoover91]

Hi JCMM?

 

I think i've a similar problem, if someone can help us, it will be great, thanks.

 

For me it's "id_shop" inconnu dans where clause. SELECT * FROM ps_cms_category_lang WHERE "id_cms_category"= 1 an "id_shop"= 1.

But I HAVE this on my DB so...

 

thanks again.