Last modified: 2014-07-30 13:54:32 UTC
Created attachment 14196 [details] PDF Not Rendering Platform: FreeBSD 8.3 x64 PHP: 5.3.28 (fpm-cgi) PostgreSQL DB: 9.2.4 Upon deletion of PDF file the error below is observed: <error> A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "Revision::fetchFromConds". Database returned error "0A000: ERROR: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join ". </error> In addition PDF files won't render either... possibly attributed to the error above (see attachment) PdfHandler Extension is active in LocalSettings.php and in addition all paths for various tools are correct (gs, imagemagick, convert etc...)
What version of MediaWiki are you using?
Hi, version 1.21.3
https://www.mediawiki.org/wiki/Manual:How_to_debug probably doesn't help much either here, hmm. Which PDFHandler branch is this about?
(In reply to comment #3) > https://www.mediawiki.org/wiki/Manual:How_to_debug probably doesn't help much > either here, hmm. Which PDFHandler branch is this about? I suspect this more has to do with core then with pdf stuff. Can you delete non pdf files fine
Hi, the PDF Handler version is: https://git.wikimedia.org/tree/mediawiki%2Fextensions%2FPdfHandler 2013-12-07 basically, I used the link above to grab the .tar.gz file. Everything else works fine, I can delete and render everything; even using the TimedMediaHandler plugin to handle ogg and m4v files and works perfectly.
So you are running extension's git master with MW 1.21. The extension's 1.21 branch would be https://git.wikimedia.org/log/mediawiki%2Fextensions%2FPdfHandler/REL1_21
I've just re-installed the extension from the link above and unfortunately same thing :-( <----error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "Revision::fetchFromConds". Database returned error "0A000: ERROR: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join ". -----> and page still not rendering "thumb" properly either: http://www.optiplex-networks.com/index.php?title=File:Hp-2230s-review-final-2.pdf ??
It probably won't make much of a difference in this case, but please add to the bottom of LocalSettings.php $wgShowSQLErrors = true; $wgShowDBErrorBacktrace = true;
We have some more output: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM "revision" INNER JOIN "page" ON ((page_id = rev_page)) LEFT JOIN "mwuser" ON ((rev_user != 0) AND (user_id = rev_user)) WHERE page_id = '19' AND rev_id = '41' LIMIT 1 FOR UPDATE from within function "Revision::fetchFromConds". Database returned error "0A000: ERROR: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join ". Backtrace: #0 /usr/local/www/www/includes/db/DatabasePostgres.php(482): DatabaseBase->reportQueryError('ERROR: SELECT ...', '0A000', 'SELECT rev_id,...', 'Revision::fetch...', false) #1 /usr/local/www/www/includes/db/Database.php(983): DatabasePostgres->reportQueryError('ERROR: SELECT ...', '0A000', 'SELECT rev_id,...', 'Revision::fetch...', false) #2 /usr/local/www/www/includes/db/Database.php(1434): DatabaseBase->query('SELECT rev_id,...', 'Revision::fetch...') #3 /usr/local/www/www/includes/Revision.php(372): DatabaseBase->select(Array, Array, Array, 'Revision::fetch...', Array, Array) #4 /usr/local/www/www/includes/Revision.php(314): Revision::fetchFromConds(Object(DatabasePostgres), Array, 3) #5 /usr/local/www/www/includes/Revision.php(294): Revision::loadFromConds(Object(DatabasePostgres), Array, 3) #6 /usr/local/www/www/includes/Revision.php(143): Revision::newFromConds(Array, 3) #7 /usr/local/www/www/includes/WikiPage.php(575): Revision::newFromPageId(19, 41, 3) #8 /usr/local/www/www/includes/WikiPage.php(615): WikiPage->loadLastEdit() #9 /usr/local/www/www/includes/WikiPage.php(2543): WikiPage->getContent(3) #10 /usr/local/www/www/includes/FileDeleteForm.php(185): WikiPage->doDeleteArticleReal('', false, 0, false, '', Object(User)) #11 /usr/local/www/www/includes/FileDeleteForm.php(110): FileDeleteForm::doDelete(Object(Title), Object(LocalFile), '', '', false, Object(User)) #12 /usr/local/www/www/includes/ImagePage.php(875): FileDeleteForm->execute() #13 /usr/local/www/www/includes/actions/DeleteAction.php(45): ImagePage->delete() #14 /usr/local/www/www/includes/Wiki.php(439): DeleteAction->show() #15 /usr/local/www/www/includes/Wiki.php(305): MediaWiki->performAction(Object(ImagePage), Object(Title)) #16 /usr/local/www/www/includes/Wiki.php(565): MediaWiki->performRequest() #17 /usr/local/www/www/includes/Wiki.php(458): MediaWiki->main() #18 /usr/local/www/www/index.php(59): MediaWiki->run() #19 {main}
I just upgraded to Mediawiki 1.22.2, and additionally updated the extension. Good news is that I was able to delete the PDF file; the bad news is that it still doesn't render the first page as the I believe the PDFHandler extension is supposed to do: " The PdfHandler extension shows uploaded pdf files in a multipage preview layout. With the Proofread Page extension enabled, pdfs can be displayed side-by-side with text for transcribing books and other documents, as is commonly done with DjVu files (particularly in Wikisource). " -- From here: http://www.mediawiki.org/wiki/Extension:PdfHandler
The file delete part was bug 60531
Change 129109 had a related patch set uploaded by Jjanes: PostgreSQL: decode image.img_metadata https://gerrit.wikimedia.org/r/129109
Change 129109 merged by jenkins-bot: PostgreSQL: decode image.img_metadata https://gerrit.wikimedia.org/r/129109
blob handling for postgres was successfully merged
Change 132508 had a related patch set uploaded by Jjanes: PostgreSQL: decode image.img_metadata https://gerrit.wikimedia.org/r/132508
Change 132510 had a related patch set uploaded by Jjanes: PostgreSQL: decode image.img_metadata https://gerrit.wikimedia.org/r/132510
Change 132508 merged by jenkins-bot: PostgreSQL: decode image.img_metadata https://gerrit.wikimedia.org/r/132508
Only https://gerrit.wikimedia.org/r/#/c/132510/ remaining for review (for 1.22 branch) here. Jjanes: Anything else needed to fix this?
Andre: I have not tested on FreeBSD, and can't readily do so. But I see no reason to think it behaves differently than Linux does in this regard, until someone else reports otherwise. Should it also go into final EOL release of 1.21 ? Other than those, I think that is all for this issue.
Change 132510 merged by Mglaser: PostgreSQL: decode image.img_metadata https://gerrit.wikimedia.org/r/132510
successfully merged on release branch