gctools-outilsgc / gcpedia

A wiki based on MediaWiki
Other
14 stars 14 forks source link

Error updating page with & (%26) in the title #124

Closed nschonni closed 5 years ago

nschonni commented 5 years ago

Got a DB error trying to add an archive banner to https://www.gcpedia.gc.ca/wiki/GC_IT_Domain_Navigation/Gs_%26_Cs

A database query error has occurred. This may indicate a bug in the software.

Query:
INSERT INTO `text` (old_id,old_text,old_flags) VALUES (NULL,'{{archive|https://wiki.gccollab.ca/GC_Enterprise_Architecture}}\n\n[[FR: Orientation liée au domaine de la TI du GC/S et C]]\n[[Image:Legend_IT_Domain_v2.png|900 px|humb|center]]\n{{tab‎|link=GC IT Domain Navigation|label=Home|do={{{2|linked}}}}} \n{{tab‎|link=GC IT Domain Navigation/Asset Management|label={{color|rgb(255,255,0)|Asset Mgt}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/ATIP|label={{color|rgb(255,255,0)|ATIP}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Audit Software|label={{color|GREEN|Audit Software}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Business Intelligence Software|label={{color|rgb(255,255,0)|Business Intelligence Software}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Case Management|label={{color|GREEN|Case Management}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Cloud Computing|label={{color|rgb(255,255,0)|Cloud Computing}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Collaboration and Web 2.0 Systems| label={{color|rgb(230,137,0)|Collaboration and Web 2.0 Systems}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Correspondence Management|label={{color|GREEN|Correspondence Mgt}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Enterprise Architecture Software Solution|label={{color|rgb(255,255,0)|Enterp. Archit. Software Solution}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Enterprise Search|label={{color|rgb(255,255,0)|Enterprise Search}}| do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/EDRMS|label={{color|rgb(230,137,0)|GCDocs (previously EDRMS)}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/GC Web Search|label={{color|rgb(255,255,0)|GC Web Search}}|do={{{3| linked }}}}}\n{{tab‎|link=GC IT Domain Navigation/Gs & Cs|label=Gs & Cs|do={{{1|focus}}}}}\n{{tab‎|link=GC IT Domain Navigation/Health Info Systems|label={{color|rgb(230,137,0)|Health Info Systems}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Interoperability|label={{color|Green|Interoperability}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Learning Management Software|label={{color|rgb(255,255,0)|Learning Mgt Software}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Mobile Device Management|label={{color|rgb(230,137,0)|Mobile Device Mgt}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Portfolio and Project Mgmnt|label={{color|Green|Portfolio and Project Mgt}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Real Property|label={{color|rgb(230,137,0)|Real Property}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Web Content Management|label={{color|rgb(255,255,0)|Web Content Mgt}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Windows 7/Office 2010 Migration|label={{color|rgb(230,137,0)|Windows 7/Office 2010 Migration}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Windows Server 2003|label={{color|rgb(230,137,0)|Windows Server 2003 Migration}}|do={{{3|linked}}}}}\n{{tab‎|link=GC IT Domain Navigation/Workplace Technology Devices|label={{color|rgb(230,137,0)|Workplace Technology Devices}}|do={{{3|linked}}}}} {{clear}}\n{| width=\"100%\" cellpadding=\"10\" cellspacing=\"0\" style=\"border: 1px solid #006699; font-family: Calibri\"\n| colspan=\"4\" bgcolor= rgb(211,232,254) color= rgb(0,0,0) style=\"font-size:150%\" align=\"center\"|\'\'\'Standard on Enterprise Resource Planning Systems\'\'\'\n|- \n| width=\"25%\" align=\"left\"|[http://publiservice.tbs-sct.gc.ca/pol/doc-eng.aspx?id=25687 Material Management Systems]\n| width=\"25%\" align=\"left\"|[http://publiservice.tbs-sct.gc.ca/pol/doc-eng.aspx?id=25687 Financial Management Systems]\n| width=\"25%\" align=\"left\"|[http://publiservice.tbs-sct.gc.ca/pol/doc-eng.aspx?id=25687 HR Management Systems]\n| width=\"25%\" align=\"left\"|[[media:CIOB_ERP_Standard_Request_for_Exemption_-_Template_.doc|ERP - Request for Exemption]]\n|}\n<br>\n\n<!------------------------------------------------ GS & CS --------------------------------------------------------->\n<span id=\"Gs & Cs\"></span>\n{{ITGuidance2\n|Domain = {{color|rgb(230,137,0)|Gs & Cs}}\n|Date = 2014-09-02 \n|Updated = 2017-08-14\n|SoftCat = <p>Grants & Contributions Management software</p>\n|ITServGrp = <p>Appl. / Database Develop. and Maint.</p>\n|AppCapab = Capabilities Services\n|ArchDomain = <p></p>\n|VendorMarket = <p></p>\n|SoftCatDef = <p>: Grants and Contributions Management Software assists in the deployment of grant programs and funding administration required for internal operations. The software can control all aspects of the funding process - from initial funding requests, through assessments and funding recommendations, to authorizations, payments and subsequent monitoring of outcomes. </p>\n|CurGCEnv = <p></p>\n|Guidance = \nAfter a review, in 2012-13, of departmental Grants and Contributions (Gs&Cs) solutions and the Government of Canada’s selection of the Dynamics CRM (Dynamics 365) application platform in 2013, the Office of the Comptroller General (OCG) made the decision to establish a Program Centre to coordinate the development of an enterprise business platform for Gs&Cs using this CIOB recommended application platform. Dynamics 365 licenses can be purchased through the Shared Case Management System (SCMS) Service offered by PSPC. \nIt is recommended that departments in need of a Gs&Cs solution contact the OCG before initiating a Gs&Cs solution initiative. OCG in conjunction with the participating departments are developing a new platform based on Dynamics 365. The implementing department will determine where their G&C business solution will be hosted (i.e., on premise or in the cloud) following GC IT Strategy and established procedures. \nFor further information on the G&C business platform, please visit the GCConnex page <u>[https://gcconnex.gc.ca/file/group/5440084/all#7009991 G&C Business Design and Process Working Group (BDPWG)]</u> or contact Chantal Périard (<u>[mailto:Chantal.Periard@tbs-sct.gc.ca Chantal.Periard@tbs-sct.gc.ca]</u>).\n<br>\n|Decks = <br>\n* \'\'\'2016-11-27\'\'\': [https://gcconnex.gc.ca/file/view/24210562/egcs-reference-solution-architecture Enterprise Grant & Contribution Solution Platform - Reference Solution Architecture]\n** Enterprise Grant & Contribution Solution Platform - Reference Solution Architecture\n* \'\'\'2016-08-23\'\'\': [https://gcconnex.gc.ca/file/view/20188977/enterprise-gc-solution-platform-overview Enterprise G&C Solution Platform Overview]\n** Enterprise G&C Solution Platform Overview\n* \'\'\'2016-05-30\'\'\': [https://gcconnex.gc.ca/file/view/20336982/cioc-2016-05-30-04-grants-and-contributions-modernization-action-plan-gcmapppt CIOC - 04 Grants and Contributions Modernization Action Plan (GCMAP)]\n** Grants and Contributions Modernization Action Plan \n* \'\'\'2015-06-25\'\'\': [http://gcconnex.gc.ca/file/view/12812944/2015-06-25-update-on-the-enterprise-approach-for-grants-and-contributions Update on the Enterprise Approach for Grants and Contributions]\n** Update on the Enterprise Approach for Grants and Contributions\n* \'\'\'2014-05-26\'\'\': [http://publiservice.tbs-sct.gc.ca/cmt/cioc-cdpi/meetings/2014/05-26/contributions/contributions-eng.asp CIOC - Grants & Contributions Common Enterprise Environment]\n** Grants & Contributions Common Enterprise Environment\n* \'\'\'2014-05-26\'\'\': [http://publiservice.tbs-sct.gc.ca/cmt/cioc-cdpi/meetings/2014/05-26/heritage-patrimoine/heritage-patrimoine-eng.asp CIOC - Department of Canadian Heritage: Vision for Gs&Cs Online Service Delivery]\n** Department of Canadian Heritage: Vision for Gs&Cs Online Service Delivery\n* \'\'\'2014-04-29\'\'\': [http://gcconnex.gc.ca/file/view/10953755/2014-04-29-adm-presentation-overview-of-the-enterprise-gc-solution ADM Presentation - Overview of the Enterprise G&C Solution]\n** Overview of the Enterprise Grants & Contributions Solution\n* \'\'\'2012-11-21\'\'\': [http://publiservice.tbs-sct.gc.ca/cmt/cioc-cdpi/meetings/2012/11-21/contributions/contributions-eng.asp CIOC - Grants and Contributions Information Management System ]\n** Presentation concerning Grants and Contributions Information Management System.\n* \'\'\'2011-07-20\'\'\': [http://publiservice.tbs-sct.gc.ca/cmt/cioc-cdpi/meetings/2011/09-07/aafc-aac/aafc-aac-eng.asp CIOC - Common Application Platform for Grants & Contributions]\n** Common Application Platform for Grants & Contributions\n}}','utf-8')
Function: Revision::insertOn
Error: 2006 MySQL server has gone away (10.55.139.91)
nschonni commented 5 years ago

Looks like this was fixed as part of the linked issue on the GCConnex repo