Difference between revisions of "learn:faculty-cp"
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,fullname=Name,degree=Degree,copath_id=Initials,ldap_id=LDAP,subspecialty=Subspecialty,position_1=Position 1,position_2=Position 2, | + | |fields=CONCAT('{{photofaculty{{#urldecode:%7C}}',copath_id,'}}')=Photo,fullname=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 |
|where=active='1' AND amp='0' | |where=active='1' AND amp='0' | ||
|rows per page=100 | |rows per page=100 | ||
|format=dynamic table|order by=facultyMGH.name_last ASC}}| | |format=dynamic table|order by=facultyMGH.name_last ASC}}| | ||
{{#cargo_query:table=facultyMGH | {{#cargo_query:table=facultyMGH | ||
| − | |fields=CONCAT('{{photofaculty{{#urldecode:%7C}}',copath_id,'}}')=Photo,fullname=Name,degree=Degree,copath_id=Initials,ldap_id=LDAP,subspecialty=Subspecialty,position_1=Position 1,position_2=Position 2, | + | |fields=CONCAT('{{photofaculty{{#urldecode:%7C}}',copath_id,'}}')=Photo,fullname=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 |
|where=active='1' AND amp='0' | |where=active='1' AND amp='0' | ||
|rows per page=100 | |rows per page=100 | ||
|format=dynamic table|order by=facultyMGH.name_last ASC}} | |format=dynamic table|order by=facultyMGH.name_last ASC}} | ||
}}</div>{{ACLEDU}} | }}</div>{{ACLEDU}} | ||
Revision as of 10:56, July 3, 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='0' ORDER BY `cargo__facultyMGH`.`name_last` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'amp' in 'WHERE' (172.27.81.126:30004)
