Post by vasudevelope » Mon Jan 06, 2014 6:19 pm

Extension Name : Enable / Disable Multiple Categories

Purpose of use : Enable / Disable Multiple Categories


I was install the "Enable / Disable Multiple Categories" extension in my website. In " Catalog >> Categories " admin page will show the following error and cannot work that extension natural

process of enable and disable process.

Notice: Undefined index: status in C:\wamp\www\eye\vqmod\vqcache\vq2-admin_controller_catalog_category.php on line 226

Solution :

(Main Solution was adding one field for : "status" field is missing adding this field you code it will be work properly)


1. Open the file following location C:\wamp\www\eye\vqmod\vqcache\vq2-admin_model_catalog_category.php

2. Go to Line : 228 find the following Query

Code: Select all

public function getCategories($data) {
		$sql = "SELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR ' > ') AS name, c.parent_id, c.sort_order FROM " . DB_PREFIX . "category_path cp 

LEFT JOIN " . DB_PREFIX . "category c ON (cp.path_id = c.category_id) LEFT JOIN " . DB_PREFIX . "category_description cd1 ON (c.category_id = cd1.category_id) LEFT JOIN " . DB_PREFIX . 

"category_description cd2 ON (cp.category_id = cd2.category_id) WHERE cd1.language_id = '" . (int)$this->config->get('config_language_id') . "' AND cd2.language_id = '" . (int)$this->config->get

('config_language_id') . "'";

3. Replace or Backup the current code

4. To replace with the following code

Code: Select all

public function getCategories($data) {
		$sql = "SELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR ' > ') AS name, c.status, c.parent_id, c.sort_order FROM " . DB_PREFIX . 

"category_path cp LEFT JOIN " . DB_PREFIX . "category c ON (cp.path_id = c.category_id) LEFT JOIN " . DB_PREFIX . "category_description cd1 ON (c.category_id = cd1.category_id) LEFT JOIN " . 

DB_PREFIX . "category_description cd2 ON (cp.category_id = cd2.category_id) WHERE cd1.language_id = '" . (int)$this->config->get('config_language_id') . "' AND cd2.language_id = '" . (int)$this-

>config->get('config_language_id') . "'";
5. Problem was solved.[/color]

Thanks & Regards
Vasu.G
Web Developer & Designer


User avatar
Newbie

Posts

Joined
Sat Jan 04, 2014 2:52 pm

Post by raj79 » Sun Jul 13, 2014 3:55 pm

hello !

we are using opencart Version 1.5.6.4 for apnakiranastore.com where we have installed Enable / Disable Multiple Categories from http://www.opencart.com/index.php?route ... rudacrafts .


Please resolve my issue...

Attachments

Screenshot_2.png

Screenshot_2.png (120.76 KiB) Viewed 1942 times


Online Grocery shopping in delhi


New member

Posts

Joined
Fri Jun 06, 2014 3:57 pm
Location - Delhi

Post by garuda » Sun Jul 13, 2014 11:37 pm

Enable / Disable Multiple Categories is compatible with OpenCart v1.5.4.x and does not yet work on OpenCart v1.5.5.x+. This is stated in the extension documentation, comments, compatibility field, and even noted in the filename (...-154.xml"). I will create a version to support v1.5.5.x an v1.5.6.x and upload it by the end of next week.

New member

Posts

Joined
Wed Apr 25, 2012 10:40 am

Post by raj79 » Mon Jul 14, 2014 9:15 am

how will inform us when new version will be released ?

Online Grocery shopping in delhi


New member

Posts

Joined
Fri Jun 06, 2014 3:57 pm
Location - Delhi
Who is online

Users browsing this forum: No registered users and 7 guests