| *** query_institutionByID(): Unknown column 'text' in 'where clause' +++ DB-Error. file/pos =queries.php/4666.
SELECT SQL_CACHE
a.ID,
a.Title,
a.Caption,
a.Year,
c.Name,
c.Surname,
c.ID as aID
FROM
Artwork as a
left join ArtworkPromotion as b on a.ID=b.ArtworkID
left join People as c on a.ArtistID=c.ID
WHERE
b.InstitutionID=text AND
b.Inventory='Y'
order by
Surname asc, Year desc
Unknown column 'text' in 'where clause'
+++ DB-Error. file/pos =queries.php/5258.
SELECT SQL_CACHE
UserGroup.ID,
UserGroup.Name,
UserGroup.Website,
Institution.Name as instname,
Institution.ID as instid
FROM
UserGroup
left join InstitutionGroupPermission on UserGroup.ID=InstitutionGroupPermission.UserGroupID
left join InstitutionGroup on InstitutionGroupPermission.InstitutionGroupID=InstitutionGroup.ID
left join InstitutionGroupMember on InstitutionGroup.ID=InstitutionGroupMember.InstitutionGroupID
left join Institution on InstitutionGroupMember.InstitutionID = Institution.ID
left join InstitutionClient on Institution.ID = InstitutionClient.InstitutionID
WHERE
Institution.ID=text AND
InstitutionClient.ClientStatus NOT LIKE "MEM" AND
InstitutionClient.ClientStatus NOT LIKE "PRO"
ORDER BY
UserGroup.Name
Unknown column 'text' in 'where clause'|
|
| |
|
+++ DB-Error. file/pos =queries.php/5870.
SELECT SQL_CACHE
Institution.ID,
(InstitutionClient.ClientStatus IS NOT NULL) AS showLink,
(InstitutionClient.ClientStatus = 'PRO') AS showGlobe,
(InstitutionClient.ClientStatus = 'MEM' ) AS showGlobeMEM,
(InstitutionClient.ClientStatus = 'END') AS closed
FROM
Institution
LEFT JOIN InstitutionClient ON Institution.ID = InstitutionClient.InstitutionID
WHERE
Institution.ID =
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 11
|
|
|
|
*** query_institutionByID(): Unknown column 'text' in 'where clause' |
| |
*** query_Fairs(): Unknown column 'text' in 'where clause'*** query_promotedArtists(): Unknown column 'text' in 'where clause'
|
|
top