Adv Guestbook 2.3.1 install.php round 2

Windows 2000, Apache Ver 2, MySQL 4.0.18, PHP 4.3.4

Run install.php, went well....
10 tables were created in the DB.
Then I clicked on the link:
"Click now here to setup the guestbook admin..."
and I get this error: (What is my next move?)? I see no mention of it in the readme.

MySQL Error : Query Error
Error Number: 1146 Table 'guestbook.book_config' doesn't exist
Date : Sun, March 21, 2004 16:21:30
IP : 127.0.0.1
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Referer : http://localhost/guestbook231/install.php
PHP Version : 4.3.4
OS : WINNT
Server : Apache/2.0.47 (Win32) PHP/4.3.5RC4-dev
Server Name : localhost

Carl

Okay, I got it working. Now if I can import (Load) the data I have from the adv guestbook V1.01 in some meaningful manner.

Carl

I have it all working except for keeping the date field intact when I import the data from the old guestbook..

The adv Guestbook V 1.01 admin function displays the date filed as a 10 digit number in a datype int(10). When I export the data to a csv files, I still have the 10 digit number.

When I import into the adv_guestbook 'book_data' table, the colum is type int(11). The number is retained as it is in the csv file. When the Guestbook is used to see the data, the date is default to

Wednesday, 31. December 1969 19:00
for ALL rows.

How do I handle the date problem?

Carl

How to resolve the date problem...

A. Do not use a CSV or similar file because that requires use of the SQL LOAD command.

Export your data with SQL and use the UPDATE or INSERT command to put the data into the target table.

Carl