Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Editing Category Relations

Quote Reply
Editing Category Relations
I am having a problem with MySQLMan and my Related Categories table. The problem with the related category table (l2_CatRelations) is there is no way to edit or delete the rows in the table. For example, at the end of every row (using MySQLMan) in the category table (l2_Category) there is the option to edit or delete, but there are no such options for the related category table. whats going on here? Is there another way to edit or delete from this table or can the edit and deltete columns be added into this table for MySQLMan? If this is confusing I will try to clarify when asked. Thanks for your help in advance...

Quote Reply
Re: Editing Category Relations In reply to
Alex mentioned this before...if there is no PRIMARY key defined in the table, then you cannot edit or delete the rows.

What you need to do is edit the Category_Relations table via the admin.cgi script.

Regards,

Eliot Lee
Quote Reply
Re: Editing Category Relations In reply to
how do I do that? I'm not that familiar with MySQL..

Quote Reply
Re: Editing Category Relations In reply to
Uh...click on Primary for the key field that you want to be the Primary key via the table option in MySQLMan...need more help...read the HELP files in MySQLMan.

Regards,

Eliot Lee