News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Error in sgl

Started by gecitli, November 14, 2018, 04:11:37 AM

Previous topic - Next topic

gecitli

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'
http://www.webtiryaki.com
webmaster forumu
Free & Premium Responsive Themes for SMF.

albertlast

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.

vbgamer45

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
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

live627

Does anyone know why it's done that way?

vbgamer45

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.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

live627

I don't know what sort of "sgl" backup the op referred to.

gecitli

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



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 ?
http://www.webtiryaki.com
webmaster forumu
Free & Premium Responsive Themes for SMF.

vbgamer45

Do a find and replace in the .sql file
Find
INSERT DELAYED
Replace with
INSERT
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: