SQL errors for 'hubloc' on channel cloning
Here what I got on channel clonning procedure in Hubzilla log
2018-10-06T11:16:11Z:LOG_INFO:8df037f595:Import.php:193:import_account: import step 3
2018-10-06T11:16:11Z:LOG_INFO:8df037f595:zot.php:669:zot_gethub: Not found: Array
(
[guid] => ee274ff05156013698a20200009947b7
[guid_sig] =>
[url] => https://diaspora.xpr.pl
[url_sig] =>
[sitekey] =>
)
2018-10-06T11:16:11Z:LOG_ERR:8df037f595:dba_driver.php:459:db_logger: dba_pdo: ERROR: INSERT INTO `hubloc` (`hubloc_guid`, `hubloc_guid_sig`, `hubloc_hash`, `hubloc_add
SQLSTATE[HY000]: General error: 1364 Field 'hubloc_id_url' doesn't have a default value
2018-10-06T11:16:11Z:LOG_INFO:8df037f595:zot.php:669:zot_gethub: Not found: Array
(
Seems it happens because of we have index for 'hubloc_id_url' field (and 'hubloc_site_id' too) but value to build it isn't provided on import. I modified the table structure by adding empty string as default value for those two fields and on test channel cloning procedure this errors is gone.
P.S. Perhaps this is one more MySQL 8 related issue.
Edited by Max Kostikov