Messages posted by: Jellocat

None of this is working. Thanks for your help. I need to find something else. Either Go Daddy is a lousy service to use with php/mysql, or the program is searching for something that doesn't exist.

When I use the following configuration I get this error response. I set up the database "miraculous" through Go Daddy's database set up thing which consists of:
Create New Database
Credits Available: 9 MySQL 0 MS SQL
MySQL Database: miraculous
UserName: ""
Password: ""
Confirm Password: ""

Each database I create lies on different servers. The first one has the host name of: mysql47.secureserver.net, the second has mysql55.secureserver.net. Do I use these servers instead of "localhost"?

Also, after the database is created, there's a link to the Open Manager to set up the database. It begins with setting up the tables:

Create new table on database miraculous :
Name :
Fields :

But I thought the guestbook program, itself, set up these parameters. I'm not a database person so I don't know what to do with this stuff.

I still get the following error after running the guestbook install program when I name the database in $GB_DB["dbName"] with what I set up in Go Daddy:

Cannot create new database: miraculous
--------------------------------------------------------------------------------

MySQL Error : Cannot create new database: miraculous
Error Number: 1007 Can't create database 'miraculous'. Database exists
Date : Sun, July 3, 2005 17:02:50
IP : 24.92.149.3
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Referer : http://www.miraculoushands.com/guestbook/install.php
PHP Version : 4.3.11
OS : Linux
Server : Apache/1.3.31 (Unix) mod_tsunami/2.0 FrontPage/5.0.2.2634 mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Name : www.miraculoushands.com

I'm having a MAJOR problem getting this to work. I am a newbie, completely, when it comes to PHP and SQL stuff, so please pardon me if I'm not doing things correctly.
I've read through the forum and d/led the install manual. I u/led all files to the server via FTP. I typed in the appropriate path for install, got the install screen and from there nothing seems to work.
I contacted GoDaddy to find out what they have. There is SQL and PHP on their servers, host name is: mysql47.secureserver.net (though I'm not sure if the tech guy I spoke with understood what I was asking for). I changed the necessary things in the config file to match the host name, etc. and nothing worked.
So I went back and used what the manual instructed: test for db name, localhost, root and got this:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/m/i/r/miraculous/html/guestbook/install.php on line 242
Cannot connect to database

MySQL Error : Cannot connect to database
Error Number: 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Date : Sun, July 3, 2005 13:34:26
IP : 24.92.149.3
Browser : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.

Gecko/20050511 Firefox/1.0.4 (ax)
Referer : http://www.miraculoushands.com/guestbook/install.php
PHP Version : 4.3.11
OS : Linux
Server : Apache/1.3.31 (Unix) mod_tsunami/2.0 FrontPage/5.0.2.2634 mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Name : www.miraculoushands.com

Now, through GoDaddy you can set up a DB and use their Open Manager to set up everything but I haven't a clue as to what I'm doing with SQL so I left it as is. I honestly don't know how to make this work. Any ideas??