Page MenuHomePhabricator

adding DPL to a page in mw1.8.3 / 1.9.1 generates DB error
Closed, ResolvedPublic

Description

Author: dave.younce

Description:
I'm running mediawiki 1.8.3. I installed DPL2 and LST, but when I add something like
<DPL>
category=Articles
</DPL>

and save the page, I get the following error text instead of my page:

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 "". MySQL returned error "1064: You have an error in your
SQL syntax. Check the manual that corresponds to your MySQL server version for
the right syntax to use near 'USING utf8)), '_', ' ') as sortkey FROM page
INNER JOIN `cate (mysql119.secureserver.net)".

The error goes away if I go back and remove the DPL code.


Version: unspecified
Severity: normal
OS: Windows XP
Platform: PC

Details

Reference
bz8830

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:29 PM
bzimport set Reference to bz8830.
bzimport added a subscriber: Unknown Object (MLST).

cyril.dangerville wrote:

OK. Which versions of DPL2 and MySQL are you using?

dave.younce wrote:

Sorry, that should've been in the original post.

Mysql: 4.0.27-max-log
Php: 5.1.4
DPL: 0.8.1 (rev 19503)

-Dave

gero.scholz wrote:

In DPL 0.9.x (to be found on [http://semeb.com/dpldemo the dpldemo website] this problem should be solved.
The UTF-8 conversion was eliminated as it seem s to cause trouble with MySQL installations which are set up with a different character set.

-Gero

gero.scholz wrote:

In DPL 0.9.x (to be found on [http://semeb.com/dpldemo the dpldemo website] this problem should be solved.
The UTF-8 conversion was eliminated as it seem s to cause trouble with MySQL installations which are set up with a different character set.

-Gero