advanced guestbook help

Query Error
--------------------------------------------------------------------------------

MySQL Error : Query Error
Error Number: 1146 Table 'b2l0747_agbook1.book_pics' doesn't exist
Date : Sun, February 1, 2004 08:33:02
IP : 213.224.83.166
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)
Referer :
PHP Version : 4.3.3
OS : Linux
Server : Apache/1.3.29 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2634 PHP-CGI/0.1b
Server Name : www.killerqueen.buildtolearn.net

this is what i get after i uploaded the guestbook... anybody who knows what i should do???

Have you checked database name, password etc. in admin/config.inc.php ?

yes i did
now i uploaded it again and now i get

You can't access this file directly...

it's really strange... you can check it out http://killerqueen.buildtolearn.net.guestbook

Sound like your table book_pics is missing (doesn't exist). Check your database, it should be 10 tables. Here are mine:
book_auth
book_ban
book_com
book_config
book_data
book_ip
book_pics
book_private
book_smilies
book_words

1. If you miss it, make a manual table. For book_pics, see install.php, make a table with parameter like this:
msg_id int(11) NOT NULL default '0',
book_id int(11) NOT NULL default '0',
p_filename varchar(100) NOT NULL default '',
p_size int(11) unsigned NOT NULL default '0',
width int(11) unsigned NOT NULL default '0',
height int(11) unsigned NOT NULL default '0',

2. If it doesn't work, it seems an installation problem. Common solution is to reinstall, as follows : a) delete all tables (backup first if you have data) [you do not need to delete database] b) execute install.php [db name, password should match config.inc.php]

3. If it still doesn't work, sometimes there is a problem during file uploading (file missing, not upload appropriately). Re-upload the latest version, delete the existing tables, install.