and the search members with address 83.67.37.159 give the error as it does on my installation (3.3.6) Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dh1946/admindemo/classes/database.php on line 108
Further to this here is debug output from my installation.
Load time so far: 0.48 seconds. Performing query: SELECT DISTINCT ownerid FROM wsnlinks_comments WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ;
Number of rows is 0 for Resource id #51
Load time so far: 0.48 seconds. Performing query: SELECT DISTINCT ownerid FROM WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web/sites/080/ukpotters/www.ukpotters.co.uk/wsn/classes/database.php on line 108
Number of rows is for You have an error in your SQL syntax near 'WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ' at line 1
Load time so far: 0.48 seconds. Performing query: SELECT id FROM wsnlinks_members WHERE ip LIKE '%81.131.87.166%' ORDER BY id DESC ;
You have an error in your SQL syntax near 'WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ' at line 1
Number of rows is 1 for Resource id #52
It does output a correct result if there are members matching the IP.
Comments on Search IP address - gives error
Member
Usergroup: Customer
Joined: Oct 08, 2003
Total Topics: 6
Total Comments: 13
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dh1946/admindemo/classes/database.php on line 108
This Shows up on your demo WSN Links.
Find members with IP addresses containing "enter IP address" (I used mine 83.67.37.159)
Forum Regular
Usergroup: Customer
Joined: Jan 11, 2006
Total Topics: 48
Total Comments: 166
Can't confirm. Works as expected with WSN Links 3.3.6 Pro, mySQL 3.23 and PHP 4.3.
Member
Usergroup: Customer
Joined: Oct 08, 2003
Total Topics: 6
Total Comments: 13
Strange - I've just tried it again on the demo site here
www.free-webmaster-resource.../admindemo/admin/index.php
and the search members with address 83.67.37.159 give the error as it does on my installation (3.3.6)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dh1946/admindemo/classes/database.php on line 108
Member
Usergroup: Customer
Joined: Oct 08, 2003
Total Topics: 6
Total Comments: 13
Further to this here is debug output from my installation.
Load time so far: 0.48 seconds.
Performing query: SELECT DISTINCT ownerid FROM wsnlinks_comments WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ;
Number of rows is 0 for Resource id #51
Load time so far: 0.48 seconds.
Performing query: SELECT DISTINCT ownerid FROM WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web/sites/080/ukpotters/www.ukpotters.co.uk/wsn/classes/database.php on line 108
Number of rows is for You have an error in your SQL syntax near 'WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ' at line 1
Load time so far: 0.48 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE ip LIKE '%81.131.87.166%' ORDER BY id DESC ;
You have an error in your SQL syntax near 'WHERE ip LIKE '%81.131.87.166%' ORDER BY ownerid DESC ' at line 1
Number of rows is 1 for Resource id #52
It does output a correct result if there are members matching the IP.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Confirmed, will be fixed in 3.3.7.
Forum Regular
Usergroup: Customer
Joined: Jan 11, 2006
Total Topics: 48
Total Comments: 166