Advanced GuestBook 2.2 Weird problem...

Make sure you run the sql comamnds in

/doc/db_update_v22-23.sql

to update your sql database.

This will not upgrade the tables in all cases. You must then run

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);

Em... I didn't get a word of that.

Can someone clarify this with step-by-step instructions for those of us who aren't SQL savvy?

Thanks!

yes, a more helpful explanation?