[Pkg-mediawiki-devel] Bug#414885: Bug 6634: Can't upload "big" images with Postgresql

[Romain Beauxis]

tags 414885 upstream
thanks

	Hi !

Le mercredi 14 mars 2007 15:46, Olleg Samoylov a écrit :
> If i create Wiki with PostgreSQL 8.1, I can't upload images with size more
> than 65535 bytes.
>
> This bug is registered in wiki bugzilla
>
> http://bugzilla.wikipedia.org/show_bug.cgi?id=6634
>
> And solved at 2006-08-28 22:40:19 UTC.
>
> Already done 1.9.3, 1.8.4, 1.7.3 versions of mediawiki, but debian still
> has 1.7.1. Is this package orphaned?

Obviously the package is not orphaned, please try at least to see latest 
activity before making such assomptions :)

As for your bug, the issue I fear is that it seems that the corrections is 
related to the DB definition, by changing a field data type.
Handling such change is not only uploading a proper code, but also means ask 
users to update their database..

So the correct way to solve this bug is to change the code so that newly 
created wikis do not suffer from this limitation, and propose an upgrade 
script that changes the fields for existing databases..
I am not very familiar, but it should only be a matter of dumping the 
database, then changing the data type and then updating the database with the 
modified dump file. 

I am not very familiar with postgresql, but I see that postgresql-client has 
two commands to do so, so it may not be that difficult to do...

Duck: could you look at this ? I know that you are using postgre for your own 
wikis...


Romain