[wordtube] Mysql error with wordtube

  • Hi, i’ve installed the wordtube plugin (version 2.1.0) following the instructions on Alex Rabe page, the install went ok, without errors but when i try to upload new videos it doesn’t work. The browser uploads the file but when the file is completed wordtube “gallery” is still empty.

    Checking the web server log i found out this error:

    WordPress database error Unknown column 'counter' in 'field list' for query INSERT INTO wp_wordtube ( name, creator, description, file, image, width, height, link, autostart, disableAds, counter )\r\n\tVALUES ( '', '', '', 'https://www.kikentai.org/myspace/squiggle.flv', 'https://www.kikentai.org/myspace/squiggle.png', '320', '240', '', '0', 0, '0' ) made by require_once, do_action, call_user_func_array, wordTubeAdmin->show_menu, wordTubeManage->wordTubeManage, wordTubeManage->controller, wt_add_media, referer: https://ippolita.net/ticonzero/wp-admin/upload.php?page=wordTube

    looking further i found out that on plugin activation i get the following error:

    WordPress database error ALTER command denied to user ‘*****’@’******’ for table ‘wp_wordtube’ for query ALTER TABLE wp_wordtube ADD counter MEDIUMINT(10) NULL DEFAULT ‘0’ made by activate_plugin, do_action, call_user_func_array, wt_install, wordtube_install, referer: https://ippolita.net/ticonzero/wp-admin/plugins.php?deactivate=true

    Any idea on why is this happening?
    I have the same problem both directly uploading and pointing to an external video file.

    Thank!
    Marcello

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

  • You’re not alone here, we’ve got the very same problem. Uploading or linking to youtube return us an empty gallery/playlist… looking on the problem now, but not sure if we can solve it.

    Okay we solved the problem. Thanks to YOU for sharing your logs, and thanks to my friend who’s handling the DB and server.

    The problem is due to permissions on your database. Right now it seems you can’t do the ALTER command.

    Check your wordtube database table to see if you have the “counter” field. If not, you must create this field on your own manually with root privileges (ALTER TABLE ADD wp_wordtube MEDIUMINT against (10) NULL DEFAULT’0). In my case, I did that and it worked.

    Perhaps a second solution for this problem: add the right ALTER for the user of your database and restart the installation of wordTube. I think it will create the field “counter” automatically.

    Good luck.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[wordtube] Mysql error with wordtube’ is closed to new replies.