Search the Community

I have downloaded the entire auction application from Chapter 15. All my database connections work fine and my application does not throw any errors that I know of, but I cannot login to the site. I have tried different usernames and passwords, but none of them work. I keep getting the error message "The submitted values do not match what is on file" I did however comment out the call to the JavaScript file login.js which contains an AJAX call to another login.php located in the AJAX folder. this allowed me to receive a successful login message, so I know at the very least my application is connecting to the database and reading the username and password correctly. It appears something in the AJAX call to the PHP script is not working. I am using XAMPP and NetBeans. Could it be I need to use a certain version of PHP? I believe I am using 5.4 but I can double check. Any advice you can give would help Thanks

Just as a short note, the SQL commands to create the three tables for the real-world site project in chapter 15, pg. 556 caused errors in phpMyAdmin with MAMP. I removed all of the single quotation marks throughout the code and everything ran smoothly. I guess this is a phpMyAdmin issue or maybe I'm using a different version than that used in the book. Still love Mr. Ullman's books and have nearly all of them now! Thanks

Hi, I hope someone can help me, i am going crazy. I am trying to populate the time zone tables, but everytime i try i get the same error message: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near './mysql_tzinfo_to_sql /usr/share/zoneinfo | /Applications/MAMP/Library/bin/mysql' at line 1 Now, i had read the MySQL manual several times, and tried: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql; somebody suggested using this variation since i am using MAMP: ./mysql_tzinfo_to_sql /usr/share/zoneinfo | /Applications/MAMP/Library/bin/mysql -p -u root mysql; or this one: ./mysql_tzinfo_to_sql /usr/share/zoneinfo | ./mysql -p -u root mysql i get the same ERROR 1064 message. I had check the path to the folders and i am sure is correct, AM I MISSING SOMETHING? Thanks in advance for any help MySQL version 5.5.9 Mac 10.5.8