Главная | Топ серверов | Скины | Регистрация | Вход | English Version Приветствую Вас Гость | Показать правый блок
[ Новые сообщения · Участники · Правила форума · Поиск · RSS ]
  • Страница 1 из 1
  • 1
www.MyMuWeb.Ru - Форум » MyMuWeb » Помощь » [Help] Register problem
[Help] Register problem
diablo21Дата: Суббота, 01.01.2011, 21:57 | Сообщение # 1
Лейтенант
Группа: Проверенные
Сообщений: 35
Репутация: 2
Статус: Оффлайн
i have installed the web everything is ok but when i try to register account it says:

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

Сообщение отредактировал diablo21 - Суббота, 01.01.2011, 21:43
 
www.MyMuWeb.Ru - Форум » MyMuWeb » Помощь » [Help] Register problem
  • Страница 1 из 1
  • 1
Поиск:

This page is designed to be viewed best with Chrome. Home Page MyMuWeb By TFU.LV. Хостинг от uCoz.