|
 Ashraf Gheith - 2016-12-21 14:02:05 - In reply to message 10 from Superluk
OK I fixed some issues.
download 1.0.14 and test it
 Superluk - 2016-12-21 14:39:56 - In reply to message 11 from Ashraf Gheith
Something happened, but with error:
<br />
<b>Fatal error</b>: Call to a member function prepare() on null in <b>/login_class4/class/user.php</b> on line <b>249</b><br />
 Ashraf Gheith - 2016-12-21 15:29:03 - In reply to message 12 from Superluk
This is an error when have a problem with PDO. Can you post your config file? It fails on registration on the first connection with the DB. I have tested on my localhost and on a different server and I am not getting this error.
 Superluk - 2016-12-21 15:59:25 - In reply to message 13 from Ashraf Gheith
i only changed these three lines for PDO connection.
session_start();
define('conString', 'mysql:host=mysql.server.de;dbname=db999999_9');
define('dbUser', 'db999999_9');
define('dbPass', 'dmypassword');
i checked on web, but all is as it should be - the error is probably not in config-file.
 Superluk - 2016-12-21 17:23:30 - In reply to message 14 from Superluk
now i checked PDO connection with another (pdo)class and same db:
require_once 'SimplePDOinit.php';
$user = $database->get_row( "SELECT * FROM users WHERE id = ? ", array( 1 ) );
?>
<tr>
<td><?php echo $user->fname;?></td>
</tr>
worked fine with Result: Max
there must be an error in your user.php class
 Superluk - 2016-12-21 17:29:19 - In reply to message 15 from Superluk
i got solution now:
the problem is the FIRST user in database
if you do NOT have any users registered - it means, the database is empty - than is there the error, we mentioned.
i added a user via phpMyAdmin and it works. Got Confirmation Email with code for the confirmation box, all worked fine.
That is, why the class worked fine on your computer, but not on mine.
So please find bug, that handles the database correctly, when there is NO USER in the database.
blessings and a great christmas time
 Superluk - 2016-12-21 17:39:10 - In reply to message 16 from Superluk
uppps - after logged in with code confirmation sent via email, i logged out and tried to login again.
Alert: Invalid login information or the account is not activated
But: login information are correct, and account is activated (i have had a look with phpMyAdmin to the database)
?!?
 Ashraf Gheith - 2016-12-22 12:10:46 - In reply to message 17 from Superluk
Thank you for your input, I will check both errors you reported today and repost the fixes.
 Ashraf Gheith - 2016-12-22 23:04:37 - In reply to message 18 from Ashraf Gheith
I have checked your case but that still is not happening to me. Even with an empty DB it works fine. Also try the second case and it works fine.
I have included a new file info.php, please run it and send me these info:
PHP version, MySQL version and if PDO module is installed.
 Superluk - 2016-12-23 11:05:52 - In reply to message 19 from Ashraf Gheith
as i mentioned commets before, i tried with another PDO class to connect to database and it worked.
After adding user (manualy) it worked to get email-confirmation-code. After inserting into Email-confirmation-code-Form i was logged in
After loggin out and try to login again, it says: Invalid login information or the account is not activated.
I checked login information in my database via phpmyadmin:
user_role = 1
confirmed = 1
|