Difference between revisions of "learn:faculty-cp"
From MGH Learn Pathology
(Created page with "{{IfGroup|sysop,assist|{{#cargo_query:table=facultyMGH |fields=CONCAT('{{photofaculty{{#urldecode:%7C}}',copath_id,'}}')=Photo,fullname=Name,degree=Degree,copath_id=Initials,l...") |
|||
| Line 1: | Line 1: | ||
| − | {{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,position_3=Position 3,CONCAT('{{formlink-facultyMGH{{#urldecode:%7C}}',_pageTitle,'}}')=Edit | |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,position_3=Position 3,CONCAT('{{formlink-facultyMGH{{#urldecode:%7C}}',_pageTitle,'}}')=Edit | ||
|where=active='1' AND amp='0' | |where=active='1' AND amp='0' | ||
| Line 9: | Line 9: | ||
|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}} | ||
| − | }}{{ACLEDU}} | + | }}</div>{{ACLEDU}} |
Revision as of 10:57, June 8, 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`,`position_3` AS `Position 3` 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)
