Hello Sean,
No requests just some helpful info re: this error.
Resolved this problem after hours of scrutinising the code. Its now 4:30am so bare with me...
For the error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /my/path/htdocs/my URL.org.uk/wp-content/plugins/wordpress-link-directory/link-directory.php on line 504
After the addition of two lines of code, the cleanse function should be fully functional but will, unfortunately, incur another, very minor & totally unrelated error. This has no real effect other than being unsightly & sometimes inconvenient.
Find at line 490 of link-directory.php:
// Perform The Cleanse Action by Checking the Reciprocal URLs for Each Link
$CleanseDel=$_POST['wplinkdir_cleansedelete'];
Change this to:
// Perform The Cleanse Action by Checking the Reciprocal URLs for Each Link
$recip_option=get_option('wplinkdir_recip_requirement');
$links_table = WPLD_LINKS_TABLE;
$CleanseDel=$_POST['wplinkdir_cleansedelete'];
The cause of the problem was just 2 lines of missing code. These defined a couple of important variables.
Unfortunately the resolution of this problem opens another small bug:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/a6593544/public_html/wordpress/wp-content/plugins/wordpress-link-directory/link-directory.php on line 547
This seems to control the import/export function, after the cleanse has run, and delivered results. The code for this bit makes little sense to me, and may require a complete rewrite. But it is a minor problem anyhow as the import / export functions can be restored by navigating away from and back to the functions tab.
I might have a poke around with this over the weekend for fits and giggles. For now its time for bed.
Sorry to bump an old post, but I thought this might benefit a few people, and assist the developer.