Project:General Discussions: Difference between revisions

Jump to navigation Jump to search

Project:General Discussions (view source)

Revision as of 09:31, 19 January 2014

2 bytes removed ,  19 January 2014
no edit summary
(→‎Ratings Changes: Added my five cents to the debate.)
No edit summary
Line 166: Line 166:


I'll also squash some double redirects while I'm at it. [[User:Delroth|delroth]] ([[User talk:Delroth|talk]]) 14:16, 25 August 2013 (CEST)
I'll also squash some double redirects while I'm at it. [[User:Delroth|delroth]] ([[User talk:Delroth|talk]]) 14:16, 25 August 2013 (CEST)
===DB Error===
Getting a DB error uploading images...
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 "UploadStash::stashFile". Database returned error "42703: ERROR: column "us_props" of relation "uploadstash" does not exist LINE 1: ...stash" (us_id,us_user,us_key,us_orig_path,us_path,us_props,u... ^ ".[[User:Kolano|Kolano]] ([[User talk:Kolano|talk]]) 08:42, 11 September 2013 (CEST)
This error is preventing me from adding a image to [[Super Mario Bros.: The Lost Levels]]. Might be related to the issue patched in, https://git.wikimedia.org/commit/mediawiki%2Fcore.git/8049aa338451fa96ae0ee527df15a7b1a2ca27a3,  but I'm not sure. [[User:Kolano|Kolano]] ([[User talk:Kolano|talk]]) 19:27, 11 September 2013 (CEST)
Hello, I had this problem. It is a result of using Postgres. There was a bug reported, but I'm not sure that it ever got into the official bug tracker. You can read the discussion here:
https://www.mediawiki.org/wiki/Thread:Project:Support_desk/postgres:_column_%22us_props%22_of_relation_%22uploadstash%22_does_not_exist
I had to go into the database and run: alter table mediawiki.uploadstash add column us_props bytea null;
And then I also had to edit 'includes/upload/UploadStash.php' and
change:
'us_props' => serialize( $fileProps ),
to:
'us_props' => serialize( pg_unescape_bytea($fileProps) ),
And then if I wanted to upload DJVU files, I had to edit 'includes/media/DjVu.php':
Change getMetaTree(...):
<nowiki>  try{
      $tree = new SimpleXMLElement( $metadata );</nowiki>
To:
<nowiki>  try{
$tree = new SimpleXMLElement( $metadata );
  } catch( Exception $e ) {
$tree = new SimpleXMLElement( pg_unescape_bytea($metadata) );
  }</nowiki>
Whoever said that Mediawiki works with PostgreSQL is wrong/lying.
:Reproduced. Apparently it happens in any file with a space in the name. Which is weird, since that has worked for a long time, and I even did it just a little while ago. *shrug*. I notified Parlane, and he confirmed what the anonymous poster above said. As Parlane put it: "basically there is a fix in the pipeline but the pipes are moving slow as fuck ?". I guess we need to just avoid using spaces in filenames until mediawiki fixes this? - [[User:MaJoR|MaJoR]] ([[User talk:MaJoR|talk]]) 08:02, 7 January 2014 (CET)
:Oh, that was awesome. Since the fix was already done and just not committed to mediawiki master, Matt_P just applied it himself. It's fixed :D. Give it a try Kolano. And thanks anonymous guy, whoever you are. - [[User:MaJoR|MaJoR]] ([[User talk:MaJoR|talk]]) 08:27, 7 January 2014 (CET)


=== Global Problems behavior ===
=== Global Problems behavior ===
Line 369: Line 331:
: We should inform delroth, since the links works and are parsed correctly when we are in the wiki, this probably is an issue with the "wiki => forum" rendering engine. [[User:Jhonn|Jhonn]] ([[User talk:Jhonn|talk]])  
: We should inform delroth, since the links works and are parsed correctly when we are in the wiki, this probably is an issue with the "wiki => forum" rendering engine. [[User:Jhonn|Jhonn]] ([[User talk:Jhonn|talk]])  
:: There is a bit of a bleh situation going on right now... delroth isn't available to be contacted. It will be a while. - [[User:MaJoR|MaJoR]] ([[User talk:MaJoR|talk]]) 22:04, 23 April 2013 (CEST)
:: There is a bit of a bleh situation going on right now... delroth isn't available to be contacted. It will be a while. - [[User:MaJoR|MaJoR]] ([[User talk:MaJoR|talk]]) 22:04, 23 April 2013 (CEST)
===DB Error===
Getting a DB error uploading images...
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 "UploadStash::stashFile". Database returned error "42703: ERROR: column "us_props" of relation "uploadstash" does not exist LINE 1: ...stash" (us_id,us_user,us_key,us_orig_path,us_path,us_props,u... ^ ".[[User:Kolano|Kolano]] ([[User talk:Kolano|talk]]) 08:42, 11 September 2013 (CEST)
This error is preventing me from adding a image to [[Super Mario Bros.: The Lost Levels]]. Might be related to the issue patched in, https://git.wikimedia.org/commit/mediawiki%2Fcore.git/8049aa338451fa96ae0ee527df15a7b1a2ca27a3,  but I'm not sure. [[User:Kolano|Kolano]] ([[User talk:Kolano|talk]]) 19:27, 11 September 2013 (CEST)
Hello, I had this problem. It is a result of using Postgres. There was a bug reported, but I'm not sure that it ever got into the official bug tracker. You can read the discussion here:
https://www.mediawiki.org/wiki/Thread:Project:Support_desk/postgres:_column_%22us_props%22_of_relation_%22uploadstash%22_does_not_exist
I had to go into the database and run: alter table mediawiki.uploadstash add column us_props bytea null;
And then I also had to edit 'includes/upload/UploadStash.php' and
change:
'us_props' => serialize( $fileProps ),
to:
'us_props' => serialize( pg_unescape_bytea($fileProps) ),
And then if I wanted to upload DJVU files, I had to edit 'includes/media/DjVu.php':
Change getMetaTree(...):
<nowiki>  try{
      $tree = new SimpleXMLElement( $metadata );</nowiki>
To:
<nowiki>  try{
$tree = new SimpleXMLElement( $metadata );
  } catch( Exception $e ) {
$tree = new SimpleXMLElement( pg_unescape_bytea($metadata) );
  }</nowiki>
Whoever said that Mediawiki works with PostgreSQL is wrong/lying.
:Reproduced. Apparently it happens in any file with a space in the name. Which is weird, since that has worked for a long time, and I even did it just a little while ago. *shrug*. I notified Parlane, and he confirmed what the anonymous poster above said. As Parlane put it: "basically there is a fix in the pipeline but the pipes are moving slow as fuck ?". I guess we need to just avoid using spaces in filenames until mediawiki fixes this? - [[User:MaJoR|MaJoR]] ([[User talk:MaJoR|talk]]) 08:02, 7 January 2014 (CET)
:Oh, that was awesome. Since the fix was already done and just not committed to mediawiki master, Matt_P just applied it himself. It's fixed :D. Give it a try Kolano. And thanks anonymous guy, whoever you are. - [[User:MaJoR|MaJoR]] ([[User talk:MaJoR|talk]]) 08:27, 7 January 2014 (CET)
Retrieved from "https://wiki.dolphin-emu.org/index.php?title=Special:MobileDiff/80635"

Navigation menu