Topic on Project:Support desk

TimedMediaHandler/video file and upload file error

10
Guillaume Taillefer (talkcontribs)

Hello, I'm trying to install TimedMediaHandler for viewing video files on my wiki, however I've encountered some errors doing so.

Info about what I'm using:

MediaWiki 1.38.1

Bluehost Shared Hosting

The first is that whenever I go to the page of an uploaded .mov file, it doesn't even display any kind of thumbnail, empty thumbnail or anything like that, just a link of the file, the file size, etc next to that, and everything else under.

The second is that now whenever I upload a mp4 file, it won't fully do it, and will give me the following error (I'm not sure if the fact that I'm using UploadWizard has anything to do with it, since the mp4 file I'm about to talk about was uploaded before I started implementing UploadWizard) : [Yyejt1lK0tcYiJXiKcatHgAB9Qk] Exception caught: $'"2

Then finally I have an already uploaded mp4 file, to which when I go to its page, I get the following error (I replaced the name of my website in with "site"):

[YyelHwLRDs84ipZZ_Y_LTgAAlRE] /index.php/File:MemeFeedBot.mp4 Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'site_mw19172.mwct_transcode' doesn't exist (localhost)

Function: WebVideoTranscode::getTranscodeState

Query: SELECT * FROM `mwct_transcode` WHERE transcode_image_name = 'MemeFeedBot.mp4' LIMIT 100

Backtrace:

from /home/site/public_html/includes/libs/rdbms/database/Database.php(1606)

#0 /home/site/public_html/includes/libs/rdbms/database/Database.php(1590): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)

#1 /home/site/public_html/includes/libs/rdbms/database/Database.php(1564): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#2 /home/site/public_html/includes/libs/rdbms/database/Database.php(1173): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#3 /home/site/public_html/includes/libs/rdbms/database/Database.php(1810): Wikimedia\Rdbms\Database->query(string, string, integer)

#4 /home/site/public_html/includes/libs/rdbms/database/DBConnRef.php(69): Wikimedia\Rdbms\Database->select(string, string, array, string, array)

#5 /home/site/public_html/includes/libs/rdbms/database/DBConnRef.php(319): Wikimedia\Rdbms\DBConnRef->__call(string, array)

#6 /home/site/public_html/extensions/TimedMediaHandler/includes/WebVideoTranscode/WebVideoTranscode.php(752): Wikimedia\Rdbms\DBConnRef->select(string, string, array, string, array)

#7 /home/site/public_html/extensions/TimedMediaHandler/includes/WebVideoTranscode/WebVideoTranscode.php(709): WebVideoTranscode::getTranscodeState(LocalFile)

#8 /home/site/public_html/extensions/TimedMediaHandler/includes/WebVideoTranscode/WebVideoTranscode.php(891): WebVideoTranscode::isTranscodeReady(LocalFile, string)

#9 /home/site/public_html/extensions/TimedMediaHandler/includes/WebVideoTranscode/WebVideoTranscode.php(693): WebVideoTranscode::addSourceIfReady(LocalFile, array, string, array)

#10 /home/site/public_html/extensions/TimedMediaHandler/includes/WebVideoTranscode/WebVideoTranscode.php(574): WebVideoTranscode::getLocalSources(LocalFile, array)

#11 /home/site/public_html/extensions/TimedMediaHandler/includes/TimedMediaTransformOutput.php(584): WebVideoTranscode::getSources(LocalFile)

#12 /home/site/public_html/extensions/TimedMediaHandler/includes/TimedMediaTransformOutput.php(355): TimedMediaTransformOutput->getMediaSources()

#13 /home/site/public_html/extensions/TimedMediaHandler/includes/TimedMediaTransformOutput.php(188): TimedMediaTransformOutput->getHtmlMediaTagOutput(array)

#14 /home/site/public_html/includes/page/ImagePage.php(474): TimedMediaTransformOutput->toHtml(array)

#15 /home/site/public_html/includes/page/ImagePage.php(141): ImagePage->openShowImage()

#16 /home/site/public_html/includes/actions/ViewAction.php(80): ImagePage->view()

#17 /home/site/public_html/includes/MediaWiki.php(544): ViewAction->show()

#18 /home/site/public_html/includes/MediaWiki.php(321): MediaWiki->performAction(ImagePage, Title)

#19 /home/site/public_html/includes/MediaWiki.php(910): MediaWiki->performRequest()

#20 /home/site/public_html/includes/MediaWiki.php(564): MediaWiki->main()

#21 /home/site/public_html/index.php(53): MediaWiki->run()

#22 /home/site/public_html/index.php(46): wfIndexMain()

#23 {main}


Any help would be great thanks

Bawolff (talkcontribs)

As the error message suggests, did you run update.php? (If you dont have cli access you can run the web installer in upgrade mode)

Guillaume Taillefer (talkcontribs)

I tried running php update.php but it gave me this error message: Could not open input file: update.php


I am able to log into my SSH via terminal and thats how I do things from there. How would I be able to run the web installer in upgrade mode?

Bawolff (talkcontribs)

Were you in the correct directory (maintenance)?

Guillaume Taillefer (talkcontribs)

I found and changed the directory to maintenance (for me under public_html), and ran it and it worked! Thanks. Although I'm still unable to get it to display.mov files, if you have a solution to that let me know but I'll try to find one and when I do I'll write it here for anyone with the same problem

Bawolff (talkcontribs)

Im not sure if it supports .mov files. It doesnt support all file types.

Guillaume Taillefer (talkcontribs)

Also this only works for mp4 files. I tried a webm file and on the File page, it only displayed the audio portion (unless if I click on the file then it leads me to the actual file). The mov files don't display at all (not even audio thing). At that point do I need to add a setting or value to a variable in LocalSettings to what types of files can be played (because I also want to add wmv files as well if possible). Thanks again

Bawolff (talkcontribs)

TimedMediaHandler was generally developed for websites that have certain political views when it comes to file formats. I think its unlikely to work with wmv.


It should work well with webm. Ensure the file is encoded correctly.

Guillaume Taillefer (talkcontribs)
Guillaume Taillefer (talkcontribs)

Nevermind the webm does actually work, I guess the other one wasn't indeed encoded correctly. Thanks

Reply to "TimedMediaHandler/video file and upload file error"