Categories not showing in Admin>Catalog>Category

General Support for technical Issues relating to AlegroCart
Post Reply
Istrian
Posts: 2
Joined: Sat Aug 24, 2013 9:03 pm

Categories not showing in Admin>Catalog>Category

Post by Istrian » Sat Aug 24, 2013 9:32 pm

Hi, I have just recently installed Alegrocart 1.2.8 on my local server. Win8 Pro with Apache 2 PHP 5.2.5 What a fantastic shopping cart!

For the first time today I noticed that the Admin >Catalog > Category page is blank. It tells me that there are 6 categories but nothing else shows up. Also I am getting the following error message every couple of minutes
MySQL Error: Unknown column 'c.category_hide' in 'field list'
Error No: 1054
select c.category_id, cd.name, i.filename, c.category_hide, c.sort_order from category c left join category_description cd on (c.category_id = cd.category_id) left join image i on (c.image_id = i.image_id) where c.parent_id = '0' and language_id = '1' order by cd.name asc limit 0, 20
Path: /xampp/mary/reginae/?controller=category
Query String: controller=category

The 6 categories show up in the OnLine Shop side and I can add new products to categories in Admin> Catalog> Product.
What have I done wrong?

Many thanks for any help received.
Attachments
categories.jpg
categories.jpg (52.85 KiB) Viewed 18195 times

User avatar
leo
admin
Posts: 4320
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Categories not showing in Admin>Catalog>Category

Post by leo » Sat Aug 24, 2013 11:30 pm

Run this SQL query on your database:

Code: Select all

# Add hide Category
ALTER TABLE `category` ADD `category_hide` int(1) NOT NULL default '0' After `sort_order`;

# Add hide Information
ALTER TABLE `information` ADD `information_hide` int(1) NOT NULL default '0' After `sort_order`;

Istrian
Posts: 2
Joined: Sat Aug 24, 2013 9:03 pm

Re: Categories not showing in Admin>Catalog>Category

Post by Istrian » Sun Aug 25, 2013 2:03 am

Leo, thank you so much. You fixed the problem.
Once again many thanks.

hounaine
Posts: 3
Joined: Fri Feb 07, 2014 3:21 pm

Re: Categories not showing in Admin>Catalog>Category

Post by hounaine » Mon Feb 10, 2014 7:55 am

Same. Thank you Leo.

rama_gatez
Posts: 2
Joined: Mon May 04, 2015 6:49 am

Re: Categories not showing in Admin>Catalog>Category

Post by rama_gatez » Wed May 13, 2015 8:38 pm

leo can you explain the detail how to show category not appear in the list ??

where i must run this ?? database.php (upload>library>database>database.php)
because i still beginner in mysql

# Add hide Category
ALTER TABLE `category` ADD `category_hide` int(1) NOT NULL default '0' After `sort_order`;

# Add hide Information
ALTER TABLE `information` ADD `information_hide` int(1) NOT NULL default '0' After `sort_order`;

User avatar
leo
admin
Posts: 4320
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Categories not showing in Admin>Catalog>Category

Post by leo » Thu May 14, 2015 3:58 am


Post Reply