Database problem

Page 1 of 2 1 2
01/31/2018 07:52 TescoTaska#1
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!
01/31/2018 20:43 Nick#2
#moved
02/01/2018 08:19 TescoTaska#3
Know someone plase? :/
02/01/2018 12:16 Lauling#4
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
02/01/2018 12:47 TescoTaska#5
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.
02/01/2018 14:32 Lauling#6
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
02/01/2018 14:45 TescoTaska#7
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?
02/01/2018 14:58 Lauling#8
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?
02/01/2018 15:50 TescoTaska#9
I have vps so virtual root server and with all grants it isnt working
02/01/2018 16:39 Lauling#10
okay, which serverfiles do you use?
02/01/2018 16:47 TescoTaska#11
TWIX Work (Nirvana v3) but I had 3 different server files and same problem, dont think its cause files
02/02/2018 00:52 Lauling#12
yeah i think also that the files are not the Problem...
But currently i have no idea... all Things where u write are correct...
02/02/2018 14:44 TescoTaska#13
Its weird :/ i need it for registration and website

Im so lucky guy :D

Know someone? :/
02/05/2018 12:24 TescoTaska#14
up
02/07/2018 08:02 TescoTaska#15
.
Page 1 of 2 1 2