{The Complete PHP MVC Course: Build a Modern eCommerce Store }

Posted In CategoryGeneral Discussion
  • Wendell 1 month ago
    ! ) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'' in C:\wamp64\www\DevScreenCast\ecommerce\vendor\illuminate\database\Connection.php on line 647
    ( ! ) PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list' in C:\wamp64\www\DevScreenCast\ecommerce\vendor\illuminate\database\Connection.php on line 445
    Call Stack

    Need some help here Terry, I followed your instuctions, whe I enter acme.dev website works perfect, Now when I register I am getting an error, the data base already setup, is there something I have to update since I am using your zip file

  • Terry Ogbemudia 1 month ago

    Hi Wendell, from the error message it looks like your Database is missing a column in the users table, to fix this add a new column named updated_at dataype timestamp and check null.

    let me know if that resolves the issue  

  • Terry Ogbemudia 1 month ago

    Or you can just run this query 

    ALTER TABLE users
    ADD COLUMN updated_at timestamp NULL DEFAULT NULL
  • Wendell 1 month ago

    Ok Terry, Irealized I make a couple of simple mistakes, I had all the columns how ever did not put the d to create_at update_at and delete_at, So I just added the d to make them pass tense, ex. create_at = created_at

  • Terry Ogbemudia 1 month ago

    Good is the issue resolved now.

Please login or register to leave a response.