Page MenuHomePhabricator

Error in Special:Drilldown when using non-ASCII characters in table names
Closed, ResolvedPublic

Description

Hello, everyone. I use the Cargo extension on a personal wiki hosted on a wiki farm, after they updated the version, whenever I go to Special:Drilldown/Artículos, I get the following message:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT `Artículos_alias`.`_pageName` AS `_pageName` FROM `cargo__Artículos` `Artículos_alias` ORDER BY Artículos_alias._pageName LIMIT 250 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xC3\xADculos_alias._pageName LIMIT 250' at line 1 (dbt1.miraheze.org)

It seems that this started after these changes

Version of Wiki
MediaWiki 1.34.1 (3bf31d9)
Cargo 2.5 (63cc541)

What's the problem? Before the upgrade, it worked fine. Greetings.

Event Timeline

Restricted Application added subscribers: RhinosF1, Reception123, Aklapper. · View Herald Transcript

I re-tested another template using the apostrophe with the same result.

Right, the problem is non-ASCII characters in table names. I'm looking into it.

Aklapper renamed this task from Error in CargoTables when using apostrophe to Error in CargoTables when using apostrophe (non-ASCII characters) in table names.Jun 5 2020, 6:39 AM
Yaron_Koren renamed this task from Error in CargoTables when using apostrophe (non-ASCII characters) in table names to Error in Special:Drilldown when using non-ASCII characters in table names.Jun 5 2020, 12:57 PM

Sorry to bother you, this has been arranged?

Mediawiki 1.34.2 (78f3cb8)
Cargo 2.6 (042d05d)

were there any updates? i still have errors, even creating new tables @Yaron_Koren

Sorry for the problem, and the long delay; I believe this is fixed now.

Sorry for the problem, and the long delay; I believe this is fixed now.

Well, I no longer get any errors. Thank you very much.

Hispano76 claimed this task.
Hispano76 reassigned this task from Hispano76 to Yaron_Koren.