Unable to add a new column with foreign key

» laravel » Unable to add a new column with foreign key

By : smig1

Date : January 12 2021, 01:40 AM

it should still fix some issue That is because you're trying to create a new column with a foreign key constraint but without setting a default value. So you either set it to be nullable or set a default value (which must be an existed ID in your parent_names table)

code :

$table->unsignedBigInteger('parentsid')->default(1);

Share :

Kendo Grid UI bind foreign key column based on other foreign key column value

By : Aaron Phillips

Date : March 29 2020, 07:55 AM

may help you . you need to use .CascadeFrom("COUNTRY_ID") in dropdown of the Location then you need to send the selected country and send to the controller

Adding a column as a foreign key gives ERROR column referenced in foreign key constraint does not exist

By : Ames

Date : March 29 2020, 07:55 AM

it should still fix some issue To add a constraint to a column It needs to exists first into the table there is no command in Postgresql that you can use that will add the column and add the constraint at the same time. It must be two separate commands. You can do it using following commands:
First do as:

code :

ALTER TABLE links_chatpicmessage ADD COLUMN sender INTEGER;

ALTER TABLE links_chatpicmessage 
   ADD CONSTRAINT fk_someName
   FOREIGN KEY (sender) 
   REFERENCES auth_user(column_referenced_name);

alter table links_chatpicmessage 
      add column sender integer, 
      add constraint fk_test 
      foreign key (sender) 
      references auth_user (id);

Unable to drop a foreign key column in MySql

By : Giani Arabu

Date : March 29 2020, 07:55 AM

Does that help I added a column in a table (query below) , first drop the foreign key constraint then drop the column
eg:

code :

alter table table_name drop constraint constraint_name


alter table table_name drop column column_name

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_NAME='YourTableName';

Unable to insert into table where column is a foreign key

By : user1763474

Date : March 29 2020, 07:55 AM

To fix the issue you can do Error tells you that pgsql cannot find field brandid (instead of brandId as you expected). Difference is i vs I. Try put field name in insert query in double quotes

code :

INSERT INTO "Item" (name, price, sizes, "brandId", "deptId") VALUES
    ('Air Force 1', '120.00', '{"12" : 1 , "10" : 12}',
        (SELECT id FROM "Brand" WHERE name= 'Nike'),
        (SELECT id FROM "Department" WHERE name= 'Mens Shoes'));

MySQL - Error in foreign key constraint. Unable to create Foreign Key

By : user3056067

Date : December 21 2020, 08:30 PM

will help you user_role.user_id is INT UNSIGNED, but users.user_id is just INT. They have to be the same datatype. Either change user_role.user_id to INT, or change users.user_id to INT UNSIGNED.