Error when installing Yellowfin into MySQL : 'ERR_INSERTQUERY'
Resolved
When installing Yellowfin, I'm getting the following error:
ERR_INSERTQUERY
Query:
INSERT
INTO ReferenceCodeDesc (`RefTypeCode`, `RefVersion`, `RefCode`, `LanguageCode`,
`ShortDescription`, `LongDescription`, `ScreenSortOrder`) VALUES (?, ?, ?, ?,?, ?, ?)
What does this mean, and how can I install Yellowfin?
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.
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.
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!