search

FriendsOfREDAXO / demo_community

Demonstriert eine Community-Website auf Basis von REDAXO 5.
MIT License
39 stars 4 forks source link

Login error #16

Closed DavidBruchmann closed 7 years ago

DavidBruchmann commented 7 years ago

Beim Login erhalte ich folgende Fehlermeldung:

Error while executing statement using params {"p1":"mail@domain.com"}! SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'where clause'

DavidBruchmann commented 7 years ago

Der Fehler wird durch #17 NICHT gelöst.

DavidBruchmann commented 7 years ago

Stack-trace:

array(14) {
  [0]=>
  array(7) {
    ["file"]=>
    string(75) "\redaxo-5.3.0\redaxo\src\core\lib\sql\sql.php"
    ["line"]=>
    int(328)
    ["function"]=>
    string(7) "execute"
    ["class"]=>
    string(7) "rex_sql"
    ["object"]=>
    object(rex_sql)#83 (16) {
      ["debug":protected]=>
      bool(false)
      ["values":protected]=>
      array(0) {
      }
      ["rawValues":protected]=>
      array(0) {
      }
      ["fieldnames":protected]=>
      NULL
      ["rawFieldnames":protected]=>
      NULL
      ["tablenames":protected]=>
      NULL
      ["lastRow":protected]=>
      array(0) {
      }
      ["table":protected]=>
      string(0) ""
      ["wherevar":protected]=>
      string(0) ""
      ["whereParams":protected]=>
      array(0) {
      }
      ["rows":protected]=>
      int(0)
      ["counter":protected]=>
      int(0)
      ["query":protected]=>
      string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      ["params":protected]=>
      array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
      ["DBID":protected]=>
      int(1)
      ["stmt":protected]=>
      object(PDOStatement)#85 (1) {
        ["queryString"]=>
        string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      }
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(2) {
      [0]=>
      &array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
      [1]=>
      &array(0) {
      }
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(75) "\redaxo-5.3.0\redaxo\src\core\lib\sql\sql.php"
    ["line"]=>
    int(950)
    ["function"]=>
    string(8) "setQuery"
    ["class"]=>
    string(7) "rex_sql"
    ["object"]=>
    object(rex_sql)#83 (16) {
      ["debug":protected]=>
      bool(false)
      ["values":protected]=>
      array(0) {
      }
      ["rawValues":protected]=>
      array(0) {
      }
      ["fieldnames":protected]=>
      NULL
      ["rawFieldnames":protected]=>
      NULL
      ["tablenames":protected]=>
      NULL
      ["lastRow":protected]=>
      array(0) {
      }
      ["table":protected]=>
      string(0) ""
      ["wherevar":protected]=>
      string(0) ""
      ["whereParams":protected]=>
      array(0) {
      }
      ["rows":protected]=>
      int(0)
      ["counter":protected]=>
      int(0)
      ["query":protected]=>
      string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      ["params":protected]=>
      array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
      ["DBID":protected]=>
      int(1)
      ["stmt":protected]=>
      object(PDOStatement)#85 (1) {
        ["queryString"]=>
        string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      }
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(2) {
      [0]=>
      &string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      [1]=>
      &array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(113) "\redaxo-5.3.0\redaxo\src\addons\yform\plugins\manager\lib\yform\manager\dataset.php"
    ["line"]=>
    int(180)
    ["function"]=>
    string(8) "getArray"
    ["class"]=>
    string(7) "rex_sql"
    ["object"]=>
    object(rex_sql)#83 (16) {
      ["debug":protected]=>
      bool(false)
      ["values":protected]=>
      array(0) {
      }
      ["rawValues":protected]=>
      array(0) {
      }
      ["fieldnames":protected]=>
      NULL
      ["rawFieldnames":protected]=>
      NULL
      ["tablenames":protected]=>
      NULL
      ["lastRow":protected]=>
      array(0) {
      }
      ["table":protected]=>
      string(0) ""
      ["wherevar":protected]=>
      string(0) ""
      ["whereParams":protected]=>
      array(0) {
      }
      ["rows":protected]=>
      int(0)
      ["counter":protected]=>
      int(0)
      ["query":protected]=>
      string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      ["params":protected]=>
      array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
      ["DBID":protected]=>
      int(1)
      ["stmt":protected]=>
      object(PDOStatement)#85 (1) {
        ["queryString"]=>
        string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      }
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(2) {
      [0]=>
      &string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      [1]=>
      &array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
    }
  }
  [3]=>
  array(6) {
    ["file"]=>
    string(113) "\redaxo-5.3.0\redaxo\src\addons\yform\plugins\manager\lib\yform\manager\dataset.php"
    ["line"]=>
    int(174)
    ["function"]=>
    string(15) "queryCollection"
    ["class"]=>
    string(25) "rex_yform_manager_dataset"
    ["type"]=>
    string(2) "::"
    ["args"]=>
    array(3) {
      [0]=>
      &string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      [1]=>
      &array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
      [2]=>
      &string(13) "rex_ycom_user"
    }
  }
  [4]=>
  array(6) {
    ["file"]=>
    string(111) "\redaxo-5.3.0\redaxo\src\addons\yform\plugins\manager\lib\yform\manager\query.php"
    ["line"]=>
    int(608)
    ["function"]=>
    string(15) "queryCollection"
    ["class"]=>
    string(25) "rex_yform_manager_dataset"
    ["type"]=>
    string(2) "::"
    ["args"]=>
    array(3) {
      [0]=>
      &string(82) "SELECT `rex_ycom_user`.* FROM `rex_ycom_user` WHERE `` = :p1 ORDER BY `login` DESC"
      [1]=>
      &array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
      [2]=>
      &string(13) "rex_ycom_user"
    }
  }
  [5]=>
  array(7) {
    ["file"]=>
    string(97) "\redaxo-5.3.0\redaxo\src\addons\ycom\plugins\auth\lib\ycom_auth.php"
    ["line"]=>
    int(120)
    ["function"]=>
    string(4) "find"
    ["class"]=>
    string(23) "rex_yform_manager_query"
    ["object"]=>
    object(rex_yform_manager_query)#52 (13) {
      ["table":"rex_yform_manager_query":private]=>
      string(13) "rex_ycom_user"
      ["alias":"rex_yform_manager_query":private]=>
      NULL
      ["selectResetted":"rex_yform_manager_query":private]=>
      bool(false)
      ["select":"rex_yform_manager_query":private]=>
      array(0) {
      }
      ["joins":"rex_yform_manager_query":private]=>
      array(0) {
      }
      ["whereOperator":"rex_yform_manager_query":private]=>
      string(3) "AND"
      ["where":"rex_yform_manager_query":private]=>
      array(1) {
        [0]=>
        string(8) "`` = :p1"
      }
      ["params":"rex_yform_manager_query":private]=>
      array(1) {
        ["p1"]=>
        string(25) "mail@domain.com"
      }
      ["paramCounter":"rex_yform_manager_query":private]=>
      int(2)
      ["orderBy":"rex_yform_manager_query":private]=>
      array(1) {
        [0]=>
        string(12) "`login` DESC"
      }
      ["orderByResetted":"rex_yform_manager_query":private]=>
      bool(false)
      ["groupBy":"rex_yform_manager_query":private]=>
      array(0) {
      }
      ["limit":"rex_yform_manager_query":private]=>
      NULL
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(0) {
    }
  }
  [6]=>
  array(6) {
    ["file"]=>
    string(97) "\redaxo-5.3.0\redaxo\src\addons\ycom\plugins\auth\lib\ycom_auth.php"
    ["line"]=>
    int(36)
    ["function"]=>
    string(5) "login"
    ["class"]=>
    string(13) "rex_ycom_auth"
    ["type"]=>
    string(2) "::"
    ["args"]=>
    array(1) {
      [0]=>
      &array(6) {
        ["loginName"]=>
        string(25) "mail@domain.com"
        ["loginPassword"]=>
        string(9) "myPassword"
        ["loginStay"]=>
        string(0) ""
        ["referer"]=>
        string(0) ""
        ["logout"]=>
        int(0)
        ["redirect"]=>
        string(0) ""
      }
    }
  }
DavidBruchmann commented 7 years ago

Authentifizierung aktivieren, dann klappts.

polarpixel commented 7 years ago

Danke für die Info! Die Authentifizierung war früher in der Demo sofort standardmäßig aktiviert, vermutlich hat sich da durch das yCom-Update etwas geändert, das wird im nächsten Demo-Update korrigiert.

DavidBruchmann commented 7 years ago

Ja etwas hinderlich wenn man erst mal Addons installieren und aktivieren muss. Nach der Analyse braucht man die Demo kaum noch, dann kennt man das System ;-)