Skip to content

Tag: database

I am always getting an error everytime i try to add data in db: SQLSTATE[42703]: Undefined column: 7 ERROR: column

So, theres already a pre-made table in the database. Now, I am trying to connect my project to that specific table in the db. but everytime i try to insert data, im getting this error “SQLSTATE[42703]: Undefined column: 7 ERROR: column “updated_at” of relation “applicant_account_tbl” does not existnLINE 1: …”, “last_name”, “birthdate”, “email”, “password”, “updated_a…n ^ (SQL: insert into “applicant_account_tbl”

Python expression equivalent to include() of PHP

Is there any expression in Python that is equivalent to ‘include()’ of PHP? To be more specific, I want to make in python a file for database connection and another for queries, but the variable for the connection only exists in the connection file. If it was in PHP I could use ‘include()’ to call the connection variable in another

Method IlluminateDatabaseSchemaBlueprint::unsignedBidInteger does not exist

error in terminal C:xampphtdocslearninglaragonlavuedatabasemigrations2022_07_17_042348_create_transaction_details_table.php:18 IlluminateDatabaseSchemaBlueprint::__call() this my php migration }; When i put php artisan migration sees an error like above Answer There is a typo in your migration file on ‘transaction_id’ declaration. Your migration file should be like this. Check the line with the comment. Kindly read this.

how to simplify this complex query

This is an extract of one of my php functions. I’m struggling to get this optimized as is super slow, as I need to load all interview records, and then check if the current user is either assigned as user_id on the interview record, or if the user->id is in the interviews shared_user_ids which is json I’m also using PostgreSQL

Laravel eloquent update, 500 Internal Server Error

I want to update my database with Laravel eloquent update, but response is always 500 This is my model This is the function This is the route Exception: Thanks before, for helping.. Answer Loking at the exception: Seems like you don’t have updated_at column in your database table. There are two solutions for this: I: Create/update your migration to include