Found a lot of posts regarding this problem so I thought I'd write what worked for me which I found in this form. From phpmyadmin select the guestbook database. Then on the right press on the SQL tab. Enter the code below in the text box and press go. Worked for me.
ALTER TABLE `book_auth` CHANGE `LAST_VISIT` `last_visit` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `book_data` DROP `image`;
ALTER TABLE `book_private` DROP `image`;
ALTER TABLE `book_smilies` CHANGE `width` `width` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `book_smilies` CHANGE `height` `height` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `book_ip` ADD KEY guest_ip (guest_ip);
13/08/2004 16:43:35
Subject:
Carbonize
Master
Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
I wrote a script for upgrading from 2.2 to 2.3.1 but I haven't had chance to test it. If it doesn't work I will just take the 2.3.1 install file and integrate your code. Still need testers though as my servers being funny
Carbonize I am not the maker of the Advanced Guestbook