Mysql Error upon upload

  • Resolved dorysp

    (@dorysp)


    8 years, 5 months ago

    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

    (@huge-it-support-1)

    8 years, 5 months ago

    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

    (@dorysp)

    8 years, 5 months ago

    Sorry, that did not work. I received the same error message.

    Thread Starter dorysp

    (@dorysp)

    8 years, 5 months ago

    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

    (@huge-it-support-1)

    8 years, 5 months ago

    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

    (@huge-it-support-1)

    8 years, 4 months ago

    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.