Categories do not show on homepage

[Kalash.sm]

Hello,

I have a problem with product categories tab. I deleted the default group as I wanted to add another group and after I deleted I cant see product category tab on my homepage. I tried to make another group and named it default but still doesnt help. I also tried uninstalling and installing the category tab in modules but nothing works at all. Please if someone have the same problem and found the solution please let me know. I am also trying to solve this problem by my own and continuously trying to work on it. If i find the solution I will post here. Thanks for the help in advance. waiting for someone to help.

[JAKCRABBIT]

You need in DB insert this:

INSERT INTO `ps_category` (`id_category`, `id_parent`, `level_depth`, `active`, `date_add`, `date_upd`) VALUES 
(1, 0, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

[kurniawanchan]

You need in DB insert this:

INSERT INTO `ps_category` (`id_category`, `id_parent`, `level_depth`, `active`, `date_add`, `date_upd`) VALUES 
(1, 0, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

hello kalash.sm

I'm also having the exact problem as yours.

In addition to jakcrabbit solution, you will also need to run this query in phpmyadmin:

INSERT INTO `YOUR_DB`.`ps_category_group` (`id_category` ,`id_group`) VALUES ('1', '1');

that should give access the home category to default group and also display on homepage.

thanks
Chan

[David.dee]

Great! Thank you for solution. I deleted default group too, so thank you. You saved my time. :-)

[webnews]

Hi

I am new in making changes in the db, so I have deleted the categori called: ps_category - Now I can not create it again.

PLEASE HELP

I have tryed to copy/paste this code:

INSERT INTO `ps_category` (`id_category`, `id_parent`, `level_depth`, `active`, `date_add`, `date_upd`) VALUES (1, 0, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); 

Into the QXL, but I am not able to create the db: ps_category again

Is someone able to help me create a code that I can simple copy/paste into the SQL (please view the attached picture I added), so that It will create the db: ps_category again with the values it´ll need to function.

I realy hope someone can help me with this one.
Thanks

[webnews]

I mean some code created like this one.

CREATE TABLE `PLD` (
 `ID` int(11) NOT NULL auto_increment,
 `TITLE` varchar(255) NOT NULL default '',
 `CACHE_TITLE` text,
 `TITLE_URL` varchar(255) default NULL,
 `CACHE_URL` text,
 `DESCRIPTION` longtext,
 `PARENT_ID` int(11) NOT NULL default '0',
 `STATUS` int(11) NOT NULL default '1',
 `DATE_ADDED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
...

INSERT INTO `PLD` VALUES (1, 'Arts', 'Arts', 'Arts', 'index.php?c=1', '', 0, 2, '2007-, '');
INSERT INTO `PLD` VALUES (2, 'Business', 'Business', 'Business', 'index.php?c=2'01', 264,);
INSERT INTO `PLD` VALUES (3, 'Computers and Internet', 'Computers aernet', 'Compd_I ...);
INSERT INTO `PLD` VALUES (4, 'Games', 'Games', 'Games', 'index.php1', 88, 0, 0, '', '');
INSERT INTO `PLD` VALUES (5, 'Health', 'Health', 'Health', 'index.php?c=5'', 170, 0,, '');
INSERT INTO `PLD` VALUES (6, 'Home', 'Home', 'Home', 'index.php?c=6', '', 0, 0, '', '');
INSERT INTO `PLD` VALUES (7, 'Kids and Teens', 'Kids and Teens', 'Kids_and_Tee2-22 12:46 ...);
INSERT INTO `PLD` VALUES (8, 'News', 'News', 'News', 'index.php?c=8, 53, 0, 0, '', '');
INSERT INTO `PLD` VALUES (9, 'Recreation', 'Recreation', 'Recreati007-02-25 151', 118,  ...);

...

I realy hope it makes sence.
Thanks

[webnews]

Hi

I found the solution myself. Here it is if anyone els have this problem.
Just copy/paste this code into the SQl data base inside the phpMyAdmin

--
-- Table structure for table `ps_category`
--

CREATE TABLE `ps_category` (
 `id_category` int(10) unsigned NOT NULL auto_increment,
 `id_parent` int(10) unsigned NOT NULL default '0',
 `level_depth` tinyint(3) unsigned NOT NULL default '0',
 `active` tinyint(1) unsigned NOT NULL default '0',
 `date_add` datetime NOT NULL default '0000-00-00 00:00:00',
 `date_upd` datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (`id_category`),
 KEY `category_parent` (`id_parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=74 ;

--
-- Dumping data for table `ps_category`
--

INSERT INTO `ps_category` VALUES(1, 0, 0, 1, '2008-07-17 17:35:13', '2008-07-17 17:35:13');
INSERT INTO `ps_category` VALUES(2, 1, 1, 1, '2008-10-19 01:37:30', '2008-10-19 01:37:30');
INSERT INTO `ps_category` VALUES(3, 1, 1, 1, '2008-10-19 01:37:31', '2008-10-19 01:37:31');
INSERT INTO `ps_category` VALUES(4, 1, 1, 1, '2008-10-19 01:37:32', '2008-10-19 01:37:32');
INSERT INTO `ps_category` VALUES(5, 1, 1, 1, '2008-10-19 01:37:33', '2008-10-19 01:37:33');
INSERT INTO `ps_category` VALUES(6, 1, 1, 1, '2008-10-19 01:37:34', '2008-10-19 01:37:34');
INSERT INTO `ps_category` VALUES(7, 1, 1, 1, '2008-10-19 01:37:40', '2008-10-19 01:37:40');
INSERT INTO `ps_category` VALUES(8, 1, 1, 1, '2008-10-19 01:37:42', '2008-10-19 01:37:42');
INSERT INTO `ps_category` VALUES(9, 1, 1, 1, '2008-10-19 01:37:44', '2008-10-19 01:37:44');
INSERT INTO `ps_category` VALUES(10, 1, 1, 1, '2008-10-19 01:37:46', '2008-10-19 01:37:46'); 

I hope it helps.
Thanks

[muktadir]

copy the sql for that table from a working prestashop installation having exactly the same version! it may cause you further troubles if you don't recreate the table with the exact version. if you fail to do it yourself, you can hire me.