[SOLVED]Registration - should I allow something?

[Metin2 Dev 9199]

Hi, I'm sucessfully connected to my database on server.

But when I want to register, it won't create a new line in acoount.account

I've tried a lot of registration pages, but still the same problem. Should I allow something on server? Or what is the problem?

Thanks for all replies!

[ondry 365]

then its problem with your database most likely...

you can add me on skype and i will try to help you

[shepo 0]

Check the query from your registration page

[Sentrix 119]

Wait a second; have you tried adding a new account through navicat?

[Metin2 Dev 9199]

5 minutes ago, Sentrix said:

Wait a second; have you tried adding a new account through navicat?

I succesfully did it, but not via query, just manually I created a new line.

 

Edit:

5 minutes ago, Sentrix said:

Wait a second; have you tried adding a new account through navicat?

Well, I tried to use query and account are not created.

 

Query:

SELECT * FROM `account`;
INSERT INTO
account.account
(login,password,social_id)
VALUES
(Test,PASSWORD(Please),1234567);

[Sentrix 119]

Go in Navicat into the Design View (Design Table in the database) and make sure that all Not Null field names have a default value or are dealt with a query.

[Metin2 Dev 9199]

I'm very appreciate your answer.

But can u give me some more info? I can show u my design table of account table.

[tierrilopes 507]

Leave id, login, password, email and social_id with "Not Null" check, remove from all the others.

[Sentrix 119]

5 minutes ago, Chyumgo said:

I'm very appreciate your answer.

But can u give me some more info? I can show u my design table of account table.

Thanks :D, yeah that would be very useful to see (i.e. would be a suitable example:

[Metin2 Dev 9199]

Edited August 20, 2022 by Metin2 Dev
Core X - External 2 Internal

[Sentrix 119]

Okay, first of all lets look at your query:

26 minutes ago, Chyumgo said:

Query:

SELECT * FROM `account`;
INSERT INTO
account.account
(login,password,social_id)
VALUES
(Test,PASSWORD(Please),1234567);

It queries on login password and social_id therefore these fields should be not allowed null and all the others you can set to null so look at your Allow Null column in design view and compare to mine; tick all the fields that you do not fill in registration and un-tick login, password and social id and then your query should work fine :), have a good evening.

Regards, Sentrix

[Metin2 Dev 9199]

Love ya! <3

..but thanks to all

#Solved