Migrating an older site and getting errors in the installer

[digitex]

I exported the profile, added it to the installer just as you should and I get this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'published' in 'INSERT INTO'

I can't find INSERT INTO in phpmyadmin and I don't know how to solve it. Can anyone shed light?

[digitex]

I went ahead and finished the installation to see what happens and I got this error which is bizarre to me:

Error: Exception: Template 'admin' is used by the homepage and thus must have the 'guest' role assigned. (in wire/core/Templates.php line 287)

I can't understand why the home template got replaced by admin which should not be publicly accessible. I'm pulling my hair out.

[digitex]

I think I fixed it. I did a clean install with a blank profile then I imported the SQL straight into phpmyadmin then copied the assets, templates and modules into the site folder. Using the export profile and creating a custom installer is supposed to be seamless but not so much. Things look like they're going to be ok.