Register Page Database Connection Error

11/17/2020 00:50 brunalima#1
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

i did followed the tutorial and the message at the top continue appearing with issues !!!
11/19/2020 10:49 Desponia#2
the correct data entered in the php?
11/19/2020 11:21 brunalima#3
yes so it wont connect idk why
11/23/2020 17:29 Amanecer#4
Maybe the inserted data doesn't match your table? There are probably some required columns that aren't being filled. Check the code or screenshot the INSERT statement in the source + your Account table (richt click > Design).
11/23/2020 23:13 brunalima#5
here [Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

i did changed system and register page if its works ! and anything works
11/24/2020 11:58 Amanecer#6
I see you're using the Register I released. It's currently missing the sUserIP column so replace:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW) VALUES (?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);

with:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW, sUserIP) VALUES (?, ?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);
$sth->bindValue(3, $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR);
11/24/2020 12:11 brunalima#7
what file from the folders i need to edit ????
i did not found the file to edit with these config above !
[Only registered and activated users can see links. Click Here To Register...]



that i need to edit?
11/24/2020 12:15 Amanecer#8
It should be index. Could you post full source so I can further assist you?
11/24/2020 14:37 brunalima#9
i will send you the private message
Check if the message has been sent for you!

if you do not receive the message here the link with the file

[Only registered and activated users can see links. Click Here To Register...]

the key i will send for u
11/25/2020 10:31 Amanecer#10
The link you've sent isn't the same Register as the screenshot in the first post? Please check htdocs/www and upload again!
11/25/2020 21:01 brunalima#11
i did sent for you again i guess its correctly!!
11/25/2020 22:14 Amanecer#12
Quote:
Originally Posted by Amanecer View Post
I see you're using the Register I released. It's currently missing the sUserIP column so replace:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW) VALUES (?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);

with:

$sth = $dbh->prepare('INSERT INTO tUser (sUserID, sUserPW, sUserIP) VALUES (?, ?, ?)');
$sth->bindValue(1, $_POST['uid'], PDO::PARAM_STR);
$sth->bindValue(2, md5($_POST['upw']), PDO::PARAM_STR);
$sth->bindValue(3, $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR);
Now you just have to do it as I previously said here. And of course define the Database in config.php (or index.php if you're using the single file version).
11/26/2020 00:09 brunalima#13
i did so continues with database error

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
11/26/2020 15:20 Amanecer#14
Change

$error = 'Database connect error!';

to

$error = $e->getMessage;

Try again and send the output.
11/27/2020 03:27 brunalima#15
[Only registered and activated users can see links. Click Here To Register...]

i guess its new error

and the password from the Account uses Md5 hash and do not normal password !!