Alex, Check duplicates dies with the following error:-

Unable to run function Links::Tools::check_duplicates(Links::Tools::check_duplicates) Reason: 'Can't call method "fetchrow_array" on an undefined value at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0/admin/Links/Tools.pm line 209, chunk 1. '.

Hi,

Can you enable debugging and tell me what $GT::SQL::error says?

Cheers,

Alex

--
Gossamer Threads Inc.

Alex, Here is the debug output:-

GT::SQL::Driver::MYSQL (4881): Preparing query: SELECT URL,COUNT(*) AS hits FROM Links GROUP BY URL ORDER BY hits DESC LIMIT 0, 10 at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0/admin/GT/SQL/Driver/MYSQL.pm line 35. GT::SQL::Table (4881): Failed to execute query: 'SELECT URL,COUNT(*) AS hits FROM Links GROUP BY URL ORDER BY hits DESC LIMIT 0, 10' Reason: The table 'SQL6e0a93_0' is full at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0/admin/Links/Tools.pm line 205. Unable to run function Links::Tools::check_duplicates(Links::Tools::check_duplicates) Reason: 'Can't call method "fetchrow_array" on an undefined value at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0/admin/Links/Tools.pm line 209, chunk 1. '.

i get this too.

http://www.ASciFi.com/ - The Science Fiction Portal

Hi,

That's a bug. You can fix this by changing line 197 in Links/Tools.pm from:

if ($db->{connect}->{driver} eq 'MYSQL') {

to:

if (lc $db->{connect}->{driver} eq 'mysql') {

Cheers,

Alex

--
Gossamer Threads Inc.

Alex, Thanks, that fixed it.

Hi!

is there a comand in mysql monitor to automatically delte all duplicates without confirming ... now i have to manually delete duplicates .. i did delete them in excel .. but when you are importing 6000 links from excel to sql .. there might be some duplicates :)

Gregor

Hi,

No, it's not recommended as then you will have links in the CatLinks table that don't match a given link.

Cheers,

Alex
--
Gossamer Threads Inc.