I manually injected some questions to my website without knowing anything about its dependency with other tables like qa_words, qa_titlewords or qa_contentwords etc. Now I realized I should write a script for bulk uploading which makes use of qa_question_create() function. Well, I can do it for future uplods, but how can I fix the problem with already uploaded questions? I have around 150+ questions which are not stemmed and stored in any other table. I want to retrieve all these questions from the database and calculate word count and then update qa_words and related tables. How do I do that?
Any help would be highly appreciated.
Thanks a lot.