Question about MySQL and PHP4

[hempraider2002]

Hi, I am wanting to set up the Advanced Guestbook found at this site: http://www.proxy2.de/scripts.php

It requires MySQL and PHP4

Well I found the place in OPS where I can order MySQL for my site, but I didn't see anywhere to order PHP4...... or does PHP4 come with MySQL.

I have never worked with MySQL before and actually have no clue exactly what it does. All I know is that it controls databases so forgive me if I sound stupid here, but this guestbook looks really awesome and I would like to try setting it up.

Anyway I guess what I'm asking is do I need to order PHP4 when I order MySQL to make this work?

[alphadesk]

All you need to do is order the mySQL in the OPS area. php4 is installed on the servers already.
I have setup the guestbook 1.5, from that site that did not require mySQL. You might want to try it first. Then if you like it spring for the mySQL and go for the advanced version.
http://www.divedesk.com/book/guestbook.html

[hempraider2002]

Well I got MySQL now, but I think I screwed something up as I was doing the installation for the guestbook.

I keep getting this message after creating the tables for the database:

MySQL Error : Database Error
Error Number: 1050 Table 'book_auth' already exists
Date : Sun, October 27, 2002 19:48:07
IP : 67.35.218.56
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
Referer : http://www.spunkylee.com/guestbook/install.php
PHP Version : 4.2.3
OS : FreeBSD
Server : Apache/1.3.27 (Unix) FrontPage/5.0.2.2510 mod_ssl/2.8.11 OpenSSL/0.9.6a
Server Name : www.spunkylee.com

Is there anyway to have my MySQL database erased or reset or something so that I can start over. Would I need to contact powweb administration to have this done?

I think what happened is when I started to set up the guestbook I forgot to put my server (magnatar.powweb.com) for the host information and now I can't access the program because it keeps saying "book_auth" already exists or something... and so now I can't access the program. I tried deleting all the guestbook files and reinstalling them but that didn't seem to work.

[alphadesk]

Is there anyway to have my MySQL database erased or reset or something so that I can start over. Would I need to contact powweb administration to have this done?
You can manage your mysql (delete/create tables etc) with a phpmyadmin (http://help.powweb.com/tutorials/mysql/phpmyadmin/install.php) , but it sounds like you may not be ready for this. You might get Starr (maybe/maybe) not to delete your tables, so you can start with a fresh install.

It's really up to you to admin your DB, that's one reason I suggested using the other first, to get a hang of how this works.

[hempraider2002]

Well I've figured how to do that phpmyadmin thing. Thanks!!!!

And now I'm able to do the guestbook install putting the correct host name for the MySQL database...... but I get another error message when I trying going to the admin page saying there is something wrong with a password in one of the php files for the guestbook. Oh well, I'm tired and this thing is driving me crazy lol. I'm going to bed and will try to fix it tomorrow.

Thanks for your help Alpha. It is very much appreciated :)

[nietzsche]

i am going to install the advanced guest book 2.3.1
can you tell me how to configure the config.inc.php ?
what should i fill :

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

???

in what path should i upload to my site ? htdocs or above or cgi ?

and this :

Advanced Guestbook Setup
Your database:
Your MySQL host:
Your MySQL username:
Your MySQL password:

how to complete the configuration ?

create table or create new DB and table ?
i have already created a database for my phpBB forum ...

thanks ...