HelloPaulI get an errorwhen Idoanadvanced searchonthelocation (localité on my page)
Allothersearch fieldsare operating normally.
Itriedputting all the TPLinEnglishandI havethesameerror.
I haveexactlythe sameerroronWSNForum.
Here isthedebugerror:
* An error occured while processing this page:
* Error occurred at bor&limit=20×tamp=1293481797216>http://www.milouchouchou.com/milan...mp;timestamp=1293481797216 on 2010-12-27 20:29:55. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/milouch1/public_html/milannu/databases/mysql.php on line 79.
* Last SQL error: 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 '=location} FROM wsnlinks_members WHERE location LIKE 'bor%' GROUP BY {=location}' at line 1
* Debug info:
* Load time so far: 0.037 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 wsnlinks_members WHERE location LIKE 'bor%' GROUP BY {=location} ORDER BY location ASC LIMIT 0,20
Comments on Search error
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Hello Paul I get an error when I do an advanced search on the location (localité on my page)
All other search fields are operating normally.
I tried putting all the TPL in English and I have the same error.
I have exactly the same error on WSN Forum.
Here is the debug error:
* An error occured while processing this page:
* Error occurred at bor&limit=20×tamp=1293481797216>http://www.milouchouchou.com/milan...mp;timestamp=1293481797216 on 2010-12-27 20:29:55. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/milouch1/public_html/milannu/databases/mysql.php on line 79.
* Last SQL error: 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 '=location} FROM wsnlinks_members WHERE location LIKE 'bor%' GROUP BY {=location}' at line 1
* Debug info:
* Load time so far: 0.037 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 wsnlinks_members WHERE location LIKE 'bor%' GROUP BY {=location} ORDER BY location ASC LIMIT 0,20
* Step 1 of backtrace:
* File: /home/milouch1/public_html/milannu/databases/mysql.php
* Line: 79
* Function: mysql_num_rows
* Arguments:
* Step 2 of backtrace:
* File: /home/milouch1/public_html/milannu/classes/database.php
* Line: 161
* Function: numrows
* Arguments:
* Class: db
* Step 3 of backtrace:
Have you any idea about this error?
Thank you in advance.
Regards.
Francis
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Fixed for the next beta.
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Thank you Paul
I wish you a happy new year 2011
Regards.
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Hello Paul
Thank you for the update, it works perfectly.
Regards.