Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'mmw_coin', table 'MuOnline.dbo.MEMB_INFO'; column does not allow nulls. INSERT fails. (severity 16) in C:\xampp\htdocs\mmw\includes\character.class.php on line 85

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mmw\includes\character.class.php on line 85

Warning: mssql_query() [function.mssql-query]: message: Violation of PRIMARY KEY constraint 'PK_warehouse'. Cannot insert duplicate key in object 'warehouse'. (severity 14) in C:\xampp\htdocs\mmw\includes\character.class.php on line 89

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mmw\includes\character.class.php on line 89

from the info i get that the mmw_coin into NULL , couse its NOT NULL but why is this i think the install of the web must import the right codes

in install.php is :
"ALTER TABLE memb_info add mmw_coin int not null default 0", / Not NULL but in register.php says it needs to be NULL

and also :
Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'mmw_status', table 'MuOnline.dbo.MEMB_INFO'; column does not allow nulls. INSERT fails. (severity 16) in C:\xampp\htdocs\mmw\includes\character.class.php on line 85

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mmw\includes\character.class.php on line 85

Warning: mssql_query() [function.mssql-query]: message: Violation of PRIMARY KEY constraint 'PK_warehouse'. Cannot insert duplicate key in object 'warehouse'. (severity 14) in C:\xampp\htdocs\mmw\includes\character.class.php on line 89

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mmw\includes\character.class.php on line 89

Now shows that and mmw_status needs to has NULL

by default in install.php says:
"ALTER TABLE memb_info add mmw_status int not null default 0", / So this needs to be NULL too

now unblock_time needs to has NULL too
Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'unblock_time', table 'MuOnline.dbo.MEMB_INFO'; column does not allow nulls. INSERT fails. (severity 16) in C:\xampp\htdocs\mmw\includes\character.class.php on line 85

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mmw\includes\character.class.php on line 85

Warning: mssql_query() [function.mssql-query]: message: Violation of PRIMARY KEY constraint 'PK_warehouse'. Cannot insert duplicate key in object 'warehouse'. (severity 14) in C:\xampp\htdocs\mmw\includes\character.class.php on line 89

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mmw\includes\character.class.php on line 89
/!\ Your Account Has Been Succe

by default in install.php is:
"ALTER TABLE memb_info add unblock_time int not null default 0", / so this must be NULL too

the same goes to block_date
"ALTER TABLE memb_info add block_date int not null default 0",

the same goes to ref_check
"ALTER TABLE memb_info add ref_check int not null default 0",

What is making this errors i tought that the install is right?

Добавлено (01.01.2011, 21:57)
---------------------------------------------
i have fixed it , sr for double post
Реклама