Difference between revisions of "User:Cowiki"

Revision as of 09:07, 21 March 2013

The DPL extension (version 2.01) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT cl_head.cl_to, `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, REPLACE(CONCAT( IF(`page`.page_namespace=0, , CONCAT(CASE `page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WHEN 3 THEN 'User_talk' WHEN 4 THEN 'Counting_Opinions' WHEN 5 THEN 'Counting_Opinions_talk' WHEN 6 THEN 'File' WHEN 7 THEN 'File_talk' WHEN 8 THEN 'MediaWiki' WHEN 9 THEN 'MediaWiki_talk' WHEN 10 THEN 'Template' WHEN 11 THEN 'Template_talk' WHEN 12 THEN 'Help' WHEN 13 THEN 'Help_talk' WHEN 14 THEN 'Category' WHEN 15 THEN 'Category_talk' WHEN 100 THEN 'LibSatLibrary Customer Satisfaction Management Service' WHEN 101 THEN 'LibSatLibrary Customer Satisfaction Management Service_talk' WHEN 102 THEN 'LibPASLibrary Performance Assessment Service' WHEN 103 THEN 'LibPASLibrary Performance Assessment Service_talk' WHEN 104 THEN 'InformsUsForm, Survey and App Builder Service, also Web Form Builder+' WHEN 105 THEN 'InformsUsForm, Survey and App Builder Service, also Web Form Builder+_talk' WHEN 106 THEN 'News' WHEN 107 THEN 'News_talk' WHEN 108 THEN 'Staff' WHEN 109 THEN 'Staff_talk' WHEN 110 THEN 'Services' WHEN 111 THEN 'Services_talk' WHEN 112 THEN 'Studies' WHEN 113 THEN 'Studies_talk' WHEN 114 THEN 'Support' WHEN 115 THEN 'Support_talk' WHEN 116 THEN 'Minutes' WHEN 117 THEN 'Minutes_talk' WHEN 118 THEN 'CSS' WHEN 119 THEN 'CSS_talk' WHEN 200 THEN 'IPEDSIntegrated Post-Secondary Education Data System' WHEN 201 THEN 'IPEDSIntegrated Post-Secondary Education Data System_talk' WHEN 274 THEN 'Widget' WHEN 275 THEN 'Widget_talk' WHEN 302 THEN 'Property' WHEN 303 THEN 'Property_talk' WHEN 306 THEN 'Form' WHEN 307 THEN 'Form_talk' WHEN 308 THEN 'Concept' WHEN 309 THEN 'Concept_talk' END, ':')), `page`.page_title), '_', ' ') as sortkey FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_head ON (page_id=cl_head.cl_from) INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to REGEXP '.+_Case_Studies') LEFT OUTER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND cl1.cl_to='French' WHERE 1=1 AND cl1.cl_to IS NULL AND `page`.page_namespace IN ('112') AND `page`.page_is_redirect=0 ORDER BY cl_head.cl_to, sortkey ASC LIMIT 0, 500

Error message is:
Character set 'utf8_bin' cannot be used in conjunction with 'binary' in call to regexp_like. (10.39.23.66)

Étude de Cas d’une Province

Extension:DynamicPageList (DPL), version 2.01 : Warning: No results.

Possible Extensions:

• http://www.mediawiki.org/wiki/Extension:EmailPage
• Extension:HTML5Media
• http://en.wikibooks.org/wiki/Help:Collections
• http://www.mediawiki.org/wiki/Extension:Social_Sidebar

  <iframe src="//www.facebook.com/plugins/like.php?href=https%3A%2F%2Fwww.facebook.com%2Fpages%2FCounting-Opinions%2F264443126922943&send=false&layout=button_count&width=450&show_faces=false&action=like&colorscheme=light&font=arial&height=21" scrolling="no" frameborder="0" style="border:none; padding:10px; overflow:hidden; height:21px;" allowTransparency="true"></iframe>

Email tracking:

http://www.mediawiki.org/wiki/Manual_talk:$wgUsersNotifiedOnAllChanges Or maybe support? $wgUsersNotifiedOnAllChanges = array('staff');

$wgExtensionFunctions[] = 'efNotifyPerNamespace';

function efNotifyPerNamespace() {

   global $wgTitle, $wgUsersNotifiedOnAllChanges;

   if ( $wgTitle->getNamespace() == NS_USER ) {
       $wgUsersNotifiedOnAllChanges[] = 'Username';
       $wgUsersNotifiedOnAllChanges[] = 'Username 2';
   }

}$wgExtensionFunctions[] = 'efNotifyPerNamespace';

function efNotifyPerNamespace() {

   global $wgTitle, $wgUsersNotifiedOnAllChanges;

   if ( $wgTitle->getNamespace() == NS_USER ) {
       $wgUsersNotifiedOnAllChanges[] = 'Username';
       $wgUsersNotifiedOnAllChanges[] = 'Username 2';
   }

}

Skin hacks

Hide Namespace tabs

// Adds namespace links

            if (

$wgUser->isAllowed( 'edit' ) )

               {  $links['namespaces'][$subjectId] = $this->tabAction(

$subjectPage, 'nstab-' . $subjectId, !$isTalk, , $userCanRead ); $links['namespaces'][$subjectId]['context'] = 'subject';

            }

Hide Toolbox

http://www.mediawiki.org/wiki/Thread:Project:Support_desk/Vector_-_Hide_Toolbox_for_Anonymous_Users

Hide Tabs

http://www.mediawiki.org/wiki/Thread:Project:Support_desk/How_can_I_hide_tabs_for_users_not_logged_in%3F/reply_(12)

• Printable link?