Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.35 KB | None | 0 0
  1. PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab/html/includes/api_authentication.php:108
  2. Stack trace:
  3. #0 /opt/unetlab/html/includes/api_authentication.php(108): PDOStatement->execute()
  4. #1 /opt/unetlab/html/api.php(121): apiLogin(Object(PDO), Object(PDO), Array, 'f2b71ccc-b0f8-4...')
  5. #2 [internal function]: {closure}()
  6. #3 /opt/unetlab/html/includes/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)
  7. #4 /opt/unetlab/html/includes/Slim/Slim.php(1357): Slim\Route->dispatch()
  8. #5 /opt/unetlab/html/includes/Slim/Middleware/Flash.php(85): Slim\Slim->call()
  9. #6 /opt/unetlab/html/includes/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call()
  10. #7 /opt/unetlab/html/includes/Slim/Middleware/PrettyExceptions.php(67): Slim\Middleware\MethodOverride->call()
  11. #8 /opt/unetlab/html/includes/Slim/Slim.php(1302): Slim\Middleware\PrettyExceptions->call()
  12. #9 /opt/unetlab/html/api.php(1339): Slim\Slim->run()
  13. #10 {main}
  14.  
  15. Here is the referred portion of the code from api_authentication.php file:
  16. CODE: SELECT ALL
  17. 106 $query = "replace into guacamole_user(user_id,username, password_hash, password_date ) values  ( ".($pod+1000)." , '".$username."', UNHEX(SHA2('unl',256) ), '".date("Y-m-d H:i:s")."');";
  18. 107 $statement = $html5_db -> prepare($query);
  19. 108 $statement -> execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement