Deprecated: Use of MediaWiki\Parser\Parser::$mTemplatePath was deprecated in MediaWiki 1.42. [Called from MediaWiki\Extension\DynamicPageList3\Parse::parse in /home/httpd/vhosts/unix.fish/raysoft.ch/w/extensions/DynamicPageList3/includes/Parse.php at line 105] in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/debug/MWDebug.php on line 372 Deprecated: Asking for a replica from groups except dump/vslow is deprecated: dpl [Called from Wikimedia\Rdbms\LoadBalancer::getConnectionInternal in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php at line 805] in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/debug/MWDebug.php on line 372 Deprecated: Caller from MediaWiki\Page\PageStore::getPageByNameViaLinkCache ignored an error originally raised from MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - MySQL: [1054] Unknown column 'ecl1.cl_to' in 'where clause' in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/debug/MWDebug.php on line 372 MySQL - RaySoft Jump to content

MySQL

From RaySoft

MySQL is a relational database management system (RDBMS) which has more than 6 million installations. The program runs as a server providing multi-user access to a number of database.[1]

Documentation

Forks

Components

Extension:DynamicPageList3 (DPL3), version 3.6.4: Error: Error 1054: Unknown column 'ecl1.cl_to' in 'where clause' Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - MySQL Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `wp_page`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'RaySoft:' WHEN 5 THEN 'RaySoft_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:' END, `wp_page`.page_title), '_', ' ')) AS `sortkey`,`wp_page`.page_namespace AS `page_namespace`,`wp_page`.page_id AS `page_id`,`wp_page`.page_title AS `page_title` FROM `wp_page` `wp_page` JOIN `wp_categorylinks` `cl1` ON ((`wp_page`.page_id = cl1.cl_from AND cl1.cl_to = 'MySQL')) JOIN `wp_categorylinks` `cl2` ON ((`wp_page`.page_id = cl2.cl_from AND cl2.cl_to = 'Component')) LEFT OUTER JOIN `wp_categorylinks` `ecl1` ON ((`wp_page`.page_id = ecl1.cl_from AND ecl1.cl_to ='Add-on')) WHERE `wp_page`.page_is_redirect = 0 AND `wp_page`.page_namespace = 0 AND ecl1.cl_to IS NULL ORDER BY sortkey ASC LIMIT 500

Additional Resources

Extension:DynamicPageList3 (DPL3), version 3.6.4: Error: Error 1054: Unknown column 'ecl1.cl_to' in 'where clause' Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - MySQL Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `wp_page`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'RaySoft:' WHEN 5 THEN 'RaySoft_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:' END, `wp_page`.page_title), '_', ' ')) AS `sortkey`,`wp_page`.page_namespace AS `page_namespace`,`wp_page`.page_id AS `page_id`,`wp_page`.page_title AS `page_title` FROM `wp_page` `wp_page` JOIN `wp_categorylinks` `cl1` ON ((`wp_page`.page_id = cl1.cl_from AND cl1.cl_to = 'MySQL')) JOIN `wp_categorylinks` `cl2` ON ((`wp_page`.page_id = cl2.cl_from AND (cl2.cl_to = 'Suite' OR cl2.cl_to = 'Server' OR cl2.cl_to = 'Application' OR cl2.cl_to = 'Shell_Command' OR cl2.cl_to = 'Add-on'))) LEFT OUTER JOIN `wp_categorylinks` `ecl1` ON ((`wp_page`.page_id = ecl1.cl_from AND ecl1.cl_to ='Component')) WHERE `wp_page`.page_is_redirect = 0 AND `wp_page`.page_namespace = 0 AND ecl1.cl_to IS NULL ORDER BY sortkey ASC LIMIT 500

References

  1. ↑ https://en.wikipedia.org/wiki/MySQL
Retrieved from "https://www.raysoft.ch/w/index.php?title=MySQL&oldid=42976"