AlegroCart

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.

Run this SQL query on your database:

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

Same. Thank you Leo.

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`;

in http://localhost/phpmyadmin/