Bob Flynn's Chapter 10 - Need Help!

Report · Apr 10, 2008

I am using Bob Flynn's Book "...Dreamweaver CS3 with ASP, ColdFusion and PHP'. I am at chapter 10 when I test my pages "tours_detail.php", it runs correctly, however when I click on the hyperlink "Learn More About ..." the correct page is loaded "profiles.php", but the data is empty. I uploaded the completed files to my test server and I get the following errors:

Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/q/3/0/q300119/html/newland/Lesson10/Complete/newland-php/Connections/conn_newland.php on line 9

Fatal error: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/q/3/0/q300119/html/newland/Lesson10/Complete/newland-php/Connections/conn_newland.php on line 9

Help! Love the book, but now I am stuck!

Karen

Report · Apr 28, 2008

Hi Karen,

Sorry it's taken a while to get back to you. I have neglected the list for a few weeks. I follow your steps for the most part, but I'd like clarification of exactly what you uploaded to the server. Did you upload everything or just the files you worked on in that lesson? Was everything working on your test server after chapter 9?

Based on the error message it would seem the error is not actually in the files you were working on, but rather in the Connections/conn_newland.php file. If you overwrote your existing (functioning) conn_newland.php file with the one from the completed folder, it may not have the right connection string for your database.

Can you say a little about your test server? Is this the local install set up in the book or is this on an online server that would require a real username password combination (unlike the local test server I use in the book)?

If you can provide a little more detail I'll help you sort it out.

Cheers,

Bob Flynn