Initial Setup: "None of the parent categories are live"

Posted By alister cruickshanks Mon 25 Mar 2013
Add to Favorites0
Author Message
alister cruickshanks
 Posted Mon 25 Mar 2013
Supreme Being

Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)

Group: Awaiting Activation
Last Active: Mon 30 Sep 2013
Posts: 0, Visits: 19
I have just installed the new version 2.0, as a clean install, WITHOUT sample data,

Everything seems to be setup correctly, but when I add the FIRST category, the error
"None of the parent categories are live" occurs.

Of course, I cannot add a parent category because this is the first category being added.

I have tried;

"Using the clear data tool", to wipe all data
"Manually checking all table data to ensure no categories, products, versions and language link elements are present".

The problem occurs every time I add a category and in spite of re-clearing data, it always occurs.

ALSO....

The category does get saved, but is not visible in the category backend list. To find it, you have to use search for it to appear. Otherwise, it will show "no categories listed".

Editing the category again will result in the same error message.

Trying to add a second category, then adding the first as a parent also shows the error.

The Category hierarchy table never fills in any details when adding a new category, which I suspect is why they are not appearing.

ADDITIONAL....

I have just tried reseeding the table which forces the next entry to start from 0. Zero;
USE TABLENAME;
GO
DBCC CHECKIDENT("dbo.tblKartrisCategories", RESEED, -1)
GO



This lets me add an initial category WITHOUT the parent error...however, subsequently adding further categories fails to solve the problem.

Kind Regards
Alister


Mon 25 Mar 2013 by alister cruickshanks
Paul
 Posted Mon 25 Mar 2013
große Käse

große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)

Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807, Visits: 2,748
Yes, I've reproduced this too... we did have this issue before with completely blank db and was fixed. I've opened a bug track on it.

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Paul
 Posted Mon 25 Mar 2013
große Käse

große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)

Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807, Visits: 2,748
I noticed there is a zero ID record in the categories table; i think this is related...

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Paul
 Posted Mon 25 Mar 2013
große Käse

große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)große Käse - (523,298 reputation)

Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807, Visits: 2,748
Medz checked in a fix on codeplex:

http://kartris.codeplex.com/SourceControl/changeset/22673


--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
alister cruickshanks
 Posted Mon 25 Mar 2013
Supreme Being

Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)Supreme Being - (1,439 reputation)

Group: Awaiting Activation
Last Active: Mon 30 Sep 2013
Posts: 0, Visits: 19
Thank you Paul

The suggested additional code works perfectly.

Kind Regards
Alister Cruickshanks

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top