As of today, just after doing the lates upgrade, if I suggest a link, when selecting the category from the dropdown list, the pae refreshes and I get the following error...
Error occurred at www.weddingserviceproviders...hp?action=addlink&filled=1 on 2010-02-22 14:42:06. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/vvv/public_html/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 'AND inalbum=0 AND validated=1 AND deleted=0' at line 1
Debug info:
Load time so far: 0.03 seconds.
Query 1: SHOW TABLE STATUS LIKE 'wsnlinks_categories' Load time so far: 0.03 seconds.
Query 2: SET CHARACTER SET 'utf8' Load time so far: 0.03 seconds.
Query 3: SET character_set_server = 'utf8' Query 4: SELECT [huge field list omitted] FROM wsnlinks_links WHERE alias= AND inalbum=0 AND validated=1 AND deleted=0 Load time so far: 0.62 seconds.
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 'AND inalbum=0 AND validated=1 AND deleted=0' at line 1
Comments on Error when choosing category.
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
As of today, just after doing the lates upgrade, if I suggest a link, when selecting the category from the dropdown list, the pae refreshes and I get the following error...
Error occurred at www.weddingserviceproviders...hp?action=addlink&filled=1 on 2010-02-22 14:42:06. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/vvv/public_html/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 'AND inalbum=0 AND validated=1 AND deleted=0' at line 1
Debug info:
Load time so far: 0.03 seconds.
Query 1: SHOW TABLE STATUS LIKE 'wsnlinks_categories'
Load time so far: 0.03 seconds.
Query 2: SET CHARACTER SET 'utf8'
Load time so far: 0.03 seconds.
Query 3: SET character_set_server = 'utf8'
Query 4: SELECT [huge field list omitted] FROM wsnlinks_links WHERE alias= AND inalbum=0 AND validated=1 AND deleted=0
Load time so far: 0.62 seconds.
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 'AND inalbum=0 AND validated=1 AND deleted=0' at line 1
Step 1 of backtrace:
File: /home/vvv/public_html/databases/mysql.php
Line: 79
Function: mysql_num_rows
Arguments:
Step 2 of backtrace:
File: /home/vvv/public_html/classes/database.php
Line: 165
Function: numrows
Arguments:
Class: db
Step 3 of backtrace:
File: /home/vvv/public_html/classes/onelink.php
Line: 1411
Function: numrows
Arguments:
Class: database
Step 4 of backtrace:
File: /home/vvv/public_html/includes/objectfunctions.php
Line: 366
Function: aliasedin
Arguments:
Class: onelink
Step 5 of backtrace:
File: /home/vvv/public_html/classes/generic.php
Line: 273
Function: objectreplacements
Arguments:
Step 6 of backtrace:
File: /home/vvv/public_html/end.php
Line: 337
Function: replacements
Arguments:
Class: generic
Step 7 of backtrace:
File: /home/vvv/public_html/suggest.php
Line: 253
Function: require
Arguments: /home/vvv/public_html/end.php
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
Ignore this, it was a bad toplist in my wrapper.tpl causing it