| *** query_institutionByID(): 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 '< AND
InstitutionType.LanguageID = 1 AND
City.LanguageID = 1 AND
Countr' at line 25 +++ 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=< AND
b.Inventory='Y'
order by
Surname asc, Year desc
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 '=< AND
b.Inventory='Y'
order by
Surname asc, Year desc' at line 14*** query_relatedNews(): 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 '< AND
Text != ""
ORDER BY
News.Timestamp DESC' at line 9
+++ 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=< AND
InstitutionClient.ClientStatus NOT LIKE "MEM" AND
InstitutionClient.ClientStatus NOT LIKE "PRO"
ORDER BY
UserGroup.Name
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 '=< AND
InstitutionClient.ClientStatus NOT LIKE "MEM" AND
InstitutionClient' at line 15|
|
| |
|
+++ 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(): 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 '< AND
InstitutionType.LanguageID = 1 AND
City.LanguageID = 1 AND
Countr' at line 25 |
| |
*** query_Fairs(): 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 '<
GROUP BY
Institution.ID
ORDER BY
Institution.Sortkey' at line 9*** query_promotedArtists(): 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 '< AND
ArtistPromotion.ProjectID = 1
ORDER BY
Surname,
Name' at line 12
|
|
top