Please help - restoring an SMF instance without much help

[Sir Osis of Liver]

If you copied your theme files from old install to new clean install, they may contain mod code from mods that were previously installed on old install.  You should reinstall your theme from original package before reinstalling mods on new server.  Tables and settings that were added to database by mods would be ignored in clean install.  The default value error is easily fixed by setting the field to NULL if you want to keep the mod table.

[Steve]

OP believes the problem solved so without further input, I'm marking it so.