gives this error while installing the backup
version 2.1 Beta 4
QuoteError
SQL query:
--
-- Tablo döküm verisi `smf_admin_info_files`
--
INSERT DELAYED IGNORE INTO `smf_admin_info_files` (`id_file`, `filename`, `path`, `parameters`, `data`, `filetype`) VALUES
(1, 'current-version.js', '/smf/', 'version=%3$s', 'window.smfVersion = \"SMF 2.1 Beta 3\";', 'text/javascript'),
(2, 'detailed-version.js', '/smf/', 'language=%1$s&version=%3$s', 'window.smfVersions = {\n \'SMF\': \'SMF 2.1 Beta 3\',\n \'TasksApprovePost-Notify.php\': \'2.1 Beta 3\',\n \'TasksApproveReply-Notify.php\': \'2.1 Beta 3\',\n \'TakssBuddy-Notify.php\': \'2.1 Beta 3\',\n \'TasksCreatePost-Notify.php\': \'2.1 Beta 3\',\n \'TasksEventNew-Notify.php\': \'2.1 Beta 3\',\n \'TasksGroupReq-Notify.php\': \'2.1 Beta 3\',\n \'TasksLikes-Notify.php\': \'2.1 Beta 3\',\n \'TasksMemberReport-Notify.php\': \'2.1 Beta 3\',\n \'TasksMemberReportReply-Notify.php\': \'2.1 Beta 3\',\n \'TasksMsgReport-Notify.php\': \'2.1 Beta 3\',\n \'TasksMsgReportReply-Notify.php\': \'2.1 Beta 3\',\n \'TasksRegister-Notify.php\': \'2.1 B[...]
MySQL said: Documentation
#1616 - DELAYED option not supported for table 'smf_admin_info_files'
Well what ever you use to create this backup,
it use a sql syntax which is not supported by you target database.
as the error message mention,
you should removed the "delayed" from your insert statement.
Looks like only MyISAM tables support it and seems right it is deprecated for mysql 5.7
https://dba.stackexchange.com/questions/160168/mysql-insert-delayed-deprecated-what-now
Does anyone know why it's done that way?
More details at https://mariadb.com/kb/en/library/insert-delayed/
But I do not see a reason for us to use it in this case since that table is not going to be access by any other thread on install.
I don't know what sort of "sgl" backup the op referred to.
Quote from: live627 on November 14, 2018, 10:58:14 PM
I don't know what sort of "sgl" backup the op referred to.
Hello Full replacement sgl
(https://i.imgur.com/BdOoXxl.jpg)
Quote from: vbgamer45 on November 14, 2018, 02:34:45 PM
Looks like only MyISAM tables support it and seems right it is deprecated for mysql 5.7
https://dba.stackexchange.com/questions/160168/mysql-insert-delayed-deprecated-what-now
Quote-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 10 Kas 2018, 14:33:11
-- Sunucu sürümü: 10.2.18-MariaDB
-- PHP Sürümü: 7.2.7
This issue does not have a zero in sql ?
Do a find and replace in the .sql file
Find
INSERT DELAYED
Replace with
INSERT