[SOLVED] Categories disappeared from BO

[Luk3]

I have a serious problem, dont know what to do:-( Suddenly, categories disappeared from BO, I can not create a new category (error: can not create object category ()) But! Categories are all right in database, Home categori with ID 1 is not missing, FO shows categories all right (no in blockcategories). This works normally:

 

http://www.domain.com/admin/index.php?tab=AdminCatalog&id_category=5

 

After PHP errors logging it showed two of them:

 

1) classes/Category.php

 

$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `'._DB_PREFIX_.'category` c
LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.(int)($id_lang).')
LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = '.(int)($this->id).'
'.($active ? 'AND `active` = 1' : '').'
AND cg.`id_group` '.$sqlGroups.'
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, c.`position` ASC');

 

doesnt work...

 

2) JBX menu menu.class.php

 

$_childrens = Category::getChildren($id_category, $id_lang);

 

doesnt work...(inputs are OK)

 

next, I did refresh ntree with Category::regenerateEntireNtree() - it works OK but didnt help. Please, what can I do next???

[Mike Kranzler]

Hi Luk3,

I see that you've already added this to our bug tracker. I will be sitting down with a developer this afternoon and will see if we can fix this for you then. If you could in advance of this meeting, please send me a PM with your FTP, Back Office and mySQL login information so that we can try to take care of this as quickly as possible.

 

-Mike

[Mike Kranzler]

Hi Lukas,

We have fixed this issue for you and posted more information about it on the Forge. It appears that you were missing an important column in one of your tables in the database. I hope this helps!

 

-Mike

[Luk3]

That is great! Thank you very much for your time and good work!

 

BTW, Interesting thing is, I did not do any update. Therefore, I have a suspicion that one of my modules (maybe made for older version of Prestashop or just poorly coded) did it during writing to database. As soon as i know which one, I write it here.

[Mike Kranzler]

Great! I'm glad we could help. We'll definitely be interested to hear what module might have been causing you these issues, but in the meantime, I'll go ahead and mark this as solved for you.

 

-Mike