Category tree import

Post

Posted
Rating:
#5897 (In Topic #1406)
Avatar
Standard member
walterhpdx is in the usergroup ‘Fan in training’
I'm building out Composr and everything works but one. I built out parent categories (Movies, TV Series, Literature, etc) and then figured out what table on the backend held the data, so I imported via SQL. I tried one as a trst and it worked fine. Then I imported 950ish under one parent category, which looked fine. But when I click on an imported category, i get 'An error has occurred. The requested catalogue does not exist. It has probably been deleted.'

Did I miss a table or something?  

From what I can tell this doesn't have an import tool, so I had to use straight SQL. 
Online now: No Back to the top

Post

Posted
Rating:
#5899
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Did you get the c_name column right when you imported into catalogue_categories? Should be the codename of the catalogue you are using.

There is a mass-create feature for catalogues actually, "Auto-fill with categories" on the add catalogue form.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#5900
Avatar
Standard member
walterhpdx is in the usergroup ‘Fan in training’
I did, yes. They are all set to 'link'.  I will try some things tomorrow.

I only need the skeleton, because the actual links will come from end users.
Online now: No Back to the top

Post

Posted
Rating:
#5901
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
It probably is offering you to see a stack trace, which will tell us where the error is being thrown from. Will likely be a huge clue.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#5902
Avatar
Standard member
walterhpdx is in the usergroup ‘Fan in training’
You were right about the c_name column.  I'd set all the imported things to 'link' when it should have been 'links'.  I just did an SQL update and that fixed it.  Thanks!
Online now: No Back to the top
1 guest and 0 members have just viewed this.
Back to Top