Latest posts for the topic "Advanced Guest Book Errors, Errors, ..."

Advanced Guest Book Errors, Errors, ...

marogiannis — GMT

I have been trying to instll the Advanced Guest Book which came bundled with my hosting, but keep getting various error messages such as:

MySQL Error : Query Error
Error Number: 1146 Table 'annaapts_agbook1.book_config' doesn't exist
PHP Version : 4.3.9

Can someone kind enough assist me with this.?

Thanks

Re: Advanced Guest Book Errors, Errors, ...

Auron — GMT

[quote="marogiannis"]I have been trying to instll the Advanced Guest Book which came bundled with my hosting, but keep getting various error messages such as:

MySQL Error : Query Error
Error Number: 1146 Table 'annaapts_agbook1.book_config' [b]doesn't exist[/b]
PHP Version : 4.3.9

Can someone kind enough assist me with this.?

Thanks[/quote]

bold = problem.

didn't run sql stuff or install.php

Auron

Carbonize — GMT

Didn't read the manual.

Late Sleeper — GMT

You 2 were not very helpful. I finally figured it out at 5:00 in the morning.
You can not always assume that people know anything about PHP. Or that they want to wade through [u]all[/u] relevant posts.
My host stole the install.php file from my folder. I had to download a new zip file. Then upload the file. I didn't even know how to use it then, but I persevered...finally.
The "manual" was only 4 lines of very cryptic info.
I wonder if you or my host wanted me to succeed.

JTD — GMT

First of all when you install a program from a cpanel. The install file will not be there when you are done. I dont care what host you use. And I am also almost willing to bet that the guestbook it did install was version 2.2. So if it was we will be seeing you back here when your guestbook gets hacked. And BTW the readme file isnt hard no complicated or long. Nor really has anything to do with php. All it does is tell you how to install the program. And if you dont want to wade though all [b]RELEVANT[/b] posts then please dont whine and cry when you need help and someone tells you to please do a search.

Carbonize — GMT

Sounds like the usual crap hosts. They offer a list of scripts they found free as an enticement to get people to sign up and they edit the scripts until they are unrecognisable and in some cases just don't work. the amount of times I've had to fix scripts peoples hosts have provided is unfunny.

Late Sleeper — GMT

Thanks for responding so quickly,
I apologize if my tone seemed harsh. I should probably just skip the Cpanel's installation in the future, and just do it my self.
I am very new to database issues, and didn't even know what a table was (not that I do now). I am almost 40, but feel like a 5 year old kid trying to read my first book. I am thoroughly enjoying my new exposure to this very new world of script implementation. I can't wait for my next challenge.
2.3.1 was installed (it's nice to know that it is not as venerable to hacking, but I did read here about how to fix 2.2).
I posted because the doc/read me file was very hard to understand and use for first timers. I personally think it should be longer, plain, and concise.
Ok, now keep in mind that I am trying to be nice and helpful;
Installation:

1. Open the configuration file 'config.inc.php' with a text editor
and set up your database settings. [color="darkblue"]It already looked fine to me. Everything was right where it should be. So where do I make the settings? [/color]

2. Create the tables for the guestbook:
mysql -u -p < guestbook.sql [color="darkblue"]Now [u]I know[/u] that's hard to understand. How and where do I create these tables? [/color]
Or use the script 'install.php' -> http;//www.yourDomain.com/guestbook/install.php [color="darkblue"]I had to get a new one and place it in the guestbook folder. Without it, I didn't stand a chance. Even then, it took a while to realize that I just had to put the info from the config file in the blanks.[/color]

3. Give write permissions to these directories:

- public - 777 (drwxrwxrwx) (directory) [color="darkblue"]You mean: [code]Cmd: SITE CHMOD 777 public[/code] [/color]
- tmp - 777 (drwxrwxrwx) (directory)

4. The default account is:

Username : test
Password : 123 [color="darkblue"]Without the install.php file running, where do I enter this info?[/color]

If you can provide answers to these questions, why not include this info in the readme.txt (for those of us using Cpanel) Please don't make it an adventure.
I hope this post helps another newbie find their way.
Tony

Carbonize — GMT

the install file will get the details it needs from the config file (admin/config.inc.php). The username and password are to access the Administration area of the guestbook and need to be changed asap.

The reason I get snappy sometimes is because I spend most of my time helping people in varius things and after a while I get pissy at people who ask what simple error messages mean. I had one ask what "mswnsck.ocx not installed or corrupt" meant Your error message is in plain english like most error messages but as it refers to SQL entries I can understand why you didn't know what it meant.

Late Sleeper — GMT

:arrow:[b]Cpanel Users:[/b] It (the install file) didn't get the info it needed by itself. I had to input it myself (after I finallly realized it wanted the databases's password {from config file--> www,myhome.com/guestbook/admin/config.inc.php (LweZE9Kxop)} not my home one). [code] /* database settings */

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

/* tables */
[/code] After uploading the install.php file to the right place (and typing it's name into your browser's address bar and hitting Return), fill in the blanks with the stuff between the "_" (quotes). Each line just as it is. Yes, localhost [u][b]is[/b][/u] the name of your db's host, and that randomly generated password (which you have never seen before) is what you need to enter.
Tony

Carbonize — GMT

[quote="Late Sleeper"] Yes, localhost [u][b]is[/b][/u] the name of your db's host
Tony[/quote]
Is POSSIBLY the location of the mySQL serverand normally is but not always. For most you can leave it as localhost but if that fails contact your host.