!! UPDATE !! This is informational only at this point. I'm moving the site and reinstalling from scratch. I do believe the failed first attempt that currupted the DB had to do with the forced SSL on the server. Just a thought.
My install crashed 1/2 way thorugh with an SSL error (I have forced HTTPS on the site). I turned of the HTTPS redirect and ran the installer again and got this far:
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'itchatterbox20170930.xf_style_property_definition' doesn't exist in
src/XF/Db/AbstractStatement.php at line
183
- XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 34
- XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 44
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 84
- XF\Db\AbstractAdapter->fetchAll() in src/XF/Install/Upgrade/2000010-200a.php at line 503
- XF\Install\Upgrade\Version2000010->step6() in src/XF/Install/Controller/Upgrade.php at line 155
- XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1831
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in install/index.php at line 14
So I did this:
CREATE TABLE IF NOT EXISTS `xf_style_property_definition` (
`property_definition_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`definition_style_id` int(11) NOT NULL,
`group_name` varchar(25) DEFAULT NULL,
`title` varchar(100) NOT NULL,
`description` varchar(255) NOT NULL DEFAULT '',
`property_name` varchar(100) NOT NULL,
`property_type` enum('scalar','css') NOT NULL,
`css_components` blob NOT NULL,
`scalar_type` enum('','longstring','color','number','boolean','template') NOT NULL DEFAULT '',
`scalar_parameters` varchar(250) NOT NULL DEFAULT '' COMMENT 'Additional arguments for the given scalar type',
`addon_id` varchar(25) NOT NULL,
`display_order` int(10) unsigned NOT NULL DEFAULT '0',
`sub_group` varchar(25) NOT NULL DEFAULT '' COMMENT 'Allows loose grouping of scalars within a group',
PRIMARY KEY (`property_definition_id`),
UNIQUE KEY `definition_style_id_property_name` (`definition_style_id`,`property_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=327 ;
and now I get this:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'property.property_definition_id' in 'on clause' in
src/XF/Db/AbstractStatement.php at line
183
- XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 34
- XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 44
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 84
- XF\Db\AbstractAdapter->fetchAll() in src/XF/Install/Upgrade/2000010-200a.php at line 503
- XF\Install\Upgrade\Version2000010->step6() in src/XF/Install/Controller/Upgrade.php at line 155
- XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1831
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in install/index.php at line 14