Advertisement:

Author Topic: Error in sgl  (Read 1261 times)

Offline gecitli

  • Jr. Member
  • **
  • Posts: 280
    • webmaster forumu
Error in sgl
« on: November 14, 2018, 04:11:37 AM »
gives this error while installing the backup
version 2.1 Beta 4

Quote
Error
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.

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 589
Re: Error in sgl
« Reply #1 on: November 14, 2018, 02:30:11 PM »
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.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,619
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Error in sgl
« Reply #2 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
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

Offline live627

  • Development Contributor
  • SMF Hero
  • *
  • Posts: 5,620
  • Gender: Male
    • live627 on Facebook
    • live627 on GitHub
    • live627 on LinkedIn
    • @live627 on Twitter
    • livemods
Re: Error in sgl
« Reply #3 on: November 14, 2018, 08:41:29 PM »
Does anyone know why it's done that way?
Try not to become a man of success, but rather try to become a man of value.
- Albert Einstein

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,619
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Error in sgl
« Reply #4 on: November 14, 2018, 09:08:37 PM »
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

Offline live627

  • Development Contributor
  • SMF Hero
  • *
  • Posts: 5,620
  • Gender: Male
    • live627 on Facebook
    • live627 on GitHub
    • live627 on LinkedIn
    • @live627 on Twitter
    • livemods
Re: Error in sgl
« Reply #5 on: November 14, 2018, 10:58:14 PM »
I don't know what sort of "sgl" backup the op referred to.
Try not to become a man of success, but rather try to become a man of value.
- Albert Einstein

Offline gecitli

  • Jr. Member
  • **
  • Posts: 280
    • webmaster forumu
Re: Error in sgl
« Reply #6 on: November 15, 2018, 05:42:15 AM »
I don't know what sort of "sgl" backup the op referred to.

Hello Full replacement sgl



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.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,619
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Error in sgl
« Reply #7 on: November 15, 2018, 08:11:38 AM »
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