Kunena 7.1.1 & Kunena 6.4.17 – Security Updates Released
The Kunena team has announce the arrival of Kunena 7.1.1 [K 7.1.1] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.x./6.2.x This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 / K7.0 and issues discovered during the last development stages of K 7.1
Just a reminder: K6.4.17 receives only securities fixes until end of 2026, so it's advised for users to upgrade to K7.1.
Solved Need help with mySQL command / purging deleted topics
- GJSchaller
-
Topic Author
- Offline
- Premium Member
-
If a new message is deleted, it can be purged normally, so that is not an issue.
I have determined that the messages that need to be purged all have a "hold" value of 2 in the mySQL table XXX_kunena_messages, and the message body is still there in the XXX_kunena_message_text table as well.
I'd like to run a simple operation on my table, using either a simple PHP file or phpMySQL, to remove these entries, but I lack the knowledge to construct this myself.
What command can I run on the system that will:
- Delete a record with a "hold" value of 2 in the table XXX_kunena_messages
- Delete the corresponding record with a matching "id" value in XXX_kunena_messages_text
Thank you!
Geoffrey Schaller
Technical Officer
Knight Realms
Please Log in or Create an account to join the conversation.
You probably need to run two queries in as follows and, remember, this is only a rough guide and I haven't tested it:
I would suggest that you run these as SELECT queries first, to make sure that you get the right records before you run them as DELETE queries.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- GJSchaller
-
Topic Author
- Offline
- Premium Member
-
Here's the error I am getting when I run it:
(XXX is, of course, replaced with the actual table prefix.)
Forum Config in message to follow.
Geoffrey Schaller
Technical Officer
Knight Realms
Please Log in or Create an account to join the conversation.
- GJSchaller
-
Topic Author
- Offline
- Premium Member
-
Database collation check: The collation of your table fields are correct
Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
This message contains confidential informationhtaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 16M
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path 922 Forums - Main jtouch view=category&catid=0&layout=list mobile-forums 923 Forums - Recent jtouch view=topics&layout=default&mode=replies mobile-recent 924 Forums - New Post jtouch view=topic&catid=&layout=create mobile-newpost 557 Forums community view=home&defaultmenu=891 forums 636 Forum mainmenu Itemid=890 kunena-2012-08-15 890 Forum kunenamenu view=home&defaultmenu=891 forum 891 Index kunenamenu view=category&layout=list forum/index 892 Recent Topics kunenamenu view=topics&mode=replies forum/recent 893 New Topic kunenamenu view=topic&layout=create forum/newtopic 894 No Replies kunenamenu view=topics&mode=noreplies forum/noreplies 895 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest 899 User List kunenamenu view=user&layout=list forum/userlist 897 Help kunenamenu view=misc forum/help 898 Search kunenamenu view=search forum/search
Joomla default template details : knightrealms | author: Geoffrey Schaller | version: 1.7.0 | creationdate: 12th August 2011
Kunena default template details : Travance 2.0 | author: Geoffrey Schaller | version: 2.0.2 | creationdate: 2012-09-04
Kunena version detailed: Kunena 2.0.2 | 2012-09-02 [ Botschafter ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: board_offline 0 enablerss 0 threads_per_page 30 messages_per_page 30 messages_per_page_search 30 showhistory 1 historylimit 30 shownew 1 disemoticons 0 template travance showannouncement 0 avataroncat 1 catimagepath category_images/ showchildcaticon 1 rtewidth 450 rteheight 300 enableforumjump 1 reportmsg 1 username 0 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 500 regonly 0 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 0 captcha 0 mailfull 1 allowavatarupload 0 allowavatargallery 1 avatarquality 90 avatarsize 2048 imageheight 800 imagewidth 800 imagesize 128 filetypes txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2 filesize 128 showranking 1 rankimages 1 userlist_rows 30 userlist_online 1 userlist_avatar 1 userlist_name 1 userlist_posts 1 userlist_karma 0 userlist_email 0 userlist_usertype 0 userlist_joindate 1 userlist_lastvisitdate 1 userlist_userhits 0 latestcategory 0 showstats 1 showwhoisonline 1 showgenstats 1 showpopuserstats 0 popusercount 5 showpopsubjectstats 1 popsubjectcount 25 usernamechange 1 showspoilertag 1 showvideotag 1 showebaytag 1 trimlongurls 1 trimlongurlsfront 40 trimlongurlsback 20 autoembedyoutube 1 autoembedebay 1 ebaylanguagecode en-us sessiontimeout 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 defaultpage recent default_sort asc sef 1 sefutf8 1 showimgforguest 1 showfileforguest 1 pollnboptions 10 pollallowvoteone 1 pollenabled 1 poppollscount 25 showpoppollstats 1 polltimebtvotes 00:15:00 pollnbvotesbyuser 100 pollresultsuserslist 1 maxpersotext 50 ordering_system replyid post_dateformat datetime_today post_dateformat_hover datetime_today hide_ip 1 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 boxghostmessage 0 userdeletetmessage 2 latestcategory_in 1 topicicons 0 debug 0 catsautosubscribed 0 showbannedreason 0 version_check 1 showthankyou 1 showpopthankyoustats 1 popthankscount 25 mod_see_deleted 0 bbcode_img_secure text listcat_show_moderators 1 lightbox 1 show_list_time 720 show_session_type 0 show_session_starttime 15 userlist_allowed 0 userlist_count_users 2 enable_threaded_layouts 0 category_subscriptions topic topic_subscriptions first pubprofile 0 thankyou_max 10 email_recipient_count 0 email_recipient_privacy bcc captcha_post_limit 0 keywords 0 userkeywords 0 image_upload registered file_upload registered topic_layout flat time_to_create_page 1 show_imgfiles_manage_profile 1 hold_newusers_posts 0 hold_guest_posts 0 attachment_limit 8 pickup_category 0 article_display intro send_emails 1 fallback_english 1 cache 0 cache_time 60 iptracking 1 changename 1 enablepdf 0 jmambot 1 annmodid 62 userlist_username 0 rules_infb 1 help_infb 1 onlineusers 1 plugins Array | Joomla! detailed language files installed:Warning: Spoiler!Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=0
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Enabled: private=1
Warning: Spoiler!
Joomla! languages installed: en-GB English (United Kingdom)
Third-party components: CommunityBuilder 1.8.1 | UddeIM 2.8
Third-party SEF components: None
Plugins: None
Modules: Kunena Stats 2.0.2 | Kunena Login 2.0.2
Geoffrey Schaller
Technical Officer
Knight Realms
Please Log in or Create an account to join the conversation.
But, seriously, I dashed off my rough guide information after spending about 10 minutes running a quick test using phpMyAdmin looking at the question, because I found it interesting from an "academic" perspective. Perhaps the syntax is different with phpMYSQL (which I've never heard of).
Your configuration report doesn't help in this situation. This is probably something you need to experiment with yourself. My advice is to start simple with
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- GJSchaller
-
Topic Author
- Offline
- Premium Member
-
Backups will be made, verified, and backed up again, before I run the DELETE version.
Again, thank you, Sozzled.
Geoffrey Schaller
Technical Officer
Knight Realms
Please Log in or Create an account to join the conversation.