Issue:Database issues after upgrade 1.10 to 1.11

Description:	Ignore and file under stupid, stupid, stupid user.
Extension / Version:	DPL   /   1.6.5
Type / Status:	Bug   /   closed

Problem

After upgrading from 1.10 to 1.11 I get the following when trying to render certain pages with DPL content:

Database 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 "LocalFile::loadFromDB". MySQL returned error "1054: Unknown column 'img_sha1' in 'field list' (localhost)".

The page doesn't draw anything and in order to even edit the offending pages I have to switch off DPL in the localsettings file.

On one page the following code causes a problem (--) added to stop rendering here: <DPL--> mode = none titlematch = % ordermethod = category,sortkey </DPL-->

But on another I can't get the page to display even when I turn off DPL. That is worrying as I can't edit the page at all. I'm not sure if this is related to DPL or to the upgrade from 1.10 to 1.11. I am using the latest version of 1.6.5

Reply

As you may have seen the DPLDEMO wiki here uses MW 1.11. So there is no known issue of incompatibility. Most probably the reason for your problems is outside DPL. The missing "img_sha1" is an indicator for a migration problem. I suggest to repeat the upgrade procedure (paying special attention to character sets). Afterwards you can add the extensions to the new LocalSettings.php step by step and see if the problems reoccur. Start with ParserFunctions and then add DPL. Good luck!

Gero 10:00, 22 January 2008 (CET)

Conclusion

Repeat after me... learn to follow instructions. Learn to follow instructions.

My upgrade was incomplete. I've fixed that now and all is fine. Thanks for pointing me in the right direction.

Brianoflondon 10:26, 22 January 2008 (CET)