UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support 6.2.2 > 6.5 Upgrade problems

Hi,

I have been trying to upgrade one of our forums from 6.2.2 > 6.5 and ran into a number of problems.I ran the upgrade as per the instructions on UPGRADING.html in the following order:
altertable-6.2-6.3.php
updated the the 6.3 topics and replies
altertable-6.3-6.4.php
altertable-6.4-6.4.1.php
proceeded to upgrade.php and ran through all the steps.
I encounted a problem when it came time for it to create the table
w3t_ContentIslands , so I manually created this table. At no point did any of the altertable scripts timeout on me.

After this, I proceeded to the main page for the forum and it gave me an error regarding a missing column, one of them being U_OC_Userid, so I manually added the missing columns.

After all this, the forum loaded up, I clicked on the Login link, entered the Administrator UN/PW and was logged in. When I went to click on any of the links such as Control Panel, I would be taken to a page stating I did not have permssion to access this area or needed to be logged in. It would keep logging me off each time I clicked any of the links. It would also not always list me as being logged in. I have tried this on 3 different computers, wiped out all cookies and such and still cannot login.

I decided to try going to 6.5.1b5 and still have the same problem. Any advice would be appreciated.

Thanks,
Chuck

just a side note here, I went and did a completely fresh install, new database and used the 6.5.1b5 files. The install went fine until it came time to create all the tables. It would not create the table w3t_ContentIslands, so I ended up creating it manually. It gave an error message about something like "undefined value for C". Sorry for being vague on this one, but was the same message I received when doing the upgrade.

Both the fresh install and the upgrade did not create the table w3t_SearchResults . I also noticed when doing a dump of the original database, that it is 249MB, while the dump of this same database after the upgrade process is only 184MB. Is this normal? Just not sure if I can trust the upgraded database.

Thanks,
Chuck

Maybe this should be in the beta forum bugs section? I have the same problem with both the current release and the beta b5 release.

I just went now on a completely different machine, ran the upgrade without any apparent problems. When I went to login, I did receive some errors about missing columns, so I ended up doing the folllowing manually:
mysql> ALTER TABLE w3t_Users
-> ADD U_ShowBday INT(1) NOT NULL DEFAULT '0',
-> ADD U_TimeFormat VARCHAR(6),
-> ADD U_Ignored TEXT,
-> ADD U_OC_Userid VARCHAR(64);

Now, I appear to have a fully upgraded database, approximately the same size as the original. In the other upgrade, all sticky posts were lost and not sure what else at the moment.

The big problem is still the login/getting logged out at random. This is happening on 2 different machines. Cookies, cache, etc. were all cleared out and this problem still exists. <img src="https://www.ubbcentral.com/boards/images/graemlins/frown.gif" alt="" />

Thanks,
Chuck

if you run b4 or b5 make sure you have the session directory set up and the propper rights settings to it. In this beta version UBBt use a combination of sessions and cookies to track user. This works, but have a bug in it. I wrote a report about this in the beta forum. The session time is to short and if you dont logout/login the system recognize all settings if you enter again after closing/open a browser.

i believe i have sorted the login/logout problem. for some reason the upgrade process was wiping out the data for cookiepath and cookieexp .
Now I just need to figure out why the whole upgrade process would not create all the new tables or columns and decided to try and wipeout a good chunk of my database.
Thanks,
Chuck

I had simililar problems like yours, but my upgrade scripts timeouted, so I had to run them from console. So, try run them on the console, if you can. The last upgdrade step, must be done using the /install/upgrade.php script.. which timeouted for me, but I guess it checks where it last left and you can safely re-run it. It is important to complete this one. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

The login problems can be solved if you change your password. The encrypted password format that the admin accepts is now different than the old one (pre 6.2.2.)