SQL Error - Unknown column 'LinkType' in 'where clause' #101
Description
In the CMS, the "link existing" ajax call triggers the following error:
ERROR [Emergency]: Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query:
SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" NOT IN
SELECT DISTINCT "LinkableLink"."ID"
FROM "LinkableLink"
INNER JOIN "ContactUsPage_LinkedPages" ON "ContactUsPage_LinkedPages"."LinkableLinkID" = "LinkableLink"."ID"
WHERE ("ContactUsPage_LinkedPages"."ContactUsPageID" = ?)))
AND (("LinkableLink"."Title" LIKE ?)
OR ("LinkType" LIKE ?)
OR ("LinkURL" LIKE ?))
ORDER BY "LinkableLink"."Title" ASC
LIMIT 20
Unknown column 'LinkType' in 'where clause'
IN GET /admin/pages/edit/EditForm/7/field/LinkedPages/search?gridfield_relationsearch=test
Line 64 in /var/www/html/vendor/silverstripe/framework/src/ORM/Connect/DBConnector.php
Source
======
55: if (!empty($sql)) {
56: $formatter = new SQLFormatter();
57: $formattedSQL = $formatter->formatPlain($sql);
58: $msg = "Couldn't run query:\n\n{$formattedSQL}\n\n{$msg}";
59: }
60:
61: if ($errorLevel === E_USER_ERROR) {
62: // Treating errors as exceptions better allows for responding to errors
63: // in code, such as credential checking during installation
* 64: throw new DatabaseException($msg, 0, null, $sql, $parameters);
65: } else {
66: user_error($msg, $errorLevel);
67: }
68: }
69:
70: /**
