If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Advanced GuestBook 2.2 Weird problem...  XML
Forum Index » Support Forum
Author Message
Anonymous



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

Joined: 25/12/2003 06:49:24
Messages: 41
Offline

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!
Anonymous



yes, a more helpful explanation?
 
Forum Index » Support Forum
Go to:   
Based on the open source JForum