Project:General Discussions: Difference between revisions
→DB Error
(Moved "Perfect Compatibility?" here where it belongs. Time to stop putting this rating stuff off and get this handled. Also, promoted the rating changes stuff we talked about up to the second position for visibility.) |
|||
| Line 173: | Line 173: | ||
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) | 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(...): | |||
try{ | |||
$tree = new SimpleXMLElement( $metadata ); | |||
To: | |||
try{ | |||
$tree = new SimpleXMLElement( $metadata ); | |||
} catch( Exception $e ) { | |||
$tree = new SimpleXMLElement( pg_unescape_bytea($metadata) ); | |||
} | |||
Whoever said that Mediawiki works with PostgreSQL is wrong/lying. | |||
=== Global Problems behavior === | === Global Problems behavior === | ||