N-13 News is working perfectly on my site, except that I can't delete any news stories! When I check the news item checkbox and click 'delete', I get the popup message asking to confirm the delete. When I click Ok to delete, the page refreshes but the news story is still there. I've tried to delete from the summary display and from the detail dialog, but neither one works.
Any ideas?
(PS: I am running on a Windows based server, PHP 5.2.6, and MySQL 5.0.51a)
Categories appear to delete, but when I do that, I get these errors/warnings running down the menu column (left of the main dialog):
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 18 in C:\Websites\AFC-Beta\news\config.php on line 101
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 19 in C:\Websites\AFC-Beta\news\config.php on line 105
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 20 in C:\Websites\AFC-Beta\news\config.php on line 110
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 21 in C:\Websites\AFC-Beta\news\config.php on line 101
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 22 in C:\Websites\AFC-Beta\news\config.php on line 105
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 23 in C:\Websites\AFC-Beta\news\config.php on line 110
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 24 in C:\Websites\AFC-Beta\news\config.php on line 101
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 25 in C:\Websites\AFC-Beta\news\config.php on line 105
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 26 in C:\Websites\AFC-Beta\news\config.php on line 110
....
The errors continue on like this for quite awhile. However, if I go back to the main menu --> Options --> Categories, the category has been removed successfully.
I am running Abyss Web server (Link which I have used for about 5 years without a problem.
I looked through the admin.php file but I can't see where a delete is happening in the the table. Must be old eyes
Access: Admin
Total Posts: 1395
Joined: 2006-05-19
The only thing I can think of that could cause this would be either register_globals or magic_quotes_gpc
When you login to the script and are looking at the home/stats page, does it give you any warnings in yellow there about either register_globals or magic_quotes?
Register_globals was on when I did the installation, but I turned them off. I can't get to my php.ini file at the moment, but what setting should I have for the magic_quotes_gpc? (just change it to whatever it isn't now?)
Added: Ok, I just checked, and I have magic_quotes_gpc = Off
I decided to try Firefox instead of IE and sure enough, that worked! I've got IE 8 as my default browser which most of the users for this particular site are going to use as well.
Is the edit/delete function using AJAX? perhaps its just a matter of checking for the browser being used.
If you don't have time/desire to look at this further, can you tell me where I might look to find the delete code? Maybe I can spot something.
Access: Admin
Total Posts: 1395
Joined: 2006-05-19
Seems when you submit the form, IE isn't passing the values of the checkboxes you selected, so when the page reloads it hasn't been given any information to delete the posts.
I'll have a look at this tonight, hopefully should be fairly easy to fix.