Ubuntu 16.10 LTS installation problem

[kirillbogdanov5960]

Hello Dear Support.

I have problem with script installation on my new Ubuntu 16.10 LTS machine (NGINX 1.10.0, PHP 7.0.4-7ubuntu2.1, MySQL 5.7.12).
When I go to install wizard (/install/) all checks passed, after I enter datadase params sript shows success connection, but after I click next it shows nothing on step 2 (server not responding with 500 error)

I also try to install script manually and folow instructions, but when I try to import from database.sql file (via adminer script) it shows me a lot of errors.

Please see the errors below.

CREATE TABLE `stats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`referer` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`referer_is_local` tinyint(4) NOT NULL DEFAULT '0',
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`country` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`img_search` tinyint(4) NOT NULL DEFAULT '0',
`browser_family` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`browser_version` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`os` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`os_version` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_agent` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`base_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMA...
Error in query (1067): Invalid default value for 'dt'
-- ----------------------------
-- Records of file_server
-- ----------------------------
INSERT INTO `file_server` VALUES ('1', 'Local Default', 'local', '', '', '0', '', null, '2', null)
Error in query (1265): Data truncated for column 'connectionMethod' at row 1
ALTER TABLE `stats` ADD INDEX ( `dt` )
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` ADD INDEX ( `page_title` )
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
INSERT INTO site_config (config_key, config_value, config_description, config_type, config_group) SELECT 'site_admin_email', config_value, 'The email address all site admin emails will be sent.', 'string', 'Page Options' FROM site_config WHERE config_key='report_abuse_email'
Error in query (1364): Field 'availableValues' doesn't have a default value
INSERT INTO `plugin` VALUES(NULL, 'PayPal Payment Integration', 'paypal', 'Accept payments using PayPal.', 1, '0000-00-00 00:00:00', '{"paypal_email":"[email protected]"}', 1)
Error in query (1292): Incorrect datetime value: '0000-00-00 00:00:00' for column 'date_installed' at row 1
CREATE TABLE `session_transfer` (`id` INT(11) NULL, `transfer_key` VARCHAR(32) NOT NULL, `session_id` VARCHAR(32) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM
Error in query (1171): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
ALTER TABLE `session_transfer` ADD `date_added` DATETIME NOT NULL
Error in query (1146): Table 'yetishare_file_hosting.session_transfer' doesn't exist
ALTER TABLE `session_transfer` ADD INDEX ( `date_added` )
Error in query (1146): Table 'yetishare_file_hosting.session_transfer' doesn't exist
ALTER TABLE `session_transfer` ADD INDEX ( `session_id` )
Error in query (1146): Table 'yetishare_file_hosting.session_transfer' doesn't exist
ALTER TABLE `session_transfer` ADD INDEX ( `transfer_key` )
Error in query (1146): Table 'yetishare_file_hosting.session_transfer' doesn't exist
ALTER TABLE `session_transfer` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT
Error in query (1146): Table 'yetishare_file_hosting.session_transfer' doesn't exist
ALTER TABLE `stats` DROP INDEX `page_title`
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` DROP INDEX `dt`
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` CHANGE `page_title` `file_id` INT( 11 ) NOT NULL
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` ADD INDEX ( `file_id` )
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` CHANGE `dt` `download_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` ADD INDEX ( `download_date` )
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` DROP `img_search`
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` CHANGE `country` `country` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` DROP `url`
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` DROP `os_version`
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `stats` DROP `browser_version`
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
ALTER TABLE `file_server` ADD `lastFileActionQueueProcess` TIMESTAMP NOT NULL DEFAULT 0
Error in query (1067): Invalid default value for 'lastFileActionQueueProcess'
ALTER TABLE `stats` CHANGE `ip` `ip` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
DROP TABLE session_transfer
Error in query (1051): Unknown table 'yetishare_file_hosting.session_transfer'
ALTER TABLE `stats` ADD `user_id` INT( 11 ) NULL DEFAULT NULL
Error in query (1146): Table 'yetishare_file_hosting.stats' doesn't exist
UPDATE user_level SET wait_between_downloads = (SELECT config_value FROM site_config WHERE config_key = 'paid_user_wait_between_downloads' LIMIT 1) WHERE level_id >= 2
Error in query (1048): Column 'wait_between_downloads' cannot be null
UPDATE user_level SET days_to_keep_inactive_files = (SELECT config_value FROM site_config WHERE config_key = 'premium_user_upload_removal_days' LIMIT 1) WHERE level_id >= 2
Error in query (1366): Incorrect integer value: '' for column 'days_to_keep_inactive_files' at row 2
UPDATE user_level SET max_download_filesize_allowed = (SELECT config_value FROM site_config WHERE config_key = 'paid_user_max_download_filesize' LIMIT 1) WHERE level_id >= 2
Error in query (1048): Column 'max_download_filesize_allowed' cannot be null
UPDATE user_level SET max_storage_bytes = (SELECT config_value FROM site_config WHERE config_key = 'non_user_maximum_storage' LIMIT 1) WHERE level_id = 0
Error in query (1048): Column 'max_storage_bytes' cannot be null
1,468 queries executed OK. (0.610 s)


Please help me to solve this issue. Thank you.

 

[adam]

You have strict mode enabled within MySQL. See here to disable it:

https://support.mfscripts.com/public/kb_view/59/

 

[kirillbogdanov5960]

Thank you for quick reply, I disable strict mode:

mysql> SELECT @@sql_mode;
+------------+
| @@sql_mode |
+------------+
| |
+------------+
1 row in set (0.00 sec)

Now I have another error:

CREATE TABLE `session_transfer` (`id` INT(11) NULL, `transfer_key` VARCHAR(32) NOT NULL, `session_id` VARCHAR(32) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM
Error in query (1171): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

 

[lart2422]

I know this is an old thread however im having a similar issue trying to migrate to a new server (Ubuntu 16.04.3 LTS).

MYSQL strict mode is switched off. Did the op ever get this resolved? Does anyone have any insights into how this can be resolved?

My specific issue is as follows;

SQLSTATE[42000]: Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

 

[adam]

Hi,

Please can you link your forum account to your license via mfscripts.com. You can do this by logging in to that site using your account details and going into account settings. After 10 minutes, logout and back into this forum so your account can be linked.

Thanks,
Adam.