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

Duplicates Software Error

Quote Reply
Duplicates Software Error
Hi everyone!

My prob is that when I go to look for duplicates under the web admin panel it says:

Software error:
Execute failed: The table 'SQLfbc5c_0' is full at /path/links/admin/admin.cgi line 394.
Please send mail to this site's webmaster for help.

I have about 55,000 linksin the database but that shouldn't be enough to max anything out?

I haven't made any mods to the scripts either...


Quote Reply
Re: Duplicates Software Error In reply to
Check the resource area. There is a fix for "Big Tables."

Quote Reply
Re: Duplicates Software Error In reply to
Argghh! Just spent 15 mins trying to find it and no luck. You couldn't point me in the right direction could you? And while you're at it I kinda need a shave and some clothes put on too :]

Quote Reply
Re: Duplicates Software Error In reply to
Hmmmm....

It seems to be missing.

Try this... in the Admin_HTML.pm file, find the line in the check_duplicates area that is:

my $offset = $in->param('offset') || 0;

after that, put the line:

$db->do (qq! SET OPTION SQL_BIG_TABLES = 1 !); ### needed for big tables.



that should work.

Let me know. That's the only place in any of my files I have it. (most of my tables/sites are well below the big-table limit).



Quote Reply
Re: Duplicates Software Error In reply to
Let me make a correction...

I knew I had made two changes, one worked, one didn't, but I couldn't find it.

The _real_ change is to be made in admin.cgi:

Code:
sub check_duplicates {
# --------------------------------------------------------
# This routine searches through the database and pulls up sets
# of links that have identical URL's.
#
my ($in, $db) = @_;
my ($query, $sth, $doubles, %doubles, $url, $hits);
my $offset = $in->param('offset') || 0;
$db->do (qq! SET OPTION SQL_BIG_TABLES = 1 !); ### needed for big tables.
That should work.

Quote Reply
Re: Duplicates Software Error In reply to
That worked a treat.

Thanks PugDog, you've saved my marriage!