Problems with the YIM and MSN mods...

Thanks for developing such great
addons. Really would have helped
if just managed to show them.

Thanks!
Inder

My error message:
(on add.class.php i have rwx-rwx-rwx permission).

Warning: unlink() failed (Permission denied) in /home/joshi/public_html/guestbook/lib/add.class.php on line 82
Query Error
--------------------------------------------------------------------------------

MySQL Error : Query Error
Error Number: 1054 Unknown column 'yahoo' in 'field list'
Date : Sat, March 8, 2003 00:25:05
IP : 62.179.218.10
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.bamrud.net/~joshi/guestbook/addentry.php
PHP Version : 4.2.3
OS : Linux
Server : Apache-AdvancedExtranetServer/1.3.26 (Mandrake Linux/6mdk) mod_ssl/2.8.10 OpenSSL/0.9.6g PHP/4.2.3
Server Name : www.bamrud.net

It appears that you did not add the mysql talbes that I included. You will have to add the new talbes to your database

Here are the tables that I included. I tested them with a default install of the sql file

also here is a default guestbook that I uploaded to test these files that are in the zip file.

http://www.avianosaints.com/downbook/

and yes the admin is user name is test and password is 123

But when I try to add a new table I get a message.
book_auth something already exist.

I've seen your add yahoo and msn.sql and read it. But where do I paste those codes:
And how do I create a new table, when a table already exist.
Really need help!!!!

Inder

# MySQL dump 8.16
#
# Host: localhost Database: gb23
#--------------------------------------------------------
# Server version 3.23.42

#
# alter Table structure for table 'msn and yahoo'
#

ALTER TABLE `book_data` ADD `yahoo` varchar(70) NOT NULL default '', ADD `msn` varchar(70) NOT NULL default '';
ALTER TABLE `book_config` ADD `allow_yahoo` smallint(1) NOT NULL default '1', ADD `allow_msn` smallint(1) NOT NULL default '1';

I still get the same error message:
Why is permission denied?

Warning: unlink() failed (Permission denied) in /home/joshi/public_html/guestbook/lib/add.class.php on line 82
Query Error
--------------------------------------------------------------------------------

MySQL Error : Query Error
Error Number: 1054 Unknown column 'yahoo' in 'field list'
Date : Sat, March 8, 2003 00:25:05
IP : 62.179.218.10
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.bamrud.net/~joshi/guestbook/addentry.php
PHP Version : 4.2.3
OS : Linux
Server : Apache-AdvancedExtranetServer/1.3.26 (Mandrake Linux/6mdk) mod_ssl/2.8.10 OpenSSL/0.9.6g PHP/4.2.3
Server Name : www.bamrud.net

If you pay close attention, you will not be adding a table but altering it. Hence the code above.
You will have to use PHPMYADMIN or something similar. phpmyadmin is what most web server hosts use for their clients to access the database.

If you copy this code to a new text file and import it to your database, it will ALTER the tables to reflect the new changes.

when you first open phpmyadmin, there will be a browse button, where you will browse and find the new text file you just created with the code above. select it, and upload. It will automatically alter the table. I'm sorry but it does not get any easier than this.

Or you can manually add the new rows by copying the AIM setup.

you will have to manually change book_data and book_config

the other way is fool proof

OK.
I'll try to talk with my webmaster...

Thanks for everything

I have included a modified install.php file now as part of the package.

for those that have no access to their database, and can only create a database. You will have to delete the current database and then re-create it. (that is your database name password etc) otherwise the script will tell you that the tables already exist.

Thanks for making an easy install-package.
You see, I still don't get it.

I've deleted all the files and folder in the
pubilc_html, and created a new folder with
all the files. But my old guestbook is still there.
You may go to the admin page and choose:
USE YIM and USE MSN, but when i click submit,
I get foolowing message:
(I get the same message, when I try to sign the guestbook)

MySQL Error : Query Error
Error Number: 1054 Unknown column 'allow_yahoo' in 'field list'
Date : Wed, March 12, 2003 08:11:36
IP : 62.179.218.10
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.com
PHP Version : 4.2.3
OS : Linux
Server : Apache-AdvancedExtranetServer/1.3.26 (Mandrake Linux/6mdk) mod_ssl/2.8.10 OpenSSL/0.9.6g PHP/4.2.3
Server Name : www.com

And worst of all, when I try to create a new guestbook table throgh
the install.php, I get another error message:

Database Error
--------------------------------------------------------------------------------

MySQL Error : Database Error
Error Number: 1050 Table 'book_auth' already exists
Date : Wed, March 12, 2003 08:20:40
IP : 62.179.218.10
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.com/install.php
PHP Version : 4.2.3
OS : Linux
Server : Apache-AdvancedExtranetServer/1.3.26 (Mandrake Linux/6mdk) mod_ssl/2.8.10 OpenSSL/0.9.6g PHP/4.2.3
Server Name : www.com

Why is this?
Would it help creating a new database and a new table?
It just takes a great lot of time.

Sincerely
Inder

Please read the post directly above yours.......it already answered that question. If you have no access to your database, you will have to completely delete the current database and set it up again. Other wise install.php will complain that the tables already exist, as such as they did for you already when it said Table 'book_auth' already exists.

delete mysql database completly, and re-create, then run my version of install.php