Hi,

I checked my linkssql tables.

lsql_CatLinks - 33454
lsql_Links - 33448

Why is that difference? I backed up yesterday from BACKUP.1 file.

I run resync database, repair tables, build search index. No use.

No errors while importing from backup yesterday.

I checked the forums. Alex in one post said this code:
-----------------------------------------
my $sth = $DB->table('CatLinks', 'Links')->select('left_join', ['LinkID'], { ID => undef });
my @ids = $sth->fetchall_list;
# $DB->table('CatLinks')->delete( { LinkID => \@ids } );
-----------------------------------------

Where to run this exactly? I tried in 'SQL Monitor' screen. I am getting this message:

---------------------------------------------
Error: Query Error: Failed to execute query: 'my $sth = $DB->table('CatLinks', 'Links')->select('left_join', ['LinkID'], { ID => undef }); my @ids = $sth->fetchall_list; # $DB->table('CatLinks')->delete( { LinkID => \@ids } );' Reason: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'my $sth = $DB->table('CatLinks', 'Links')->select('left_join',
----------------------------------------------------------------

Any help?