Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Priority mod on LinkSQL 2.1.2 doesn't work!

Mar 20, 2003, 9:04 AM
Nomada
User (144 posts)
Mar 20, 2003, 9:04 AM
Post #1 of 15
Views: 4841
Shortcut
Quote Reply
Priority mod on LinkSQL 2.1.2 doesn't work!
I'm trying to setup the Priority mod into LinkSQL 2.1.2.

I have follow these steps http://www.gossamer-threads.com/...orum.cgi?post=183433:

~ Click on Database > Links (drop) > Properties (drop)

~ Then at the bottom of the page there is a link called 'Add Column'. Click this.

~ Then set as follows;

Column Name - Priority
Column Type - INT
Form Display - Prioridad
Form Type - Select
Form Size - 4
Form Names - 1 then return, then 0
Form Values - Yes then return then No
Search Weight - 0

Then press Add Field To Links


~ Then add another field as follows;

Column Name - PriorityImage
Column Type - TEXT
Form Display - Imagen Prioritaria
Form Type - Textarea
Form Size - 40,5
Search Weight - 0

Then press Add Field To Links again.

Then in your link.html template add the following (or similar);

<%if Priority%>
<%PriorityImage%>
<%endif%>

And finally I have setup the Build options like:

Setup > Build Options

Then find build_sort_order_category and add in Priority DESC, like so;

Priority DESC,isNew DESC,isPopular DESC,Title

The problem are that the image display OK but the sort order not work... Frown

The priority link sort in a different position according to the diferent queries.

Does somebody have the same problem?

Help please!!

-----------------------
Nomada
Mar 20, 2003, 9:53 AM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 9:53 AM
Post #2 of 15
Views: 4792
Shortcut
Quote Reply
Re: [Nomada] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Hi, Not sure whether this is the problem but build_sort_order_category is the order that the links are displayed in a category. As you said the results are different for different queries, I wonder whether you are trying to sort the search results?

Laura.
The UK High Street
Mar 20, 2003, 10:03 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 20, 2003, 10:03 AM
Post #3 of 15
Views: 4815
Shortcut
Quote Reply
Re: [Nomada] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
I had a similar problem. I'm thinking it may be to do with 2.1.2 ... Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Mar 20, 2003, 10:07 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 20, 2003, 10:07 AM
Post #4 of 15
Views: 4771
Shortcut
Quote Reply
Re: [afinlr] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
In Reply To:
I wonder whether you are trying to sort the search results?

If you have a priority link, you may want the link to be shown higher up the ranking if they have a priority listing. That is why I was trying..and I'm sur that is why Nomada is too :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Mar 20, 2003, 10:14 AM
Nomada
User (144 posts)
Mar 20, 2003, 10:14 AM
Post #5 of 15
Views: 4768
Shortcut
Quote Reply
Re: [Andy] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
In Reply To:

That is why I was trying..and I'm sur that is why Nomada is too :)


You are right Andy! Unsure

Which is the problem?

Alex?

Greetings

-----------------------
Nomada
Mar 20, 2003, 10:15 AM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 10:15 AM
Post #6 of 15
Views: 4843
Shortcut
Quote Reply
Re: [Andy] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Well, I'm using 2.1.2 and have priority links which show up first in the category (I think!) so I was wondering whether it was actually build_sort_order_search that Nomada wanted. But if you're also having problems then maybe it is something else.
Mar 20, 2003, 11:16 AM
Nomada
User (144 posts)
Mar 20, 2003, 11:16 AM
Post #7 of 15
Views: 4734
Shortcut
Quote Reply
Re: [afinlr] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Hi Laura,

The priority mod has that display any link setup as priority the first one, in the search results or in statics categories. But if me setup build_sort_order_search as Priority DESC instead 'score' when I attempting a new search in LinksSQL doesn't find any link...

I think the problem is in build_sort_order_search option setup.

Greetings,

-----------------------
Nomada
Mar 20, 2003, 12:11 PM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 12:11 PM
Post #8 of 15
Views: 4753
Shortcut
Quote Reply
Re: [Nomada] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Could be a bug - there were lots of discussions about a bug last year but I would have thought that it would have been fixed in 2.1.2.

http://www.gossamer-threads.com/...i?post=183721#183721

http://www.gossamer-threads.com/...i?post=185280#185280

I have just tried changing 'score' to 'Priority DESC' in my sort order field and it does seem to be working. Not sure whether it matters which indexing scheme you are using or whether you are looping the results. Hopefully someone else can help.

Laura.
The UK High Street
Mar 20, 2003, 1:48 PM
webmaster33
Veteran (2312 posts)
Mar 20, 2003, 1:48 PM
Post #9 of 15
Views: 4755
Shortcut
Quote Reply
Re: [Nomada] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Just a small idea.
If there are mixed both empty or NULL values in the column, then it will affect sorting your priority sorting.
I had such problems in practice.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Mar 20, 2003, 3:36 PM
Nomada
User (144 posts)
Mar 20, 2003, 3:36 PM
Post #10 of 15
Views: 4729
Shortcut
Quote Reply
Re: [afinlr] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Laura,

Which indexing scheme you are using?

Konrad,

All values are good.

Frown

-----------------------
Nomada
Mar 20, 2003, 3:46 PM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 3:46 PM
Post #11 of 15
Views: 4739
Shortcut
Quote Reply
Re: [Nomada] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Internal.
Mar 20, 2003, 3:59 PM
Nomada
User (144 posts)
Mar 20, 2003, 3:59 PM
Post #12 of 15
Views: 4733
Shortcut
Quote Reply
Re: [afinlr] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
I can use internal indexing for spanish language?

The LinkSQL Manual says:

Quote:

Only useable on English style languages, i.e.: where words can be separated by spaces. Foreign languages that use two byte characters cannot use this style.

Sorry, but the Spanish is a one or two byte character language? I don't know Blush

Thank you!

-----------------------
Nomada
Mar 20, 2003, 4:11 PM
afinlr
Veteran (1921 posts)
Mar 20, 2003, 4:11 PM
Post #13 of 15
Views: 4764
Shortcut
Quote Reply
Re: [Nomada] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
I'm not certain but I would guess that these are asian languages like Japanese?

If you do use internal indexing you will need to add weights to all the fields that you want to search on and then rebuild the search.
Mar 20, 2003, 4:26 PM
Nomada
User (144 posts)
Mar 20, 2003, 4:26 PM
Post #14 of 15
Views: 4755
Shortcut
Quote Reply
Re: [afinlr] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
Thank your Laura,

Tomorrow I will try. Wink Today I am tired.

Cheers

-----------------------
Nomada
Mar 22, 2003, 6:27 AM
Nomada
User (144 posts)
Mar 22, 2003, 6:27 AM
Post #15 of 15
Views: 4683
Shortcut
Quote Reply
Re: [Nomada] Priority mod on LinkSQL 2.1.2 doesn't work! In reply to
With the Internal indexing scheme works fine!! Wink

Thank you Laura!!

-----------------------
Nomada