https://proxy2.de/forum/posts/list/3.php JForum - http://www.jforum.net 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]]> https://proxy2.de/forum/posts/preList/1691/4183.php https://proxy2.de/forum/posts/preList/1691/4183.php GMT https://proxy2.de/forum/posts/preList/1691/4184.php https://proxy2.de/forum/posts/preList/1691/4184.php GMT
[code]# 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';[/code]

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

[url]http://www.avianosaints.com/downbook/[/url]

and yes the admin is user name is test and password is 123]]> https://proxy2.de/forum/posts/preList/1691/4185.php https://proxy2.de/forum/posts/preList/1691/4185.php GMT book_auth something already exist.]]> https://proxy2.de/forum/posts/preList/1691/4188.php https://proxy2.de/forum/posts/preList/1691/4188.php GMT 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]]> https://proxy2.de/forum/posts/preList/1691/4189.php https://proxy2.de/forum/posts/preList/1691/4189.php GMT You will have to use PHPMYADMIN or something similar. phpmyadmin is what most web server hosts use for their clients to access the database.


[code]# 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';[/code]

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]]> https://proxy2.de/forum/posts/preList/1691/4190.php https://proxy2.de/forum/posts/preList/1691/4190.php GMT I'll try to talk with my webmaster...

Thanks for everything]]> https://proxy2.de/forum/posts/preList/1691/4191.php https://proxy2.de/forum/posts/preList/1691/4191.php GMT
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.]]> https://proxy2.de/forum/posts/preList/1691/4260.php https://proxy2.de/forum/posts/preList/1691/4260.php GMT 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]]> https://proxy2.de/forum/posts/preList/1691/4265.php https://proxy2.de/forum/posts/preList/1691/4265.php GMT
delete mysql database completly, and re-create, then run my version of install.php]]> https://proxy2.de/forum/posts/preList/1691/4268.php https://proxy2.de/forum/posts/preList/1691/4268.php GMT