I have just downloaded your application but I can't use it. I can't login, and I receive no error message. Whatever the username and password I use (either at admin.php or login.php) the system simply returns me to the default login screen and re-ask the login.
Is there any log file? I am running the IIS with MySql. All table were correctly created and populated - (I can see the admin/nimda user at tbl_login).
thanks in advance
regards
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
thanks for answering. I checked the settings for cookies in my Internet explorer but it seems already be accepting cookies from all sites visited.
However, I changed my web server to Apache instead of the internet explorer and the behavior is now a little bit different:
- I still can't login (whatever I type as the user name, first name and last name is not saved on the db and I am returned to the login.php page).
- I can log only at the admin.php page with the default user admin/nimda. Using this user, I can add new books/items to the library but any other operation fails - If I try (for example) to find a book previously recorded it fails (nothing is returned), but if I click in the list "all items" than I can see the books I had recorded.
Do you have any idea why this is happening?
thanks in advance
regards
bernardo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1) since you can do the admin login, the database is working and cookies are fine. so, i can't think of anything. you could try increasing the error reporting and then send me the message.
2) the search used employs the FULLTEXT feature in mySql to look for the word you search in either the title, author or abstract. i'd check the install of mysql to make sure it supports fulltext. also, the fulltext search needs at least 4 characters.
john
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry for asking this, I'm not very familiar with php. Where do I set it? I tried to set the"debug" variable at config.inc file with this value, but It didn't work. I believe that was not the correct place.
regards
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I found the variable and changed it. After restarting Apache, I got several warnings on the login.php screen. It seems that the most important one is the first one, which reports a "permission denied" while accessing MySql.
Do you know how can I verify which users are allowed/registered to use my DB at MySql?
Here are the log warnings captured:
Warning: mysql_connect(): Access denied for user: 'bsana1@mycomp.corp.company.org' (Using password: YES) in c:\program files\apache group\apache\htdocs\mainfile.inc on line 54
Notice: Undefined variable: last_name in c:\program files\apache group\apache\htdocs\login.php on line 50
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 31
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 32
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 33
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 34
Login Test Library
Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\mainfile.inc on line 133
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I have just downloaded your application but I can't use it. I can't login, and I receive no error message. Whatever the username and password I use (either at admin.php or login.php) the system simply returns me to the default login screen and re-ask the login.
Is there any log file? I am running the IIS with MySql. All table were correctly created and populated - (I can see the admin/nimda user at tbl_login).
thanks in advance
regards
there isn't a log file, but you can change the level of error reporting in mainfile.inc.
my guess is that cookies are disabled in the browser, at least that gives a similar behaviour on my system.
Hi,
thanks for answering. I checked the settings for cookies in my Internet explorer but it seems already be accepting cookies from all sites visited.
However, I changed my web server to Apache instead of the internet explorer and the behavior is now a little bit different:
- I still can't login (whatever I type as the user name, first name and last name is not saved on the db and I am returned to the login.php page).
- I can log only at the admin.php page with the default user admin/nimda. Using this user, I can add new books/items to the library but any other operation fails - If I try (for example) to find a book previously recorded it fails (nothing is returned), but if I click in the list "all items" than I can see the books I had recorded.
Do you have any idea why this is happening?
thanks in advance
regards
bernardo
1) since you can do the admin login, the database is working and cookies are fine. so, i can't think of anything. you could try increasing the error reporting and then send me the message.
2) the search used employs the FULLTEXT feature in mySql to look for the word you search in either the title, author or abstract. i'd check the install of mysql to make sure it supports fulltext. also, the fulltext search needs at least 4 characters.
john
Hi John,
what is the highest value for the "debug" variable?
thanks
regards
here's a helpful link:
http://www.phpfreaks.com/phpmanual/page/function.error-reporting.html
so, try:
error_reporting (E_ALL);
Sorry for asking this, I'm not very familiar with php. Where do I set it? I tried to set the"debug" variable at config.inc file with this value, but It didn't work. I believe that was not the correct place.
regards
no problem,
check out: mainfile.inc
on line 51 (or so), there's a line of code that looks like:
error_reporting(1);
just change that to:
error_reporting(E_ALL);
john
Thank you very much for all information provided.
I found the variable and changed it. After restarting Apache, I got several warnings on the login.php screen. It seems that the most important one is the first one, which reports a "permission denied" while accessing MySql.
Do you know how can I verify which users are allowed/registered to use my DB at MySql?
Here are the log warnings captured:
Warning: mysql_connect(): Access denied for user: 'bsana1@mycomp.corp.company.org' (Using password: YES) in c:\program files\apache group\apache\htdocs\mainfile.inc on line 54
Notice: Undefined variable: last_name in c:\program files\apache group\apache\htdocs\login.php on line 50
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 31
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 32
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 33
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\mainfile.inc:54) in c:\program files\apache group\apache\htdocs\header.inc on line 34
Login Test Library
Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\mainfile.inc on line 133
yea, looks like the problem is the connection to the database.
how did you run the script to create the tables? you could probably use that same thing to confirm a given login.
i haven't done much with admining mysql other than what my hosting company lets me do and it just lets me use my single user.