Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions

You are not logged in.

Announcement

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

Hamburgo
Member
Registered: 2017-09-21
Posts: 25

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

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

Offline

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

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

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

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.


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

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

Hamburgo
Member
Registered: 2017-09-21
Posts: 25

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

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.

Offline

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

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

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

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


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

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

Hamburgo
Member
Registered: 2017-09-21
Posts: 25

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

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.

Offline

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

Hamburgo
Member
Registered: 2017-09-21
Posts: 25

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

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.

Offline

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

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

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

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


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

Board footer