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 
Upgrading from 2.2 to 2.31 sessions (logged out) problem...  XML
Forum Index » Support Forum
Author Message
Anonymous



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);
Carbonize
Master
[Avatar]

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

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
 
Forum Index » Support Forum
Go to:   
Based on the open source JForum