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.
Categories not showing in Admin>Catalog>Category
Categories not showing in Admin>Catalog>Category
- Attachments
-
- categories.jpg (52.85 KiB) Viewed 18208 times
Re: Categories not showing in Admin>Catalog>Category
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`;
Re: Categories not showing in Admin>Catalog>Category
Leo, thank you so much. You fixed the problem.
Once again many thanks.
Once again many thanks.
Re: Categories not showing in Admin>Catalog>Category
Same. Thank you Leo.
-
- Posts: 2
- Joined: Mon May 04, 2015 6:49 am
Re: Categories not showing in Admin>Catalog>Category
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`;
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`;