AlegroCart open source E-commerce
Web hosting by Host1Plus

Categories not showing in Admin>Catalog>Category

General Support for technical Issues relating to AlegroCart

Categories not showing in Admin>Catalog>Category

Postby 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 14649 times
Istrian
 
Posts: 2
Joined: Sat Aug 24, 2013 9:03 pm

Re: Categories not showing in Admin>Catalog>Category

Postby 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`;
User avatar
leo
admin
 
Posts: 4220
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Categories not showing in Admin>Catalog>Category

Postby Istrian » Sun Aug 25, 2013 2:03 am

Leo, thank you so much. You fixed the problem.
Once again many thanks.
Istrian
 
Posts: 2
Joined: Sat Aug 24, 2013 9:03 pm

Re: Categories not showing in Admin>Catalog>Category

Postby hounaine » Mon Feb 10, 2014 7:55 am

Same. Thank you Leo.
hounaine
 
Posts: 3
Joined: Fri Feb 07, 2014 3:21 pm

Re: Categories not showing in Admin>Catalog>Category

Postby 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`;
rama_gatez
 
Posts: 2
Joined: Mon May 04, 2015 6:49 am

Re: Categories not showing in Admin>Catalog>Category

Postby leo » Thu May 14, 2015 3:58 am

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


Return to General Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron