Title: Mysql Error upon upload
Last modified: January 4, 2018

---

# Mysql Error upon upload

 *  Resolved [dorysp](https://wordpress.org/support/users/dorysp/)
 * (@dorysp)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/mysql-error-upon-upload/)
 * I am uploading my site to a live server and I am getting the following error 
   message while uploading the db to mysql. This server is using php v5.6. Does 
   your player work with this version of php?
 *     ```
       Error
   
       SQL query:
   
       CREATE TABLE <code>wp_zxyn_huge_it_videos</code> (
       <code>id</code> int( 11 ) UNSIGNED NOT NULL ,
       <code>name</code> varchar( 100 ) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ,
       <code>video_player_id</code> varchar( 200 ) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ,
       <code>video_url_1</code> text COLLATE utf8mb4_unicode_520_ci,
       <code>image_url</code> text COLLATE utf8mb4_unicode_520_ci,
       <code>video_url_2</code> varchar( 128 ) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ,
       <code>sl_type</code> text COLLATE utf8mb4_unicode_520_ci NOT NULL ,
       <code>video_width</code> text COLLATE utf8mb4_unicode_520_ci NOT NULL ,
       <code>ordering</code> int( 11 ) NOT NULL ,
       <code>published</code> tinyint( 4 ) UNSIGNED DEFAULT NULL
       ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci;
   
       MySQL said: Documentation
       #1273 - Unknown collation: 'utf8mb4_unicode_520_ci'  
       ```
   

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [huge-it-support-1](https://wordpress.org/support/users/huge-it-support-1/)
 * (@huge-it-support-1)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/mysql-error-upon-upload/#post-9836129)
 * Dear dorysp,
 * Thanks for your post.
    Please find the video-player.php file and in line 448 
   change
 * $collate = $wpdb->get_charset_collate();
 * to
 * $collate = “DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci”;
 * Looking forward to hearing from you soon.
 * Thanks
 *  Thread Starter [dorysp](https://wordpress.org/support/users/dorysp/)
 * (@dorysp)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/mysql-error-upon-upload/#post-9837590)
 * Sorry, that did not work. I received the same error message.
 *  Thread Starter [dorysp](https://wordpress.org/support/users/dorysp/)
 * (@dorysp)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/mysql-error-upon-upload/#post-9837598)
 * I also tried to just activate the plugin on the live site and received this error
   message: **The plugin generated 715 characters of unexpected output during activation.
   If you notice “headers already sent” messages, problems with syndication feeds
   or other issues, try deactivating or removing this plugin.**. Seems like you 
   have issues in the code.?
 *  [huge-it-support-1](https://wordpress.org/support/users/huge-it-support-1/)
 * (@huge-it-support-1)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/mysql-error-upon-upload/#post-9843334)
 * Dear dorysp,
 * Seems that the issue is related to your MySQL version.
    It looks like your server
   doesn’t support collation “utf8mb4_unicode_520_ci”
 * Please try to use the following solution:
 * in the file
    video-player.php
 * change
    $collate = $wpdb->get_charset_collate();
 * to
    $collate = “DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci”;
 * We will wait for your results.
 * Thanks
 *  [huge-it-support-1](https://wordpress.org/support/users/huge-it-support-1/)
 * (@huge-it-support-1)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/mysql-error-upon-upload/#post-9868515)
 * It has been almost one week, we are marking the ticket as resolved, because it
   is site specific and we have got no reply. Feel free to reply at any time with
   more information on this issue or un-resolve the topic if you do return to the
   ticket with a reply

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Mysql Error upon upload’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/video-player_fbf1f1.svg)
 * [Video Player](https://wordpress.org/plugins/video-player/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/video-player/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/video-player/)
 * [Active Topics](https://wordpress.org/support/plugin/video-player/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/video-player/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/video-player/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [huge-it-support-1](https://wordpress.org/support/users/huge-it-support-1/)
 * Last activity: [8 years, 5 months ago](https://wordpress.org/support/topic/mysql-error-upon-upload/#post-9868515)
 * Status: resolved