Messages posted by: Anonymous

Ok, Seems I've made a big mistake, so scratch skipping step 4 of Art Sentinel's tutorial. I've tried using only one username for two databases, and it worked at first, but the very next time I tried to log in, it wouldn't. Now it won't even load up my guestbook page or my forum page (both db are sharing the same user). I gotta ask iPowerWeb how to fix that. Well, you learn by making mistakes I guess.
I was just wondering, when I do create a separate user for the guestbook database, do the errors mentioned about the tables in phpAdmin matter?

First of all, I want to thank you both, JTD and Art Sentinel for responding so quickly and helping me out.
Art, your approach definitely worked, but I did have to change just a few minor details. I hope you don't mind if I write them down because it might help someone as confused as me in the future

- 1st, in step 2 of your tutorial, i couldn't just enter the name I wanted for my DB. I had to do step 5 first, because my cpanel automatically added a prefix to the DB name. I wanted to name it gbook, but my cpanel renamed it into reneezar_gbook. This, reneezar_gbook is what I needed to enter into my install.php file in step 2 in order for it to work.

- 2nd, in step 9 when i went to Host Manager -> Databases -> Admin, it reported some kind of error because I had multiple usernames (I also have a username for my phpBB forum). It said something about not creating the tables properly. I started over, went into my cpanel where I SKIPPED step 4 and created a DB only (step 5). I got to the end and it worked! until...

- 3rd, the guestbook administration page popped up, but I was unable to log in. So I searched the forums some more and found out that in this case the username and password must be reset following the easy directions at this link http://proxy2.de/forum/viewtopic.php?t=2934&highlight=reset+password .

And it was fixed!!! Once again, thabk you for your help

Okay I think it would be helpful to post the site where the guestbook is located.

http://eric.thirtysilverpieces.net/guestbook/index.php

And it should be that you won't see images anywhere. I've tried to change at least one link manually in Dreamweaver and it should have resulted in appearing from the right folder -- though it seems that the initial links in the templates are correct

. However, if you look on the index page above, I tried to get an image to appear on that page from the guestbook/img folder and nothing.

Now everything else seems to be in working order. I don't know if this is a problem but my FTP software is set for the main domain. I granted write permissions in a folder in that domain so instead of eric.thirtysilverpieces.net it was thirtysilverpieces.net/eric. I don't know if that makes a difference or not?

Secondly, since the software is installed manually does that mean I can't edit those php files in the admin panel, like I can in the one on the main site? Or do I need to do something to those files to make them edittable?
All the directories in eric.thirtysilverpieces.net have been granted write permissions to chmod 777.

Hi Renee,

I think I can make your day, my friend! Right this second, I'm configuring a guestbook for a client of mine (who uses iPowerWeb as his hosting service also). I had the same trouble you did. I found a working solution! I see no reason it be cannot used to help you as well. Try this:

1. Open Admin/config.inc.php in notepad. (You're going to be working with the file you have placed on your server already.)

2. <?php
/* database settings */

$GB_DB["dbName"] = ""; <-- Change this to whatever database name you want (i.e. "MyCoolAndFinallyWorkingDB")
$GB_DB["host"] = "localhost"; <-- Touch this and you will die
$GB_DB["user"] = "root"; <-- Change this to your primary login for iPowerWeb
$GB_DB["pass"] = ""; <-- Here you type in your primary password

Save. Upload the updated config.inc.php file to your server, overwritting the one that is there.

3. Go into your iPowerWeb control panel. Click Host Manager -> Databases -> Setup

4. Here, add a new user (at the bottom). Make certain to write down your username and password.

5. At the top, in the 'add database' edit box, type the exact name of the database you chose to add to step 2. Press 'add'.

6. Now got to: www.YOURURL.com/(name of your guestbook folder)/install.php

7. You will be greeted with a familiar screen. This time you will conquer it! :) Type the info in. Copy what you added in Step 2.

8. Press the 'ceate table' button. Presto! :)

9. Log into to your iPowerWeb control panel again. This time, go to Host Manager -> Databases -> Admin

10. Type in your new User account name and password.

11. Press the databases link on the main page that appears. Next select the database you just created. Here you will see that 10 tables were correctly added to your guestbook database.

12. Jump up and down excitedly and stop yanking your hair out. ;)

.

I hope this helps you! This is what I just did a few minutes ago. I am having no troubles as of yet...

Take care.

- Art Sentinel

http://www.artsentinel.net

Yes I have. Then it also says it is unable to connect to the database. I've tried using the username given to me from iPowerWeb, I've tried using the username for my phpBB database (I read in these forums that one username can have two databases) and I've also tried to create a new username for the guestbook database. Whatever I try, I either get Cannot create database or Cannot connect to database. I wonder what I'm missing, there must be something...

Okay I have an Advanced Guestbook 2.3.1 that I installed with cpanel here: www.thirtysilverpieces.net/gb/index.php. It works fine, I can edit the templates in the admin.

I've tried manually installing the guestbook on a subdomain for a friend of mine. However, I cannot get the images to appear while images from the main site appear just fine. http://eric.thirtysilverpieces.net/index.html
I checked to see if it could just be the format of the location link but I tried to get an image to appear on the index page for the subdomain and I can't seem to get it to work. Secondly, even though I've granted write permission to the public and tmp files, I am not able to edit the templates in the admin panel.

I could really use some help with this. I've tried to find it in other posts. Thanks for your time.

This is what it tells me when I use my password:

Cannot create new database: guestbook
--------------------------------------------------------------------------------

MySQL Error : Cannot create new database: guestbook
Error Number: 1044 Access denied for user: 'reneezar@localhost' to database 'guestbook'
Date : Fri, July 2, 2004 08:52:32
IP : 138.89.187.196
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.reneezara.com/guestbook/install.php
PHP Version : 4.3.4
OS : FreeBSD
Server : Apache/1.3.27 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.3.4 mod_ssl/2.8.14 OpenSSL/0.9.7d
Server Name : reneezara.com

Nope, I've tried that too. Still nutting

Unfortunately that option isn't available

hi guys, the guestbook is fantastic, works perfect! but.... is it possible to moderate new posts BEFORE they go live on the guestbook? .. this would be really usefull to stop idiots posting sh**te on my book! Help!

whonoes wrote:I have alos found in body.php temlate the following



$TPL[GB_JUMPMENU]



If I remove this then the drop down menu goes away... so once again how do I add more links into this?

/very confused

well, was looking on how to remove that, thanks a lot!

Please give us the link

Hello all,
I've tried to install the Advanced Guestbook 2 with the help of the Jam'n's tutorial but when I set the values in the install.php file and click on "Create new DB and table" I keep getting an error (below). I've tried different combinations of database names (I read here in the forums that some providers need a prefix in front of the database name, etc.). I've searched all the posts for help, but what ever I try I get the same error.
I've changed all the chmod settings as they should be.
I'm using the username provided to me by iPowerWeb. I never set a password. I tried creating one just to see if it works, and still nothing. My site is www.reneezara.com
If anyone can help, that would be great coz I'm out of ideas?
Thanx

THE ERROR
Warning: mysql_connect(): Access denied for user: 'reneezar@localhost' (Using password: NO) in /home/reneezar/public_html/guestbook/install.php on line 242
Cannot connect to database
--------------------------------------------------------------------------------

MySQL Error : Cannot connect to database
Error Number: 1045 Access denied for user: 'reneezar@localhost' (Using password: NO)
Date : Thu, July 1, 2004 13:18:24
IP : 138.89.141.57
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.reneezara.com/guestbook/install.php
PHP Version : 4.3.4
OS : FreeBSD
Server : Apache/1.3.27 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.3.4 mod_ssl/2.8.14 OpenSSL/0.9.7d
Server Name : reneezara.com

I figured it out....

But, by any chance does anyone know a good php editor?

I installed correctly, and didn't edit any of the files. However, when I take my poll - http://www.shiversofhorror.com/testpoll.php - and submit my vote I get:

If I look on line 21 of poll_cookie.php its the following:

Any help would be much appreciated. Thanks!