Title |
Database error when add sub-category |
Message Text |
Hi Paul,
I had encountered the following error upon submission of a new sub-category:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/site/public_html/classes/database.php on line 108
Performing query: SELECT COUNT(id) FROM wsnlinks_membergroups WHERE 1=1 ;
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=1 ;
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=2 ;
nPerforming query: SELECT title FROM wsnlinks_membergroups WHERE id=3 ;
Performing query: SELECT parent FROM wsnlinks_categories WHERE alias= ORDER BY id ASC ;
Number of rows is for 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 'ORDER BY id ASC' at line 1
Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE isalbum=0 AND deleted=0 AND moderators LIKE '%, 2[,]%' ;
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 'ORDER BY id ASC' at line 1
Where can I correct the query where the "WHERE alias=" is empty? |
Rating |
0/5 based on 0 votes.
|
Ownership |
Sunburnt |
Views |
478 views. Averaging 0 views per day. |
Similar Topics |
|
Submission Date |
Sep 09, 2006 - 4:04 AM |