Categories problem

[jafmolina]

Hi

 

I am really worried about one problem that i have found after install the new prestashop 1.6

I can´t  modificate the categories ,add a new category or change the position or any category. i can´t select a category for a new product neither.

 

I send a picture about the problem. Please help. How i can fix it?

 

Thanks

[flashmovar]

I have the same problem. I hope somebody can help us.

[Alex Simonchik BelVG]

Hi,

 

this is fresh install of PrestaShop or upgrade from previous version? Can you provide your js console log?

 

Regards

[vekia]

turn on error reporting,

then try to save category

it will spawn errors probably

[flashmovar]

Upgrade from 1.5. When upload a product the categories are there, but in categories menu they disappear as shown in the picture above.

[Alex Simonchik BelVG]

Follow the guide from Vekia, seems any errors appear

[jafmolina]

thanks a lot for your coment.

 

I send down the text that appear  on  " turn on error reporting "

 

[PrestaShopDatabaseException]

Table 'gourmetc_ps18q29.ps_pk_customlink' doesn't exist
 

SELECT b.`id_pk_customlink`, b.`url`, b.`new_window`				FROM `ps_pk_customlink` b

at line 635 in file classes/db/Db.php

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. 		}631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. 		{633. 			if ($sql)634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. 			throw new PrestaShopDatabaseException($this->getMsgError());636. 		}637. 	}638. 639. 	/**

 

 

• DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 138 - modules/pk_customlinks/pk_customlinks.php] - [1 Arguments]
• pk_customlinks->getLinks - [line 77 - modules/pk_customlinks/pk_customlinks.php]
• pk_customlinks->hookTop - [line 509 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 444 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]
• IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

 

 

[Alex Simonchik BelVG]

Hi,

 

 [line 77 - modules/pk_customlinks/pk_customlinks.php] - there is string from your error log, seems that this module doesn't updated successfully. You can disable it and try without it.

 

Regards

[flashmovar]

How did you get this error report? I turned define('_PS_MODE_DEV_', false); to "true" in defines.inc.php but didn't show me such report.

Edited April 24, 2014 by flashmovar (see edit history)

[Alex Simonchik BelVG]

Hi flashmovar, maybe this link will help you: http://blog.belvg.com/showing-php-and-sql-errors-and-debugging-a-blank-white-page-in-prestashop.html

[flashmovar]

I switch on debug mode, but nothing happend. What should I see?

 

config/defines.inc.php

 

 

/* Debug only */

define('_PS_MODE_DEV_', true);

/* Compatibility warning */

define('_PS_DISPLAY_COMPATIBILITY_WARNING_', false);

if (_PS_MODE_DEV_)

{

@ini_set('display_errors', 'on');

@error_reporting(E_ALL | E_STRICT);

define('_PS_DEBUG_SQL_', true);

}

else

{

@ini_set('display_errors', 'off');

define('_PS_DEBUG_SQL_', false);

}

 

define('_PS_DEBUG_PROFILING_', false);

define('_PS_MODE_DEMO_', false);

[vekia]

now check your website, you should see message if there is any error.

message like you can see several posts above.

[flashmovar]

Website checked, cache cleared, but no errors, no warnings, no notice. I reinstalled caregories block, but nothing happend. When I upload a product, categories are there, but in categories managebment it is blank.

[flashmovar]

I have the solution

 

Here it is: http://nerdia.net/2013/08/30/prestashop-categories-block-empty-after-migrating-from-oscommerce/

 

I did not migrated, but this solved my problem. I hope it helps another people.

 

Solution: 

1. You need to access the PrestaShop MySQL databas using phpMyAdmin.
2. Open the table ps_categories. The id_category 1 is the root category. Find which id the home category has (it will have the field is_root_category set to 1). The home category is probably id_category 2.
3. Open the table ps_configuration and find the key PS_ROOT_CATEGORY and make shure it has value ’1′ (the id_category of the root category).
4. Find the key PS_HOME_CATEGORY and make shure it has the value of id_category for the home category, probably ’2′.
5. Go to the back office, in the preferences menu go to the general settings. Activate multi store.
6. In the advanced parameters menu, go to Multi store. 
7. Click on the default group and edit your store. Select the Home category as Root category. Save the store.
8. Go back in the preferences menu general settings and disable the multi store.

Edited April 24, 2014 by flashmovar (see edit history)