Nucleus Support :: View topic - NP

Nucleus CMS FAQ:

« »

Loading Nucleus FAQ ticker...

View previous topic :: View next topic

Author

Message

localaccent
Nucleus Newbie

Joined: 08 Jan 2010
Posts: 6

Posted: Fri Jul 30, 2010 8:16 pm Post subject: NP_Admin does not work

I have NP_Admin on my blogs, and I want to combine two of the blogs into one. I tried to copy an item from one blog to the other. It shows up in the list on the second blog, but does not publish. I have tried going into it and editing it, changing the category, etc., still does not show up. Can you help me?

ftruscot
Nucleus Guru

Joined: 22 Feb 2006
Posts: 7449
Location: Massachusetts

Posted: Fri Jul 30, 2010 10:33 pm Post subject:

I'm not familiar with that plugin.

You can move items by just changing the category of each item from the normal edit item form.

Alternatively, if there are a lot of items, you could run queries in mysql that change the iblog and icat columns for each item all at once (or using a few queries depending on how you were mapping the categories). Something like this if you are moving everything in blog 2 into blog 1 and mapping category 5 with category 1 and category 6 with category 3. Two queries to run in phpmyadmin or whatever you use to manage the mysql db:

Code:

UPDATE nucleus_item SET iblog=1, icat=1 WHERE icat=5

Code:

UPDATE nucleus_item SET iblog=1, icat=3 WHERE icat=6

or even easier, keep the categories but move them to blog 1, then just run these two queries:

Code:

UPDATE nucleus_item SET iblog=1 WHERE iblog=2

Code:

UPDATE nucleus_category SET cblog=1 WHERE cblog=2

If you have comments, it gets a little more complicated, but you can just change them all to have cblog=1 like this:

Code:

UPDATE nucleus_comment SET cblog=1 WHERE cblog=2

Of course these all assume that you are doing away with blog 2 and moving all items into blog 1. If you are merging just some of the items, you'll need to be more careful. I'd be happy to review any queries you make before you run them. Should go without saying that you'll want to make a backup before you do any of it.
_________________
Is your question not solved yet?
Search our FAQ,
read the Documentation, or
browse the list of available plugins.

Check out my plugins

localaccent
Nucleus Newbie

Joined: 08 Jan 2010
Posts: 6

Posted: Mon Aug 02, 2010 5:36 pm Post subject:

Sorry, I gave you an incorrect name for the plugin before, it is NP_AdmTools.php, found here, http://wakka.xiffy.nl/admtools. Its sole state purpose is to do this: Allows items to be duplicated (copied) from one blog to another.

This is the plug-in that is not working for me. Unfortunately, your first suggestion, which should also work, does not work either, to simply change the item by changing the category. I can see all the categories but it does not move the item. I do not have access to queries in mysql, and this week with all the other changes to our website I can't ask the developer to do this as well. If you can't think of any other way to do this I will probably have to do a cut and paste.

The weird thing is, my test item did move into the items section of the other blog, but even if I edit it there, change the category, whatever, it does not show up in the published blog.

ftruscot
Nucleus Guru

Joined: 22 Feb 2006
Posts: 7449
Location: Massachusetts

Posted: Mon Aug 02, 2010 5:42 pm Post subject:

maybe the issue isn't with the move to the new blog, but with a display issue. Can I see a link to the site with some info about where the moved items should be seen?
_________________
Is your question not solved yet?
Search our FAQ,
read the Documentation, or
browse the list of available plugins.

Check out my plugins

Nucleus Support Forum Index -> Plugin Announce -> NP_Admin does not work

Page 1 of 1

All times are GMT + 1 Hour

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum