Question [Resolved] Location of Post Files

Hi,

I just had a rash of unwanted post on my site. I reactivated security software ect.... so now I just to clean up the forum. All of the post were in one category as a reply to one thread. Although I should be able to just delete them, as soon as I either use the check box to select those post or try to open them, my machine locks up. I've unsubscribed tht one category to protext other users, but now I'd like to find out the exact location of those files so I can delete those post and get that category back online. The address bar reports

index.php/en/forum/64-general-discussion/62-title

If someone could point me to where the forum folder is I can take it from there.

Thanks!!!

G'day, ajweber, and welcome to Kunena.

Forum topics and messages (or posts) are not stored as files; they're stored (as records) in the Joomla database. If you are having problems deleting messages or topics by using the moderator tools, then it either there is something peculiar happening inside the database or there's something peculiar happening inside Kunena on your site. It would help you (and us who are trying to help you) if you read What information should I include when I ask for help (including how to post my configuration report)? and provide us with a few clues about your Kunena set-up. Thanks.

Ok, one of the things the requested on the page you recommended was a Cofiguration report which is posted here. My initial post is more of a request than a problem. I can easily just trash the whole category, create a new one and push forward, but there are post by other users that I want to salvage and keep.

Tha problem is that whatever content the spammer included in 16 separate entries immediatley brings your computer to screaching halt if you try to access it on the site. I just want to go into where the information is on my ftp site, find the file, whatever format it's in and delete the offending information so I can republish the good ones. If there isn't way to do it the way I've described then I will just trash the category, which is not what I want to do.

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 128M

Kunena menu details:

Joomla default template details : siteground-j16-21 | author: SiteGround | version: 1.0.0 | creationdate: 07 October 2011

Kunena default template details : nts_kdark | author: 9ThemeStore | version: 1.7.0 | creationdate: 2011-05-07

Kunena version detailled: Installed version: 1.7.2 | Build: 5215 | Version name: Omega | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_offline	0
board_ofset	0
enablerss	1
enablepdf	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	1
disemoticons	0
template	nts_kdark
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	1
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	0
allowavatar	1
allowavatarupload	0
allowavatargallery	0
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	0
imagewidth	0
imagesize	128
allowfileupload	0
allowfileregupload	1
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	128
showranking	0
rankimages	0
avatar_src	fb
fb_profile	fb
pm_component	no
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_username	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_usertype	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	1
help_infb	1
help_cid	1
showspoilertag	0
showvideotag	0
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode
fbsessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	0
pollenabled	0
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	0
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	150
thumbwidth	150
hideuserprofileinfo	put_empty
integration_access	joomla
integration_login	none
integration_avatar	auto
integration_profile	auto
integration_private	uddeim
integration_activity	communitybuilder
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	0
topicicons	1
onlineusers	0
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
activity_limit	0
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	disabled
topic_subscriptions	disabled
pubprofile	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
email_visible_address
captcha_post_limit	3

Third-party components: CommunityBuilder 1.8 | UddeIm 2.6

Third-party SEF components: None

Plugins: System - Mootools Upgrade: Disabled | System - Mootools12: Disabled

Modules: Kunena Latest 1.7.1 | Kunena Stats 1.7.1 | Kunena Search 1.7.1

You can remove the spam posts by using the user ban facility. See Moderator's tools in the Wiki. You should not need to delve into the database - if you do, you could destroy your whole website if you don't know what you're doing.

I also suggest that you might look at Search Engine Optimisation (SEO) in the Wiki.

Can you point to one of the topics on your site that causes these "crashes" you mentioned, please?

I notice that you do not have a Kunena menu enabled. Maybe it would be a good idea to enable this?

Ok, the category is back up for 30min or so, I don't want my users to experience what I did!

I don't think you understand the problem, if I select any of the opposing subjects, even indirectly my machine locks up. I get a windos warning asking if I want to continue running the script and that if I do it could effect the rest of my programs. I can't touch it on the front end, that's why I wanted to know how to delete it from the ftp side.


fsnavnet.com/index.php/en/forum/64-general-discussion

Ok, I was able to fix it. I managed to get to the post on the front end delete them.

Thanks for info.