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

Assigned To

None

Authored By

	• bzimport
	Jan 30 2007, 4:03 PM

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 added a project: DynamicPageList (third-party).

• bzimport set Reference to bz8830.

• bzimport added a subscriber: Unknown Object (MLST).

• bzimport created this task.Jan 30 2007, 4:03 PM

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