Ergebnis 1 bis 2 von 2

Thema: Integrity constraint violation: 1052 Column 'pid' in where clause is ambiguous

  1. #1
    Contao-Nutzer Avatar von eBlick
    Registriert seit
    01.04.2012.
    Ort
    Stuttgart
    Beiträge
    139
    User beschenken
    Wunschliste

    Standard 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

  2. #2
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    34.200
    Partner-ID
    10107

    Standard

    Dem Query nach kommt der Fehler aus einem PCT Modul. Hast du dein PCT Theme inkl. aller Module aktualisiert? Wenn ja, dann benutze den Debug-Modus und poste den kompletten Stack Trace im PCT Forum.

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Lesezeichen

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •