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?
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?