This is going to be rather difficult to explain, but here goes:
We have created 10000 articles for our Knowledgebase, all pre-numbered so we can continue our naming/numbering scheme. These articles have no label, so are not included when we search from the front-end of the space.
When a user wants to create a new article, they are 'given' the next article in order and then changes the name and content. The link to the article adds the kbdraft label.
When the user is ready to publish, they click the publish button. This is where the problem arises.
For some reason, when we attempt to remove the kbdraft label and add the kb label through the SQL database, the system doesn't see the changes until we restart the server.
What we want to happen is:
1. The labels are changed, taking it from the draft state to the published state.
2. The publish button goes away.
3. There needs to be a system to back out, to return the page to the template state and remove all labels.
4. The people watching the space should be notified when someone publishes an article.
Any help on any of this? I have been working on this for so long that I can't keep it straight in my own head.
