Database problem

TescoTaska · 01/31/2018, 07:52

Hello guys,

i have a big problem with registration.
I tried some server files and server was online so I created website for registration (about 10 templates or CMS) and everything was okay, ranking was updated, login worked but registration wasnt. Website said that the account was created but in navicat in database wasnt.

Permisions have 777, could you help me please?

Thanks in advance!

Nick · 01/31/2018, 20:43

#moved

TescoTaska · 02/01/2018, 08:19

Know someone plase? :/

Lauling · 02/01/2018, 12:16

hi, this Problem can come on, when ur account table have more column then the regi script.

Check the mysql query from the regiscript.

mabye it is another error, idk it is difficult tho help without syserrs etc.

regards

TescoTaska · 02/01/2018, 12:47

Well, but I tried at least 10 website pages, now I am trying metin2cms.cf and its not too working, could you please tell me, where can I find the quieries in this CMS? and I tried two server files and same problem, too I tried to reinstall freebsd + mysql. I have 10.4.

I cant create account in navicat because I have to everytime fill in last_play and if I filled in I had a big problem with game, because the progress in game every time diappeared :/

---
I think its problem tiwh last_play but its not normal to fill in, it should be automatically.

$sql = "INSERT INTO account SET login = '".$username."', password = PASSWORD('".$password."'), real_name = '".$rl_name."', social_id = '".$sl_id."', email = '".$email."'";
$result = mysql_query($sql);

here are query of one reg page.

Lauling · 02/01/2018, 14:32

oke, i think this is not the Problem... This is my query and it works...

PHP Code:


			
$qry = "INSERT INTO account (login,password,real_name,social_id,email)

                VALUES('$an', PASSWORD('$pw'),'$nm','$lc','$em')";

                $rst = $con->query($qry);

do you have on your mysqlserver createt a account only for the Homepage/webspace?

when not, create a new user like this your.server.ip.adress@homepage set all rights for this user. Mybe the Problem is that the Webspace havnt permission to create a account.

regards

TescoTaska · 02/01/2018, 14:45

I have exactly account just for homepage created like root account in mysql, how can I set more permissions for create in database? Because I didnt have this problem so its new for me.

GRANT ALL PRIVILEGES ON *.* TO 'xxxx'@'%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;

----
I have freebsd vps with mysql + server and webhosting, it couldnt be the problem?

Lauling · 02/01/2018, 14:58

whit this grant command, u give all rights. U can with navicat see which rights are given. Navigate to the Homepage user.

u use hamachi or dyndns? or is this a virtual root server?

TescoTaska · 02/01/2018, 15:50

I have vps so virtual root server and with all grants it isnt working

Lauling · 02/01/2018, 16:39

okay, which serverfiles do you use?

TescoTaska · 02/01/2018, 16:47

TWIX Work (Nirvana v3) but I had 3 different server files and same problem, dont think its cause files

Lauling · 02/02/2018, 00:52

yeah i think also that the files are not the Problem...
But currently i have no idea... all Things where u write are correct...

TescoTaska · 02/02/2018, 14:44

Its weird :/ i need it for registration and website

Im so lucky guy

Know someone? :/

TescoTaska · 02/05/2018, 12:24

up

TescoTaska · 02/07/2018, 08:02

.