Extension:Cargo/Common problems


 * If you see an error message that looks like "A database query error has occurred. This may indicate a bug in the software.", you should add the following to LocalSettings.php, so that the page displays a more helpful error message:


 * Similarly, if you see an error message like "Fatal exception of type MWException", add the following to LocalSettings.php for a more helpful error message:


 * If the "where" clause contains something like "_pageName = '&#123;&#123;PAGENAME&#125;&#125;'", the query will break for pages that contain a single quote/apostrophe (') in their name. There are a few potential fixes for this: the easiest is to change the query to "_pageID = &#123;&#123;PAGEID&#125;&#125;", which should always work. Another option is to change it to "_pageName='&#123;&#123;#replace:&#123;&#123;PAGENAME&#125;&#125;|&amp;#39;|\'&#125;&#125;'". (You could also consider replacing the single quotes around &#123;&#123;PAGENAME&#125;&#125; with double quotes, but single quotes are generally preferred for SQL literals, plus this formulation will itself break if the page name contains double quotes.)


 * By default, '=' comparisons in MySQL are case-insensitive. If you want an '=' comparison within the "where" clause to be case-sensitive, you can do it by adding "BINARY" to the comparison, like "BINARY Nickname = 'Joe'". You can do the same thing for "HOLDS" statements, like "BINARY Genre HOLDS 'Drama'".


 * If you have the Joomla! CMS running on the same server as MediaWiki, it may lead to the Cargo "recreate data" action failing. That is because one of Joomla's recommended htaccess settings blocks the string "template" in the URL, and Cargo uses this word as a parameter in its API call. To get Cargo working, you will probably have to modify or remove this line.


 * If you want to show a row number for each row in the query results, the easiest approach is to use the "template" format, and use the NumerAlpha extension - specifically the #counter parser function - within the template.