[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #10 from Kaya Saman kayasa...@gmail.com --- 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 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Priority|Unprioritized |Normal Blocks||384 Severity|normal |major -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added CC||aarcos.w...@gmail.com, ||bawolff...@gmail.com, ||fflo...@wikimedia.org, ||gti...@wikimedia.org, ||mtrac...@member.fsf.org Component|General/Unknown |PdfHandler Version|1.21.3 |unspecified Product|MediaWiki |MediaWiki extensions Summary|PDF fails to render and |PDF fails to render and |unable to delete|unable to delete on ||PostgreSQL and FreeBSD --- Comment #3 from Andre Klapper aklap...@wikimedia.org --- https://www.mediawiki.org/wiki/Manual:How_to_debug probably doesn't help much either here, hmm. Which PDFHandler branch is this about? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #4 from Bawolff (Brian Wolff) bawolff...@gmail.com --- (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 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #5 from Kaya Saman kayasa...@gmail.com --- 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. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #6 from Andre Klapper aklap...@wikimedia.org --- 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 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #7 from Kaya Saman kayasa...@gmail.com --- 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 ?? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #8 from Bawolff (Brian Wolff) bawolff...@gmail.com --- 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; -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete on PostgreSQL and FreeBSD
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #9 from Kaya Saman kayasa...@gmail.com --- 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} -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #1 from Sam Reed (reedy) s...@reedyboy.net --- What version of MediaWiki are you using? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59147] PDF fails to render and unable to delete
https://bugzilla.wikimedia.org/show_bug.cgi?id=59147 --- Comment #2 from Kaya Saman kayasa...@gmail.com --- Hi, version 1.21.3 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l