Upgrading from Vanilla1 > Vanilla 2 error in import process "Column 'CountComments' cannot be null"

rockwaldo

Column 'CountComments' cannot be null|Gdn_Database|Query|update GDN_Category p set p.CountComments = ( select sum(c.CountComments) from GDN_Discussion c where p.CategoryID = c.CategoryID)

I've looked through the old forum data and I can't seem to work out what can be causing it. It looked like it may be a few discussions that had been deleted with no live comments, but even after removing them I still get the error message above at the "recreating Count" step (exact name I cant remember, 3rd from last one)

Any ideas?

davidE44

Not sure if anyone else is running into this problem but it is caused by trying to migrate empty nodes. For example Category NodeA contains Forum NodeB and Forum NodeC. The forum nodes contain messages but the category node does not. You can fix this by changing applications/dashboard/models/class.importmodel.php : 466

// Add IFNULL(..., 0) around the inner select statement

$Result = "update :_$ParentTable p
                  set p.$ParentColumnName = IFNULL((
                     select $Aggregate(c.$ChildColumnName)
                     from :_$ChildTable c
                     where p.$ParentJoinColumn = c.$ChildJoinColumn), 0)";

Hope this helps someone.