| Message Text |
I've noticed a problem if you create a toplist using the Geo IP Database.
I you have a toplist in the wrapper template that shows listings determined by geo location, and then someone enters a location that doesn't exist in the database, for the brief moment the redirect page is shown, and error is displayed. See Below.
Quite few people are likely to see this error as many people ignore the search location suggestions.
This error will only occur if the toplist is in the wrapper and therefore executed during the redirect.
Error...
Error occurred at www.exampledomain.co.uk/clo...dition=and&whichtype=links on 2010-10-12 20:56:09. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/hello211/public_html/clone/databases/mysql.php on line 79.
Last SQL error: Unknown column '' in 'field list'
Debug info:
Load time so far: 0.034 seconds.
Query 1: SET CHARACTER SET 'utf8', character_set_server = 'utf8', CHARACTER_SET_CLIENT=utf8, CHARACTER_SET_RESULTS=utf8, CHARACTER_SET_CONNECTION=utf8
Query 2: SELECT [huge field list omitted] FROM wsnlinksclone1_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (type='regular' OR type="sponsored" AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1286916969 AND alias=0 AND inalbum=0 ORDER BY distance ASC,type desc,rand() LIMIT 0,3
Load time so far: 0.583 seconds.
Unknown column '' in 'field list'
Step 1 of backtrace:
File: /home/hello211/public_html/clone/databases/mysql.php
Line: 79
Function: mysql_num_rows
Arguments:
Step 2 of backtrace:
File: /home/hello211/public_html/clone/classes/database.php
Line: 159
Function: numrows
Arguments:
Class: db
Step 3 of backtrace:
File: /home/hello211/public_html/clone/includes/commonfuncs.php
Line: 5415
Function: numrows
Arguments:
Class: database
Step 4 of backtrace:
File: /home/hello211/public_html/clone/end.php
Line: 544
Function: runtoplist
Arguments:
Step 5 of backtrace:
File: /home/hello211/public_html/clone/includes/searchlogic.php
Line: 17
Function: require
Arguments: /home/hello211/public_html/clone/end.php
Step 6 of backtrace:
File: /home/hello211/public_html/clone/search.php
Line: 26
Function: include
Arguments: /home/hello211/public_html/clone/includes/searchlogic.php |
