Subject Beta2 Questions
Posted by Christa (Member)
Posted on 8-Dec-00 08:15 PM


Hello there

I have been playing with the new version for a while it looks great. I still have few questions for now:
1- How do you access the editors database and assign categories to them?
2- How do you create alt category? ( I wanna place some links in different category without having a dublicate link showing up).
3- Alex mentioned in a previous thread that the editor name tag will be available in the SQL 2 templetes, I could not find the right one yet.
4- Is there a way in add.cgi to make the drop down menu of categories available to choose from.
I mean that the user does not have to be in the exact directory to add his/her link.

That is all what i have so far.
Another issue some of my user are having is recieving an error message:

Unable to auto-create user: username. Reason: The column 'Status' must be unique, and already has an entry 'Not Validated'.
Please enable debugging in setup for more details.

any idea what is this? It only comes with registered users.

Thanks

Regards
Christa

1- How do you access the editors database and assign categories to them?

Good question :) Might not be ready yet. I have a vague memory of that being a plug-in.

2- How do you create alt category? ( I wanna place some links in different category without having a dublicate link showing up).

You don't really create alt categories. You edit the link record and select multiple categories for it. There is no such thing as primary/alt categories. ALl links are assigned to categories via the CatLinks table, which contains only a CategoryID:LinkID pair. You get all links in a certain category by:

Select LinkID from CatLinks where CategoryID='nnn'

You can select all categories any link is in by doing:

Select CategoryID from CatLinks where LinkID='nnn'

Since each CategoryID:LinkID is a unique pairing, no link can be in the same category twice.


3- Alex mentioned in a previous thread that the editor name tag will be available in the SQL 2 templetes, I could not find the right one yet.

This may be part of the question you asked in #1

4- Is there a way in add.cgi to make the drop down menu of categories available to choose from. I mean that the user does not have to be in the exact directory to add his/her link.

Same as in Links SQL 1.x, and before. Set db_gen_categories in the Build_Options list to "yes"


5 - Another issue some of my user are having is recieving an error message:
Unable to auto-create user: username. Reason: The column 'Status' must be unique, and already has an entry 'Not Validated'.
Please enable debugging in setup for more details.


This is more complicated. i'm going to start a new thread for it.







PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://pugdog.com/FAQ

Thanks scott

you help is always appreciated.

Regards
Christa

pugdog is actually Robert. Who is scott?

Regards,

Eliot Lee

Hi,

1. Go to Browse->Category you want->Editors and then enter the Username and permissions for the editor. The user must already exist.

2. When creating the link in Database simply select multiple categories (it's a multiple select list). If you are in Browse mode, then you can use copy to place a link in another category.

3. Not yet available, will be added though.

4. Yes, see db_gen_category_list in the Build options.

Cheers,

Alex

--
Gossamer Threads Inc.