- Posts: 1
- Thank you received: 0
Kunena 7.0.5 & Kunena 6.4.11 – Security Updates Released
The Kunena team has announce the arrival of Kunena 7.0.5 [K 7.0.5] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0.
The Kunena team is also pleased to announce the eleventh version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.
If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your
configuration report
when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.
K 2.0 support will cease on 31 August 2013 and this section of the forum will be closed and archived after that time and no further questions will be answered about this version.
K 2.0 support will cease on 31 August 2013 and this section of the forum will be closed and archived after that time and no further questions will be answered about this version.
Question topic number and date lost
13 years 5 months ago #137332
by ravescat
topic number and date lost was created by ravescat
Hi all,
This is my first topic in this community, i hope somebody may help me.
After upgrade to last version of kunena, i saw every topic & post have lost their date & i only saw topic:0 post:0.
So i decided to copy manually from an old backup every data inside the sql file but only i correct is the topic & post numbers, the date is wrong.
But the problem is that i can't read the posts ( i'm the amministrators but nobody can read too ).
So i decide to try to clean forum inside the kunena menu in the backend & after that i see this for 196 items:
Column 'category_id' in where clause is ambiguous SQL=UPDATE KuHmd_kunena_categories AS c INNER JOIN ( SELECT t.category_id AS id, COUNT( * ) AS numTopics, SUM( t.posts ) AS numPosts, t2.id as last_topic_id FROM KuHmd_kunena_topics AS t INNER JOIN (SELECT t.id, t.category_id, t.last_post_time FROM KuHmd_kunena_topics AS t, (SELECT category_id , max(last_post_time) as last_post_time FROM `KuHmd_kunena_topics` WHERE hold =0 AND moved_id =0 GROUP BY category_id) AS temp WHERE temp.last_post_time = t.last_post_time AND category_id IN (67) AND t.category_id=temp.category_id ) AS t2 ON t2.category_id=t.category_id WHERE t.hold =0 AND t.moved_id =0 AND category_id IN (67) GROUP BY t.category_id ) AS r ON r.id=c.id INNER JOIN KuHmd_kunena_topics AS tt ON tt.id=r.last_topic_id SET c.numTopics = r.numTopics, c.numPosts = r.numPosts, c.last_topic_id=r.last_topic_id, c.last_post_id = tt.last_post_id, c.last_post_time = tt.last_post_time
Anyone know what does it mean?
Thanks a lot & sorry me for english not really good
p.s.
joomla version: 2.5.8
kunena version: 2.0.3 | 2012-11-24 [ Reconciliation ] + lastest plugins
This is my first topic in this community, i hope somebody may help me.
After upgrade to last version of kunena, i saw every topic & post have lost their date & i only saw topic:0 post:0.
So i decided to copy manually from an old backup every data inside the sql file but only i correct is the topic & post numbers, the date is wrong.
But the problem is that i can't read the posts ( i'm the amministrators but nobody can read too ).
So i decide to try to clean forum inside the kunena menu in the backend & after that i see this for 196 items:
Column 'category_id' in where clause is ambiguous SQL=UPDATE KuHmd_kunena_categories AS c INNER JOIN ( SELECT t.category_id AS id, COUNT( * ) AS numTopics, SUM( t.posts ) AS numPosts, t2.id as last_topic_id FROM KuHmd_kunena_topics AS t INNER JOIN (SELECT t.id, t.category_id, t.last_post_time FROM KuHmd_kunena_topics AS t, (SELECT category_id , max(last_post_time) as last_post_time FROM `KuHmd_kunena_topics` WHERE hold =0 AND moved_id =0 GROUP BY category_id) AS temp WHERE temp.last_post_time = t.last_post_time AND category_id IN (67) AND t.category_id=temp.category_id ) AS t2 ON t2.category_id=t.category_id WHERE t.hold =0 AND t.moved_id =0 AND category_id IN (67) GROUP BY t.category_id ) AS r ON r.id=c.id INNER JOIN KuHmd_kunena_topics AS tt ON tt.id=r.last_topic_id SET c.numTopics = r.numTopics, c.numPosts = r.numPosts, c.last_topic_id=r.last_topic_id, c.last_post_id = tt.last_post_id, c.last_post_time = tt.last_post_time
Anyone know what does it mean?
Thanks a lot & sorry me for english not really good
p.s.
joomla version: 2.5.8
kunena version: 2.0.3 | 2012-11-24 [ Reconciliation ] + lastest plugins
Please Log in or Create an account to join the conversation.
Time to create page: 0.257 seconds