| Title |
Problem with categories and new link submission |
| Description |
Problem with categories and new link submission |
| Message Text |
Hi
There seems to be a problem on my WSN Links system (5.1.53) - Someone has managed to submit a new category (although submissions of new categories is set not to be permitted for the userlevel) and place a link listing in the category. When I approved it, it didn't show up, which alerted me to a problem. After some searching I located the new link submission and found that it had been placed in a new category called something random like 'sean's link listing' - when I went to edit this, I tried deleting the category and moving the listing but the category still shows up. The actual link shows up as the primary category being 'admin's link collection' - and there is no choice to select anything else. When I hard deleted the link I now get the following errors if I try to access the link again to check it's gone:
Error occurred at /links/link.php?action=detail&id=10095 on 2010-11-28 00:31:53. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /links/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 validated=1 AND hide=0 ORDER BY title ASC' at line 1
Error occurred at /links/link.php?action=detail&id=10095 on 2010-11-28 00:31:53. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /links/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 invisibleto NOT LIKE '%|3|%') AND effectivetime < 1290904311 AND alias=0 AND' at line 1
I'm worried that security of the links and database system has been compromised, whether it is a WSN links problem or a database problem of some sort (perhaps the database disconnected during submission?) and also wondering if this problem can therefore be securely fixed?
Many thanks for your help
Kind regards
Trevor. |
| Rating |
0/5 based on 0 votes.
|
| Ownership |
wsnl |
| Views |
300 views. Averaging 0 views per day. |
| Similar Topics |
|
| Submission Date |
Nov 27, 2010 - 6:34 PM |
