| Message Text |
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 |
