Question SMF 1.1.10 to Joomla 1.5.15 and Kunena 1.5.6

s.span wrote:

After migration I see all topics and posts. Even the post count in Kunena is exactly the same as in SMF. I can even read all the topics and post, even 24 hours after the migration.
But then when I add a topic or delete a post/topic or use the recount category button 60% disappears.
I checked Kunena mysql tables after conversion to see all posts are there. But again, after I add a topic or delete a post/topic or use the recount category button 60% disappears, even more than 24 hours after using the migration script. And in the tables in mysql all posts are gone...
I have tried several times with a clean installation, have downloaded joomla / kunena / migration script several times, because I thought may be something got corrupted there, but it makes no difference, each time everything migrates fine, but then I loose 60%...

Ok that is partially good news.

However if the recount makes the numbers drop by 60%, it suggests that those 60% have never been loaded and the category stats that have been written where not produced by Kunena.

A migration script can easily write the number of posts and topics into the category headers. That would make it look like all posts are there. The recount does not delete anything - there is no delete statement in the code. It simply counts the real number of topics and messages. If these numbers are 60% lower, it means the migration has not successfully migrated all data. This could still be a timeout issue or a datamodel issue. there are various flags and settings that need to be written correctly in order to work.

How did you check the mysql tables did you run a

That would return the number of total topics in the database

This one the number of total messages:

Even if these numbers are correct there is a chance that some messages got linked incorrectly and are ghosts without proper threads.

Too many possibilities to list all of them.

Any way you look at this, it is clearly a migration script problem.

Addition a new topic only forces the forum to recount some of the stats. So if something is wrong in the database, this will then be visible.

Hope this helps!

FidelGonzales wrote:

I am having an issue with the referenced script and am receiving the following error.

Parse error: syntax error, unexpected T_DNUMBER in /home/content/d/e/d/ded/html/smf/mysql.php on line 8

Obviously, the database is temporarily on a GoDaddy shared server. Therefore, it does not use local host. On line 8, here is my details that I have entered. Please verify whether I must enter configuration details on Line 8 or on another line. Here is what I have.

Code:

if( false == mysql_connect($MYSITE.db.4155336.hostedresource.com , $NAME, $PASSWORD) ) /// FILL with your connections details ie location is usually localhost etc.

Any assistance is appreciated. Thank you.

Do you guys have any advice on proper configuration? Thanks.