Integrity constraint violation: 1052 Column 'pid' in where clause is ambiguous
Ich habe in einer 4.9.2 Version gerade das Problem, dass ich die Artikeln nicht mehr bearbeiten kann.
Die folgende Fehlermeldung kommt. Hat jemand eine Idee, woran das liegen kann? Besten Dank.
Code:
An exception occurred while executing 'SELECT tl_content.*, j1.`ribbon` AS mlJumpTo__ribbon, j1.`addImage` AS mlJumpTo__addImage, j1.`singleSRC` AS mlJumpTo__singleSRC, j1.`style_css` AS mlJumpTo__style_css, j1.`height_css` AS mlJumpTo__height_css, j1.`imgHeadline` AS mlJumpTo__imgHeadline, j1.`imgSubheadline` AS mlJumpTo__imgSubheadline, j1.`addArticle` AS mlJumpTo__addArticle, j1.`article` AS mlJumpTo__article, j1.`id` AS mlJumpTo__id, j1.`pid` AS mlJumpTo__pid, j1.`sorting` AS mlJumpTo__sorting, j1.`tstamp` AS mlJumpTo__tstamp, j1.`title` AS mlJumpTo__title, j1.`alias` AS mlJumpTo__alias, j1.`type` AS mlJumpTo__type, j1.`pageTitle` AS mlJumpTo__pageTitle, j1.`language` AS mlJumpTo__language, j1.`robots` AS mlJumpTo__robots, j1.`description` AS mlJumpTo__description, j1.`redirect` AS mlJumpTo__redirect, j1.`jumpTo` AS mlJumpTo__jumpTo, j1.`redirectBack` AS mlJumpTo__redirectBack, j1.`url` AS mlJumpTo__url, j1.`target` AS mlJumpTo__target, j1.`dns` AS mlJumpTo__dns, j1.`staticFiles` AS mlJumpTo__staticFiles, j1.`staticPlugins` AS mlJumpTo__staticPlugins, j1.`fallback` AS mlJumpTo__fallback, j1.`favicon` AS mlJumpTo__favicon, j1.`robotsTxt` AS mlJumpTo__robotsTxt, j1.`adminEmail` AS mlJumpTo__adminEmail, j1.`dateFormat` AS mlJumpTo__dateFormat, j1.`timeFormat` AS mlJumpTo__timeFormat, j1.`datimFormat` AS mlJumpTo__datimFormat, j1.`validAliasCharacters` AS mlJumpTo__validAliasCharacters, j1.`createSitemap` AS mlJumpTo__createSitemap, j1.`sitemapName` AS mlJumpTo__sitemapName, j1.`useSSL` AS mlJumpTo__useSSL, j1.`autoforward` AS mlJumpTo__autoforward, j1.`protected` AS mlJumpTo__protected, j1.`groups` AS mlJumpTo__groups, j1.`includeLayout` AS mlJumpTo__includeLayout, j1.`layout` AS mlJumpTo__layout, j1.`includeCache` AS mlJumpTo__includeCache, j1.`cache` AS mlJumpTo__cache, j1.`alwaysLoadFromCache` AS mlJumpTo__alwaysLoadFromCache, j1.`clientCache` AS mlJumpTo__clientCache, j1.`includeChmod` AS mlJumpTo__includeChmod, j1.`cuser` AS mlJumpTo__cuser, j1.`cgroup` AS mlJumpTo__cgroup, j1.`chmod` AS mlJumpTo__chmod, j1.`noSearch` AS mlJumpTo__noSearch, j1.`requireItem` AS mlJumpTo__requireItem, j1.`cssClass` AS mlJumpTo__cssClass, j1.`sitemap` AS mlJumpTo__sitemap, j1.`hide` AS mlJumpTo__hide, j1.`guests` AS mlJumpTo__guests, j1.`tabindex` AS mlJumpTo__tabindex, j1.`accesskey` AS mlJumpTo__accesskey, j1.`published` AS mlJumpTo__published, j1.`start` AS mlJumpTo__start, j1.`stop` AS mlJumpTo__stop, j1.`enforceTwoFactor` AS mlJumpTo__enforceTwoFactor, j1.`twoFactorJumpTo` AS mlJumpTo__twoFactorJumpTo, j1.`pct_theme` AS mlJumpTo__pct_theme, j1.`pct_theme_import` AS mlJumpTo__pct_theme_import, j1.`pct_theme_cto` AS mlJumpTo__pct_theme_cto, j1.`pct_megamenu` AS mlJumpTo__pct_megamenu, j1.`pct_mm_article` AS mlJumpTo__pct_mm_article, j1.`pct_mm_noreplace` AS mlJumpTo__pct_mm_noreplace, j1.`pct_mm_floating` AS mlJumpTo__pct_mm_floating, j1.`addFontIcon` AS mlJumpTo__addFontIcon, j1.`fontIcon` AS mlJumpTo__fontIcon, j1.`pct_structured_data` AS mlJumpTo__pct_structured_data FROM tl_content LEFT JOIN tl_page j1 ON tl_content.`mlJumpTo`=j1.id WHERE pid='13316' AND ptable='tl_article' LIMIT 0,30': SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'pid' in where clause is ambiguous