Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Duplicate URL check during submission

Quote Reply
Duplicate URL check during submission
Hi all,

Does any body know how can I modify add.cgi so that it check duplicate URL during the submission?

Thanks for any comments.

Quote Reply
Re: Duplicate URL check during submission In reply to
Just set the URL column to unique.

Mods:http://wiredon.net/gt/download.shtml
Installations:http://wiredon.net/gt/
Quote Reply
Re: Duplicate URL check during submission In reply to
Thanks a lot.

But whenwever I change it to unique, it changes back to "Regular". I am using 2.05 version. Is there any other way to change it?

Quote Reply
Re: Duplicate URL check during submission In reply to
Change it to unique and resync the def files.

It can't change back on its own :)

Mods:http://wiredon.net/gt/download.shtml
Installations:http://wiredon.net/gt/
Quote Reply
Re: Duplicate URL check during submission In reply to
Yes, I change it to unique and resync the def files later. But when I click on the Properties of URL, it back to Regular again. What's going wrong?

Quote Reply
Re: Duplicate URL check during submission In reply to
Hi,

This is a bug. You need to:

1. Edit GT/SQL/Editor and change line 304 from:

$query = $self->{table}->{driver}->alter_add_unique_sql ($table, $index_name, @{$indexes});

to:

$query = $self->{table}->{driver}->_alter_add_unique_sql ($table, $index_name, @{$indexes});

Then, you need to set index type to None, and then set index type to Unique.

We'll fix this up shortly.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Duplicate URL check during submission In reply to
I just do all then necessary changes. But the result is still the same. I can change index type to "none" but when I change it to unique, it will change back to "none" again. Any solution?

Quote Reply
Re: Duplicate URL check during submission In reply to
Did you get this to work? Maybe you need to re-build your search, resync defs etc. between each of the steps Alex suggests above. Please let me know when you find the solution because I would like to stop duplications as well!

JeffB

-- Updated my profile - check it out.

Quote Reply
Re: Duplicate URL check during submission In reply to
Hi

I have tried this suggestion and still have the porblem that BDEAR mentioned.
Any suggestions?

Regards
Abd

http://www.idleb.com
Quote Reply
Re: Duplicate URL check during submission In reply to
how do you get it to check automatically in 2.04 for the duplicates?


Quote Reply
Re: [Alex] Duplicate URL check during submission In reply to
Alex,

I concur with the comments made by others here. Performed the Editor.pm mod you gave, set URL index type from Regular to None and resynced. That worked fine. Then attempted to set URL index type to Unique but it just won't stick. I can even set it back to Regular and that will stick. Unique will not, not even in MySQLMan.