Forum > Tools

[TOOL] WDBX Editor

<< < (3/5) > >>

Nupper:
Known Database Issue
SQL Error (1364): Field "M_lang_enGB" Doesn't have a default value
Its like that with all with no Default value

barncastle:

--- Quote from: "Nupper" ---Known Database Issue
SQL Error (1364): Field "M_lang_enGB" Doesn't have a default value
Its like that with all with no Default value
--- End quote ---

Thanks for reporting this, it sounds like you've got your MySQL server in STRICT which enforces these kinds of policies. I'll update the program when I get a chance to default strings to a non-null character.

Nupper:

--- Quote from: "barncastle" ---
--- Quote from: "Nupper" ---Known Database Issue
SQL Error (1364): Field "M_lang_enGB" Doesn't have a default value
Its like that with all with no Default value
--- End quote ---

Thanks for reporting this, it sounds like you've got your MySQL server in STRICT which enforces these kinds of policies. I'll update the program when I get a chance to default strings to a non-null character.
--- End quote ---
How would i disable the strict for Non-Null Characters in mysql

barncastle:

--- Quote from: "Nupper" ---How would i disable the strict for Non-Null Characters in mysql
--- End quote ---

If you run
--- Code: ---select @@sql_mode;
--- End code ---
it will tell you what mode your engine is running in. Apparently STRICT_TRANS_TABLES is the default now so I'd suggest just updating any text columns to have a default of an empty string literal.

I don't know how many fields you need to alter but the below will generate the SQL needed to bulk update them all for you, obviously replace <table_name> with your table's name.

--- Code: ---SELECT GROUP_CONCAT(CONCAT('ALTER TABLE ','<table_name>',' ALTER COLUMN `',COLUMN_NAME,'`  SET DEFAULT '''';') SEPARATOR ' ') FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '<table_name>' AND DATA_TYPE = 'text';

--- End code ---

I've pushed a fix for this to the git repo, I'd be grateful if you had a chance to test it works.

Nupper:
is there a compiled update...my visual studieo is to old for it i think.

Navigation

[0] Message Index

[#] Next page

[*] Previous page