Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6
This is the forum to discuss the Wrox book Beginning PHP, Apache, MySQLWeb Development by Michael K. Glass, Yann Le Scouarnec, Elizabeth Naramore, Gary Mailer, Jeremy Stolz, Jason Gerner; ISBN: 9780764557446
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 19th, 2004, 08:25 AM
Authorized User
 
Join Date: Apr 2004
Location: Cincinnati, OH, USA.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default potential createmovie.php error

Some people may have experienced an error in createmovie.php on page 96 because of a line of deprecated code. While this doesn't always cause an error, if you do get a fatal error, you can try this fix:

INSTEAD OF
mysql_create_db("wiley");

USE
$query = mysql_query("CREATE DATABASE wiley")
or die(mysql_error());

-Elizabeth
 
Old May 28th, 2004, 01:33 PM
Authorized User
 
Join Date: May 2004
Location: , , .
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, Elizabeth. You are a true lifesaver. :D
 
Old June 12th, 2004, 09:13 PM
Authorized User
 
Join Date: Apr 2004
Location: Cincinnati, OH, USA.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by BuzzLY
 Thanks, Elizabeth. You are a true lifesaver. :D
Ahem, Standard Phrase #427, Buzz ;)

 
Old August 2nd, 2004, 01:25 PM
Registered User
 
Join Date: Aug 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to webmeister
Default

Elizabeth:

 Where can I get a list of the Standard Phrases? :)

BTW Great BOOK!!!!!!!!!!!! So far it is better than the others I have bought on the subject(s)...

Gary

 
Old August 3rd, 2004, 01:23 PM
Authorized User
 
Join Date: Apr 2004
Location: Cincinnati, OH, USA.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by webmeister
 Elizabeth:
Where can I get a list of the Standard Phrases? :)
Hmmm.. not sure I can divulge that; it's a very thorough list. ;). I can however tell you that Standard Phrase #427 is "Bite me, Buzz."

 
Old August 10th, 2004, 08:12 PM
Registered User
 
Join Date: Aug 2004
Location: Orlando, FL, .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you Elizabeth, at least now I am getting some type of error message instead of waiting around for a page that will never load. :(

The error reads:
"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 'KEY (people_id) ) TYPE=MyISAM AUTO_INCREMENT=7' at line 6"

Lines 1-8:
1 <?php
2 $connect = mysql_connect("localhost", "root", "****")
3 or die ("Hey, check your server connection.");
...
6 //Creates the main database
7 $query = mysql_query("CREATE DATABASE wiley")
8 or die (mysql_error());

and the quote is from line 45:
45 PRIMAY KEY (people_id)
46 ) TYPE=MyISAM AUTO_INCREMENT=7";

I have triple checked the code and can't seem to locate the problem. Thanks for the help in advance.

-Mike
 
Old August 11th, 2004, 09:33 AM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Line 45 should probably read "PRIMARY KEY (people_id)" --missing an "R" in primary.

 
Old August 11th, 2004, 10:11 AM
Registered User
 
Join Date: Aug 2004
Location: Orlando, FL, .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

um..., thank you.

 
Old August 25th, 2004, 09:46 AM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is the error that I have been generating:

Warning: mysql_connect(): Access denied for user: 'Stephen@localhost' (Using password: YES) in D:\Program Files\Apache Group\Apache2\test\createmovie.php on line 2
Hey dude, wake up and check your server connection.

I have the correct password, I know that because I can log into the server, and when prompted for the password, I am able to gain access...I know localhost is correct...so I have isolated the issue down to the username. I looked in the WinMySQLAdmin 1.4 interface and saw that the "Local Username" is Stephen so I tried that...I have tried "root", and generated nothing, as well as a variety of other names, and am tempted to start calling it names. What could be amiss? Thanks...





Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: movie.php & commit.php on p182-186, ch6 willburke BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 October 12th, 2004 02:48 PM
createmovie.php logon trouble JohnAlden BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 3 May 25th, 2004 01:11 PM
Error troubleshooting - createmovie.php samgman BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 May 13th, 2004 01:24 AM
createmovie.php joebloggs BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 11 April 26th, 2004 06:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.