SQL error: Exporting report ‘[report name]’, Incorrect string value

SQL error: Exporting report ‘[report name]’, Incorrect string value

Info
When you see the error message "SQL error: Exporting report '[report name]', Incorrect string value" in your PMA Hub under Exports > SQL > View Logs, it indicates that your MySQL server is unable to process certain characters in your data.

Error

"SQL error: Exporting report '[report name]', Incorrect string value"


Cause

This error occurs due to a character set incompatibility between Power My Analytics exports and your MySQL server. This means your data contains characters that aren't supported by your server's default character set.

Solution

To fix this issue, you'll need to change your MySQL server's character set to utf8mb4.

Alert
This procedure requires administrator access to your MySQL server and can only be performed by you or your database administrator. Power My Analytics support cannot make these changes to your database for you.

Step 1: Access Your MySQL Server

Connect to your MySQL server with administrator privileges using your preferred method (command line, SSH, or administration tool).

Step 2: Change the Server Character Set

Run the following command to change the server's character set:

mysqld --character-set-server=utf8mb4

After modifying the configuration file, restart your MySQL server for the changes to take effect.

Step 3: Verify the Changes

You can verify that the character set has been changed by running:

SHOW VARIABLES LIKE 'character_set%';

The character_set_server variable should now show utf8mb4.

Step 4: Retry Your Export

Return to your Power My Analytics hub and run your export again. Check the logs to verify that it has completed successfully.


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket