Presta 1.4.0.9 deleting error in subCMS Category in CMS Category "Home"

[Radi]

After installing clean presta 1.4.0.9 in tools -> cms I add new subcms category is present in BO but not show in FO. I use blockcms to show in FO cms pages but subcms page show only name and empty decription, category home show names and descriptions of pages properly.

I use define('_PS_DEBUG_SQL_', true); $start_time = microtime(true); in config.inc.php and try delete subcms category now in BO presta show:

Unknown column 'id_category' in 'where clause'

SELECT `id_cms_category`

FROM `ps_cms_category`

WHERE `id_parent` = 2 AND `id_parent` != `id_category`

 

Can anybody help ?

Edited September 5, 2012 by Radi (see edit history)

[Dovitch]

I've had the same error last week!

In file 'CMSCategory.php' from '/classes/CMSCategory.php' at line 230, replace:

!= 'id_category',by !='id_cms_category'.

Here is tested that the category you are trying to delete is not the root category.

I don't know if this bug is already fixed but it's quiet complicated not to be able to delete a cms category ...

[Radi]

Your solution work!

Thank you Dovitch

Edited October 9, 2012 by Radi (see edit history)