Solved SQL query to populate user_topics table?

harmlessdrudge wrote: Somewhere I need to update counters for nrs of topics (and attachments?).

You should not need to write something "custom". Use the Recount Statistics feature in the backend (I think there's a Wiki article about this).

harmlessdrudge wrote: 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

Different problem, I think, and deserves a separate topic?

Speaking of separate topics, you combined two issues in another topic you posted here: Loading attachments problem and question . You correctly resolved the essential problem (uploading attachments with file types that are not on the allowed "list") but the other matter seems to be related to this topic. Have you also figured out the answer to the other matter and can your other topic be closed?

You should not need to write something "custom".

I would hope not! A SQL query is ok, if not too complicated. Actually, I tried that already (recounting the statistics).

The error message is 0 SQL=INSERT INTO `jos_kunena_topics` (`category_id`,`subject`,`hold`) VALUES ('2','Test new topic','4')

I've no idea what the 'hold' is about.

Yes, it's good point about the topics. My original problem was getting attachments into Kunena without entering them manually, and this I have now done. I was about to about post that I then got an error on adding an attachment (despite recounting statistics), and I found that actually the error was topic related.

I suppose it's involved somehow but I don't know how: I discovered that my import from Ning had missed the very first topic, so I incremented all the topic numbers (and thread nrs) and made the corresponding adjustments, including recreating indices, throughout, so that I have a new topic 1. It all looks fine, every thread, every topic, every attachment, and the totals in jos_kunena_categories for posts and replies are all fine.

PS Yes, other topic can be closed. Thanks.

Update: a record 0 is inserted despite the error, but no corresponding message record is entered. I can see one possibility: I've assumed that topics are 1...N (a single range) but if they're counted separately per category then... No, I don't think so. They were numbered 1..N earlier and I could add new topics.

Update 2: I inadvertently omitted AUTO_INCREMENT when recreating the index :woohoo:!

OK. That was it. Everything working now. I have successfully finished a migration from Ning. Just need to get avatars moved and then start to see what I can do to get everything else about the site working.

Hold is a value (normally it is 0 or 1) that defines whether a post is approved or not approved and should be of type tinyint(4). I don't know how this relates to the table _kunena_user_topics because the column is contained in the table _kunena_topics. It sounds like there's some database referential integrity problem at play (or possibly SQL syntactical problem).

Did you find that using Kunena Forum: Forum Tools » Recount Statistics answered your question about recounting your forum statistics?

Ah, ok. Makes sense. Thanks.

Is there any narrative account of the data structures anywhere? I can read and work out code if necessary but English is easier.

BTW No, recounting didn't fix (forum stats were fine), however I have a lead (see previous message).

harmlessdrudge wrote: Is there any narrative account of the data structures anywhere? I can read and work out code if necessary but English is easier.

A little off-topic to the central point of this topic - but a question that we're asked from time to time (and one that I wish I had a good reply to) - but not really the full-blown narrative discussion about the columns in within the Kunena-related tables, how they are used or how they're interrelated. Even today, I don't think the people on the Kunena development team have all the answers, either.

This topic may help What are the table names for K 3.0? . Remembering that Kunena is a dynamic open-source project - and the database structures are always changing - you can bet that the moment someone finishes documenting how everything works for K x.y it will be out of date when K x.y+1 is released. Therefore, in the absence of paying someone to maintain this kind of documentation and (as we all know, programmers are terrible at writing documentation) because maintaining this information as an unrequited "act of love", that's the way things stand.

harmlessdrudge wrote: BTW No, recounting didn't fix (forum stats were fine), however I have a lead (see previous message).

I hope the lead was a good one.

*** Off-topic ***

I empathise with the difficulties you are encountering in converting from a different forum to Kunena and I wrote about some of those challenges in my article I want to migrate my forum to Kunena ... . For what it's worth.

This topic may help What are the table names for K 3.0?.

I have been using PhpMyAdmin and HeidiSQL to inspect and change the tables, both by editing directly and with SQL commands. HeidiSQL has a favourites button that I've set up to filter tables with the word "kunena" in them with a click (PhpMyAdmin is a little fussier to use in this respect but has some other advantages). So... I do know which are the Kunena tables!

I have figured out quite a bit by observation and some trial and error. I don't mind the non-existence of any document (I understand the dynamics you refer to) and would care more if there was information available but I couldn't find it.

Many thanks for your patience and responsiveness.

I think I have pretty much completed a migration from ning. Well... I need to go through a number of messages and update the links to images that are coming from ning now to local copies, import some avatars... and ??

There are however still very basic things I don't know yet. E.g. what the relation is between users in Joomla and Kunena (I've never used Joomla before btw). Of course, I did not sit down and read everything I could find on Kunena before starting, and don't know yet information exists beyond what I've skimmed on the wiki.

I have made some updates to the migrating from Ning post and could add a bit more if you think there's any demand (lots on Wordpress/Buddypress site). It seems I tried to made every mistake!