Error when installing Yellowfin into MySQL : 'ERR_INSERTQUERY'

David Registro shared this problem 3 years ago
Resolved

When installing Yellowfin, I'm getting the following error:


ERR_INSERTQUERY

Query:

INSERT

INTO ReferenceCodeDesc (`RefTypeCode`, `RefVersion`, `RefCode`, `LanguageCode`,

`ShortDescription`, `LongDescription`, `ScreenSortOrder`) VALUES (?, ?, ?, ?,?, ?, ?)


5a646527473eaf7b33629247cb958efb


What does this mean, and how can I install Yellowfin?

Comments (1)

photo
1

This error is almost exclusive to MySQL and is related to the character encoding of the database you're installing into.

The character set can be set at a database level, or sever level, so there are 2 ways around this.


  1. Create a new database and explicitly set it to use UTF-8
  2. Set your MySQL server level to use UTF-8

For option 1, you can use the query below to create a new blank DB called 'yellowfin' which is set to use UTF-8:

CREATE DATABASE `yellowfin` CHARACTER SET utf8 COLLATE utf8_general_ci;

Note,

the above will created a blank database called 'yellowfin', so if you already

have a 'yellowfin' DB, you can delete it, change the name in the above query.


Once you have done this, re-install Yellowfin, and ensure you do NOT tick 'create

new database' option.

7a0dda8c8b1b0ed71180c6fdc2f039ae


For option 2 , this is done via MySQL configuration, and can be done in a few different ways.

See the following article for some detailed information on this.

Comments have been locked on this page!