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

[Marc Dequènes (Duck)]

Romain Beauxis <toots at rastageeks.org> writes:

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

Yea this is a bug, but not the only one, which is specific to
postgresql. Version 1.9 fixes a nasty timestamp problem, and some
others, but several still remains.

You can solve the image upload problem with this SQL request :
  ALTER TABLE image ALTER img_size TYPE integer;

If you plan on upgrading to the 1.9 package in experimental, then i
suggest the following :
  ALTER TABLE mwuser ALTER COLUMN user_newpass_time TYPE char(32);
and at least the following patches from
/usr/share/mediawiki1.9/maintenance/archives are not applied (they
should have been converted from MySQL to PostgreSQL and applied,
but...) :
  - patch-redirect.sql
  - patch-rc_len.sql
  - patch-user_editcount.sql
You would then have to convert them by yourself to have a working
wiki.

I lack time to report this properly upstream, but i should do some more
tests and do it in a near future.

-- 
Marc Dequènes (Duck)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 188 bytes
Desc: not available
Url : http://lists.alioth.debian.org/pipermail/pkg-mediawiki-devel/attachments/20070315/cf745ba1/attachment.pgp