update_169.sql: SQL Error (1064): You have an error in your SQL syntax

Hamburgo · 2018-06-30 05:34:11

Hello,
I am upgrading the database manual using the files from the current version.

The version of MySQL is: 5.6.20 / SQL-Management-Tool: HeidiSQL V 9.5.0.5196

Running the file update_169.sql, I got a error as follow at table lh_generic_bot_group:

/* 2018-06-30 06:34:13 [] */ /* Loading file "R:\TDL\Downloads\livehelperchat-master_V297\livehelperchat-master\lhc_web\doc\update_db\V297\update_169.sql" (1,8 KiB) into query tab #1 ... */

/* 2018-06-30 06:34:15 [KMU-Office] */ CREATE TABLE `lh_generic_bot_bot` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, PRIMARY KEY (`id`)) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/* 2018-06-30 06:34:15 [KMU-Office] */ ;

CREATE TABLE `lh_generic_bot_group` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `bot_id` bigint(20) NOT NULL, PRIMARY KEY (`id`), KEY `bot_id` (`bot_id`)) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/* 2018-06-30 06:34:15 [KMU-Office] */ /* SQL Fehler (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';

CREATE TABLE `lh_generic_bot_group` ( `id` bigint(20) NOT NULL AUTO_INCREMENT' at line 1 */
/* 2018-06-30 06:34:43 [] */ /* Betroffene Zeilen: 0 Gefundene Zeilen: 0 Warnungen: 0 Dauer von 1 of 7 Abfragen: 0,047 sec. */

Many thanks for help.

Regards

PeopleInside · 2018-06-30 06:36:27

Hi Hamburgo,
are you operating directing on the database? If yes you must be expert and know what you are doing.

If your scope is upgrade LHC you can find the relative guide here: https://livehelperchat.com/article/view/63
Always make a backup of your working install (database and folder) before do any upgrade so if an error occur you can resume and maybe try again.

Hamburgo · 2018-06-30 08:58:42

Hi PeopleInside,
I will be expert enough to know what I do in this easy case, but I am not an expert in the different dialects
of MySQL, more in FireBird-SQL.

I am open only your original sql-script "update_169.sql" from the folder "livehelperchat-master\lhc_web\doc\update_db"
in the popular database-manager HeidiSQL and than I am clicking on run, out of any changes.

I did it, too, with 10 other of your sql-scripts, out of any problems. Only the 169 has an syntax-error.

But I do not have the skill, to analyze MySOL-Codes from other programmers.

I believe, you know what you do in this script, because your team are the autor.

PeopleInside · 2018-06-30 11:24:08

I cannot help with this but I will inform the chat owner. I do not think is an issue in live helper chat,
can be something you have done or maybe if is long time you do not update LHC.

Consider that free support are limited, the chat owner can be busy.
https://forum.livehelperchat.com/viewtopic.php?id=2255

Hamburgo · 2018-06-30 11:59:30

Can be that you can not help.

Thanks for the hint to the chat owner. I am sure, that he can help.

I believe that this script will be created under a newer MySQL-engine
as my one (5.6.20). This script is from april this year.

He is an professional and will be use the newest one.

Hamburgo · 2018-06-30 12:17:44

Ok, we can close this issue.

Your internal LHC-database-update-function was be able to make the modifications of
your sql-scripts Update_169.sql to _172.sql in the database out of problems.

So, I believe that the version-check of HeidiSQL will be to much sensitive.

PeopleInside · 2018-06-30 12:27:27

Happy to know the issue is resolved, thank you for the feedback!

Announcement

#1 2018-06-30 05:34:11

update_169.sql: SQL Error (1064): You have an error in your SQL syntax

#2 2018-06-30 06:36:27

Re: update_169.sql: SQL Error (1064): You have an error in your SQL syntax

#3 2018-06-30 08:58:42

Re: update_169.sql: SQL Error (1064): You have an error in your SQL syntax

#4 2018-06-30 11:24:08

Re: update_169.sql: SQL Error (1064): You have an error in your SQL syntax

#5 2018-06-30 11:59:30

Re: update_169.sql: SQL Error (1064): You have an error in your SQL syntax

#6 2018-06-30 12:17:44

Re: update_169.sql: SQL Error (1064): You have an error in your SQL syntax

#7 2018-06-30 12:27:27

Re: update_169.sql: SQL Error (1064): You have an error in your SQL syntax

Board footer