Solved SQL query to populate user_topics table?

Anybody got a SQL query for this? Or is there a built-in function I haven't come across yet?

Well, an SQL query to populate a table is easy... but not without knowing what it is you want to populate it with. Why would you want to inject anything into this table through a query, rather than through the Kunena interface?

Kunena has API in directory /libraries/kunena so you don't know how to make the query but you need to know how to use the API

I have loaded messages and topics into tables from another forum and needed to reconstruct the contents of this table, which I have now done.

This blog post gave a useful SQL query for another necessary update, similar to the one I asked about (to save time and as my SQL knowhow is very rusty and I'm not that interested in getting to seriously to grips with it again for a one-shot task).

> "An SQL query is easy"

I wouldn't have asked if it was quite as easy that!

Sorry. My "easy" comment was not meant to be snarky. I just meant that (for some of us) writing an SQL insert query is easy, but even the best of us can't write a query without knowing what is being inserted.

If you had provided the information that was in your follow-up post into your original post, you probably would have had a more complete answer, much quicker.

Glad you got it solved.

Sorry I wasn't clearer; I thought populate the table given a set of attachments and message nrs was enough. No worries.

I used Excel to create the records for SQL to insert from hashes and filesizes etc. Worked fine apart from one thing I've yet to resolve.

Somewhere I need to update counters for nrs of topics (and attachments?). I get a SQL insert error when I try to add a new topic--now that I've got all my old data (users, topics, messages, incl. text and attachments) loaded.