Webmastersite.net
Register Log In

Database error when add sub-category

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
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership Sunburnt
Views 483 views. Averaging 0 views per day.
Similar Topics
Submission Date Sep 09, 2006 - 4:04 AM