Difference between revisions of "learn:faculty-amp"
From MGH Learn Pathology
| Line 1: | Line 1: | ||
<div style="overflow-x:auto">{{IfGroup|sysop,assist|{{#cargo_query:table=facultyMGH | <div style="overflow-x:auto">{{IfGroup|sysop,assist|{{#cargo_query:table=facultyMGH | ||
|fields=CONCAT('{{photofaculty{{#urldecode:%7C}}',copath_id,'}}')=Photo | |fields=CONCAT('{{photofaculty{{#urldecode:%7C}}',copath_id,'}}')=Photo | ||
| − | ,CONCAT('{{contacts-ampnames{{#urldecode:%7C}}',fullname,'}}')=Name | + | ,CONCAT('{{contacts-ampnames{{#urldecode:%7C}}',fullname,'{{#urldecode:%7C}}',copath_id,'}}')=Name |
,degree=Degree,copath_id=Initials,ldap_id=LDAP,subspecialty=Subspecialty,position_1=Position 1,position_2=Position 2,CONCAT('{{contacts-twitter{{#urldecode:%7C}}',twitter,'}}')=Twitter,CONCAT('{{formlink-facultyMGH{{#urldecode:%7C}}',_pageTitle,'}}')=Edit | ,degree=Degree,copath_id=Initials,ldap_id=LDAP,subspecialty=Subspecialty,position_1=Position 1,position_2=Position 2,CONCAT('{{contacts-twitter{{#urldecode:%7C}}',twitter,'}}')=Twitter,CONCAT('{{formlink-facultyMGH{{#urldecode:%7C}}',_pageTitle,'}}')=Edit | ||
|where=active='1' AND amp='1' | |where=active='1' AND amp='1' | ||
Revision as of 14:44, July 21, 2020
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT CONCAT('{{photofaculty|',copath_id,'}}') AS `Photo`,`fullname` AS `Name`,`degree` AS `Degree`,`copath_id` AS `Initials`,`ldap_id` AS `LDAP`,`subspecialty__full` AS `Subspecialty`,`position_1` AS `Position 1`,`position_2` AS `Position 2`,CONCAT('{{contacts-twitter|',twitter,'}}') AS `Twitter` FROM `cargo__facultyMGH` WHERE active='1' AND amp='1' ORDER BY `cargo__facultyMGH`.`name_last` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'amp' in 'WHERE' (172.27.81.126:30004)
