I have kunena installed for some time now into Joomla but there is another section of the site i would like to tie to it. Its essentially a list of topics that exist outside of the Joomla function. To import or inject these topics into Kunena, I would need to go into my PHPAdmin panel on the server and run a few SQL commands.
Ok no problem there but as i am trying to do the, i keep getting something funny and i think its because of my understanding of the Kunena Topics SQL table columns.
So maybe someone can help me clarify them.
I have over 3,000 topics i need to add into Kunena and here is what i did.
I went into the PHPAdmin area and downloaded an sql copy of the "xx_kunena_topics" table. I can use this as a template to write additional topic IDs and their needed information.
xx_kunena_topics has COLUMS with the following names and most of them, i know what they represent. But there is a couple which i am wrong about. I need to know what the colums are looking for.
Below i have typed up my understanding of each of the comumn ROWS but 3 of them i think i am getting incorrect when i creat my write up my SQL INSERT command.
fist_post_id
last_post_id
last_post_time
The reason that i said if you have 100 topics, you dont nessasarily have 100 topics in your SQL table. If you created a topic and its ID was 100 but then deleted the topic, when you create another one, it becomes 101. It does NOT take the place in the system becoming
topic ID number 100
and
last post ID 100
So i think thats where i am going wrong. I was able to test this by creating TWO lines of SQL INSERT commands that would create 2 topics into a specific category FROM the PHPadmin area.
I ran the code, and SUCCESS!
I see on the front end that the two topics are created correctly in the right area, with appropriate name and ID in the URL
but when i click them:
first it kept showing the BODY of the very first TOPIC so i corrected that.
Then it created it with the right topic + ID + URL+ everything else, however because of the TIMESTAMP i applied for
first_post_time
last_post_time
It told me i dont have access to the message. I believe this is also related to the FIRST and LAST post_id) Keep in mind, the post ID is relative to HOW MANY ACUTAL POSTS were created INCLUDING any deleted topics.
So my questions are below.
id - topic id number (the first topic created would be id = 1) If there is 100 topics, the last one would NOT be 100 however and below you will see why.
category_id = category ID number from the categories admin area. I am working with category number 9
subject = The text of the subject of topic name.
icon_id = denotes WHICH icon your topic uses. I have NO topic icons so this is 0
label_id = As above. This is 0
locked = These will not be locked. So this is 0
hold = Not on hold so this is 0
ordering = no particular ordering so this is 0
posts = I believ this means HOW MANY POSTS or REPLIES are tied to this topic. I am creating new topics sothis is 0
hits = the number of times this topic has been clicked to view
attachments = None so this will be 0
poll_id = As above so this is 0
moved_id = this was not moved from another category so this is 0
first_post_id = WHAT IS THIS ASKING FOR?
first_post_time = The number of seconds since Jan 1st 2021 to the time of this topic created
first_post_userid = User Id of the person creating the post
first_post_message = The BODY of the topic.
first_post_guest_name = the USERNAME tied to that USER ID
last_post_id = WHAT IS THIS ASKING FOR?
last_post_time = Is this the same as FIRST_POST_TIME ?
last_post_userid = again the USER ID tied to the USERNAME for this post
last_post_message = Same as first_post_message
last_post_guest_name = Sane as first_post_guest_name
rating = I am not using RATING so this is 0
params = this is blank
