Adv Guestbook 2.3.1

Message:
MySQL Error : Database Error
Error Number: 1046 No Database Selected
Date : Fri, March 19, 2004 22:55:58
IP : 127.0.0.1
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461)
Referer : http://localhost/test/guestbook/install.php
PHP Version : 4.3.4
OS : WINNT
Server : Apache/2.0.47 (Win32) PHP/4.3.5RC4-dev
Server Name : localhost

This is a new install by a Novice new install of MySql and PHP on Windows 2000.
I ran install.PHP and all went well.
I then clicked on the link to create the Adminstrative function...

Is this a configuration problem for NySQL or what?

Carl

Hi Carl,

Did you dou this?

First go to the directory where you have unzipped the guestbook and go to the admin directory.
Locate “config.inc.php” open it with notepad.
You should see the following:

<?php
/* database settings */

$GB_DB["dbName"] = "";
$GB_DB["host"] = "localhost";
$GB_DB["user"] = "root";
$GB_DB["pass"] = "";

Now type the following:

$GB_DB["dbName"] = "test"; Type here the name of your new database ( In my case “test”)
$GB_DB["host"] = "localhost"; Leave this alone (localhost) Some hosting providers use a different setting for the host like Yahoo they us “mysql” instead of “localhost”
$GB_DB["user"] = "root"; Type here your MySQL administrator name, if you didn’t make one when you installed MySQL then it should be “root”
$GB_DB["pass"] = ""; Type here your MySQL password, if you didn’t make one when you installed MySQL then it should be blank.

Yes, I handled that as appropriate. Since I had not added users yet, I left the default user 'root" and no password. I had played around with creating a 'MYTEST' database and one table and that all works.

I have now abandonded Guestbook 2.3.1.
I should explain.
I have Guestbook 1.01 working since July 15, 2001 on a commercial host provider.

I am moving my webs to my own server now and am almost done. Only one web has a guest book and it is my wife's.

After looking at the version 2.3.1 Table design, I dicided I can't efectively import the old data, and my wife won't accept that.

So now I am trying to install Guestbook 1.01 on my server, and I have a slightly different problem: I now have administrator user and pasword and it has ALL authority.

Running install.php produces this message and I don't know how to handle it.
Forbidden
You don't have permission to access /guestbook/ Notice: Undefined variable: PHP_SELF in D:/webroot/rnc3.net/guestbook/install.php on line 45 on this server.
--------------------------------------------------------------------------------
Apache/2.0.47 (Win32) PHP/4.3.5RC4-dev Server at 192.168.1.51 Port 80

trying to install Guestbook 1.01
Continuation of my topic:
Adv Guestbook 2.3.1

Since the Install.php fails, I have manyally created database "guestbook". I have manually created the table:
mysql> CREATE TABLE guestbook(
-> id int(9) DEFAULT '0' NOT NULL auto_increment
-> name varchar(50) NOT NULL,
-> email varchar(60) NOT NULL,
-> url varchar(70) NOT NULL,
-> date int(11) NOT NULL,
-> host varchar(60) NOT NULL,
-> comment text NOT NULL,PRIMARY KEY (id));

But now I see problems that may be related to install configuration.
- When I try to sign-in from the panel of admin.php, using the pasword in the readme, nothing happens, so I tried my mysql administrator user and pw. Still nothing happens.

-When I run addentry.php and fill in the form,
Preview button clears the form.
Submit button clears the form.
"back to Guestbook" link operated correcttly but no rows in table guestbook.guestbook.
-Manually SELECT * FROM guestbook shows 0 rows.

Any help appreciated!

Carl

If anyone is interested in looking at the source for ADV Guestbook 1.01 to help me with my installation problem, I have made it available here:
79 K

http://www.rnc3.net/auction/gbookphp.zip

Carl

Forget this thread.
I will start a new thread more specific to version 1.01.
I manually imported data and I can display it, but admin.php shows me the form, accepts data, but does not do anything, and addentry.php does not add a row.

Carl