Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

alt links causing problems with sorting

Quote Reply
alt links causing problems with sorting
How do I get my categories with alt links to sort correctly? They are currently placing all of the new links at the bottom.

http://link-fabulous.com
Groovy adult links
Quote Reply
Re: alt links causing problems with sorting In reply to
A) Get rid of your alt-links.

B) Wait for the next version.

C) Pray to a daemon god of bits and bytes.

D) All of the above.

E) None of the Above



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: alt links causing problems with sorting In reply to
Part of the problem is that I don't know how to get rid of the alt links. I didn't do any on purpose. How do I track the alts down?

http://link-fabulous.com
Groovy adult links
Quote Reply
Re: alt links causing problems with sorting In reply to
If you don't want links in alternate categories (ie: additional areas than their main category) you can quickly delete them all by using MySQLMan and emptying the table CategoryAlternates.

Or, you can use the SQL monitor in Links to enter the command:

DELETE * FROM CategoryAlternates


I don't believe you get a confirmation, or warning, so once you do it, re-index and re-build and it should work.

If you get an "error" of some sort with the command above, just do what it says. You want to DELETE FROM CategoryAlternates all the links. No other table needs to be touched.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: alt links causing problems with sorting In reply to
How do I get to the Links Monitor?

http://link-fabulous.com
Groovy adult links
Quote Reply
Re: alt links causing problems with sorting In reply to
Never mind the last post...I got this error though:

Query Error: parse error near '* FROM CategoryAlternates' at line 1



http://link-fabulous.com
Groovy adult links