Problem with Categories:: ROOT showing up as a category

[chartwell]

My boss logged in as admin last weekend and I'm not sure what she did, but somehow "ROOT" started showing up as one of the categories.

I've since deleted all of the categories and installed the latest patch. Thankfully, it is a new site that isn't live yet. But "ROOT" is still showing as one of the categories. See: http://new.mglinks.com

Thank you in advance for any help.

[Dave Baker]

Welcome to our forum chartwell!
Please send me PM with your ftp and Admin Panel credentials, I will try to help you.

[MootMop]

Welcome to our forum chartwell!
Please send me PM with your ftp and Admin Panel credentials, I will try to help you.

Hello all,

I'm having the same problem. Root is showing up as a category. Was this problem solved. If yes, please list the steps I need to take to fix this. Thank you.

[compucast]

Thank you, Dave... not sure if anything was yet done as it is not yet showing up. I am the one who managed categories through the admin panel when root showed up.

After deleting the root category which was not there before ... using the given delete button.. the "Requested URL not found (404)" error shows up.

I have found the forum with the instructions to correct this bug --
http://www.esyndicat.com/forum/post60862-12.html -- but the admin does not allow me to make those changes, and I do not want to go directly into the code.

This is a brand new version with the patch. Please help.

[Sergey Ten]

Hello compucast,

Seems to me I have fixed your problem. Please check it.

[Dave Baker]

@MootMop
Please try to execute this query via Admin Panel or phpMyAdmin:

UPDATE `v2102_categories` SET `id` = '0', `id_editor` = '0', `id_parent` = '-1' WHERE `title` = "ROOT" LIMIT 1 ;

v2102_ - change to your database prefix.
Please do not forget to make database backup.

@compucast
If you still have problem please send me PM with your Admin Panel/Database credentials.
Or try to execute the following queries via phpMyAdmin:

INSERT INTO `v2102_categories` (`id`, `id_editor`, `id_parent`, `title`, `description`, `status`, `meta_description`, `meta_keywords`, `path`, `order`, `locked`, `unique_tpl`, `level`, `num_cols`, `neighbour`, `num_links`, `num_all_links`) VALUES (0, 0, -1, 'ROOT', 'eSyndicat directory software', 'active', 'eSyndicat directory software', 'eSyndicat directory software', '', 0, '0', '0', 0, NULL, NULL, 0, 0);

and

UPDATE `v2102_categories` SET `id` = '0'WHERE `title` = "ROOT" LIMIT 1 ;

v2102_ - change to your database prefix and do not forget to make database backup.