• Hey Guest, we're evolving the future of TeaSpeak.
    You're invited to join the discussion here!

Completed Could not initialize SQL

BIOS

BIOS

TeaSpeak Team
Staff member
TeaTeam
i updated the server to latest version and have an sql problem

vvcap 2020-08-05-11-24-28.png
 
yamano

yamano

TeaSpeak Team
Staff member
TeaTeam
Did you have a backup of the old teaspeak version?
Cause it is well described in the changelog to do it before update.
(in my case it is always doing it automatically)
 
BIOS

BIOS

TeaSpeak Team
Staff member
TeaTeam
Of course, before each instance update, I create a backup because I can't keep my customers waiting for hours before solving a problem ;)
 
grepher76

grepher76

Well-known member
failed to upgrade database: sql: CREATE TABLE general_dg_tmp(id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, key VARCHAR(256), value TEXT); returned -> -1/failed to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VARCHAR(256), value TEXT)' at line 1

Version: 1.4.19-1 :(
 
WolverinDEV

WolverinDEV

TeaSpeak Team
Staff member
Administrator
grepher76 said:
failed to upgrade database: sql: CREATE TABLE general_dg_tmp(id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, key VARCHAR(256), value TEXT); returned -> -1/failed to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VARCHAR(256), value TEXT)' at line 1

Version: 1.4.19-1 :(
Click to expand...
Arg.... MySQL required the key parameter to be escaped....

---- Automatically Merged Double Post ----

Fixed with the next build
 
Last edited:
grepher76

grepher76

Well-known member
Humm ...

[2020-08-19 17:05:36] [CRITICAL] GEN | Could not initialize SQL!
[2020-08-19 17:05:36] [CRITICAL] GEN | sql: DELETE FROM `general` WHERE `id` IN (SELECT `id` FROM `general` WHERE `key` = :key ORDER BY `key` LIMIT -1 OFFSET 1); returned -> -1/failed to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1 OFFSET 1)' at line 1

Version: 1.4.19-2 :(
 
grepher76

grepher76

Well-known member
I still have the same problem on the beta version: 1.4.19-3

Code: 
[2020-08-20 12:00:55] [DEBUG] Log successfully started!
[2020-08-20 12:00:55] [INFO ]   GEN | Starting TeaSpeak-Server v1.4.19 [Build: 1597313187]
[2020-08-20 12:00:55] [INFO ]   GEN | Starting music providers
[2020-08-20 12:00:55] [DEBUG] [Music] Provider load order:
[2020-08-20 12:00:55] [DEBUG] [Music] [0] providers/000ProviderFFMpeg.so
[2020-08-20 12:00:55] [DEBUG] [Music] [1] providers/001ProviderYT.so
[2020-08-20 12:00:55] [DEBUG] [Music] [FFMPEG] Using config file located at providers/config_ffmpeg.ini
[2020-08-20 12:00:55] [DEBUG] [Music] [FFMPEG] Missing configuration file. Using default values
[2020-08-20 12:00:55] [DEBUG] [Music] [FFMPEG] Executing command "ffmpeg -version"
[2020-08-20 12:00:55] [INFO ] [Music] [FFMPEG] Resolved ffmpeg with version "ffmpeg version 3.2.15-0+deb9u1 Copyright (c) 2000-2020 the FFmpeg developers"
[2020-08-20 12:00:55] [DEBUG] [Music] [FFMPEG] Executing command "ffmpeg -protocols"
[2020-08-20 12:00:55] [DEBUG] [Music] [FFMPEG] Executing command "ffmpeg -formats"
[2020-08-20 12:00:56] [INFO ] [Music] Loaded successfully provider FFMpeg
[2020-08-20 12:00:56] [INFO ] [Music] Loaded successfully provider YouTube
[2020-08-20 12:00:56] [INFO ] [Music] [YT-DL] Compiling patterns
[2020-08-20 12:00:57] [INFO ] [Music] [YT-DL] Patterns compiled (1088ms)
[2020-08-20 12:00:59] [DEBUG]   GEN | Created a new async thread pool!
[2020-08-20 12:00:59] [INFO ]   GEN | Upgrading database from version -1 to 15. This could take a moment!
[2020-08-20 12:01:01] [INFO ]   GEN | Database upgrade took 2408ms
[2020-08-20 12:01:01] [CRITICAL]   GEN | Could not initialize SQL!
[2020-08-20 12:01:01] [CRITICAL]   GEN |  sql: DELETE FROM `general` WHERE `id` IN (SELECT `id` FROM `general` WHERE `key` = :key ORDER BY `key` LIMIT 1, -1); returned -> -1/failed to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
[2020-08-20 12:01:01] [INFO ]   GEN | Stopping application
[2020-08-20 12:01:01] [INFO ]   GEN | Application suspend successful!
 
WolverinDEV

WolverinDEV

TeaSpeak Team
Staff member
Administrator
hmmm, that command should work thou :D

---- Automatically Merged Double Post ----

Fixed in 1.4.19-beta 4 ;)
 
Last edited:
You must log in or register to reply here.