Solved Adding Kunena topics via SQL injection

ok cool i understand that part now. Thanks very much mate.
The final question is still about the POST TIME.

In my SQL table for example. I see a POST TIME as
1614286027
what is this representing? Number of seconds since the beginning of the year?
I want to create these topics and insert them but ill need to make sure i enter in a POST TIME for each one that represents a time always PRIOR to my activity on the SQL table. otherwise i could end up with a different problem
Also i need to make sure im formating it correctly or the SQL table wont understand it or kick an error within the POST.

So

What does 1614286027 represent in the SQL table for TIME? Any idea?

Hmm..
I must still be missing something. I made the edits to an SQL INSERT command and queried it to the system.
The result was good on the SQL output. It states that 2 rows were inserted successfully.  (Good because im testing this by inserting just two lines anyway)
BUT.....

when i go to the area on the FRONT end where the topics are supposed to show up.
1. I can see the topics created on the forum by way of the SQL command.
2. When i click a topic SUBJECT to open and read it, i get this error

404 Not Found
You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.
If difficulties persist, please contact the System Administrator of this site and report the error below.

 

Im going to bet the problem is the TIME format. Here is what i am inserting.
INSERT INTO `XXXXXXX_kunena_topics` (`id`, `category_id`, `subject`, `icon_id`, `label_id`, `locked`, `hold`, `ordering`, `posts`, `hits`, `attachments`, `poll_id`, `moved_id`, `first_post_id`, `first_post_time`, `first_post_userid`, `first_post_message`, `first_post_guest_name`, `last_post_id`, `last_post_time`, `last_post_userid`, `last_post_message`, `last_post_guest_name`, `rating`, `params`) VALUES
(114, 9, 'Luca Morris and Mozzy Rekorder - Stepping Stone Original Mix', 0, 0, 0, 0, 0, 1, 44, 0, 0, 0, 114, 1614286027, 42, 'Discuss this track below', 'Antifmradio', 114, 1614286027, 42, 'Discuss this track below', 'Antifmradio', 0, ''),
(115, 9, 'Armin van Buuren and BT - Always Assaf extended remix', 0, 0, 0, 0, 0, 1, 200, 0, 0, 0, 115, 1614286038, 42, 'Discuss this track below', 'Antifmradio', 115, 1614286038, 42, 'Discuss this track below', 'Antifmradio', 0, '');

antifm wrote:

ok cool i understand that part now. Thanks very much mate.
The final question is still about the POST TIME.

In my SQL table for example. I see a POST TIME as
1614286027
what is this representing? Number of seconds since the beginning of the year?
I want to create these topics and insert them but ill need to make sure i enter in a POST TIME for each one that represents a time always PRIOR to my activity on the SQL table. otherwise i could end up with a different problem
Also i need to make sure im formating it correctly or the SQL table wont understand it or kick an error within the POST.

So

What does 1614286027 represent in the SQL table for TIME? Any idea?
 

 

This number is just a timestamp, which is a precise time in seconds

xillibit wrote:

 

 

This number is just a timestamp, which is a precise time in seconds

Then i have no idea whats causing the 404 error.
I wonder what would happen if i delete the TIMESTAMP in the SQL table for these two lines.

If it works, ill just leave the TIME blank when i run the SQL next time

DAM!!!

Under Kunena Diagnostics tools, it found TWO broken links. I decided to have Kunena remove them and of course, it REMOVED the two topics i am trying to create lol

Ok so the links are broken, But why?

Under Kunena Diagnostics tools, it found TWO broken links.

In your case, this tool may not be able to fix it.
If an assignment is missing, it is recognized all affected entries as orphaned and orphaned entries are removed.
Example, the table #__com_kunena_topics contains a wrong category IP, it has effect to the tables #__com_kunena_user_topics, #__com_kunena_messages, #__com_kunena_message_txt
They are all now orphaned and listed in this tool.
It's better, you use it as a guide and check the listed errors in the database.