UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Problem with upgrade

Our forums have been upgraded from 6.2.3 to 6.5.1.1 but it appears one or more of the altertable scripts hasn't run properly. The forum is up but when you try and post or edit a user or search we get errors about missing fields and tables in the database. Can I just re-run the altertable scripts or do I need to fix each error individually using SQL commands?

Cheeers for any help.

Rob

Hello Rob,

Can you be more specific as to the exact nature of the error? What fields are being complained about?

Hi charles

When we try and edit a users profile we get the following error

-------------------------------------------------------------------
Script: D:\wwwroot\www_fishingwarehouse_co_uk\ubbthreads\admin\showuser.php
Line#: 67
SQL Error: Unknown column 'U_FloodControl' in 'field list'
SQL Error #: 1054
Query: SELECT (field list truncated to fix page) FROM w3t_Users WHERE U_Number='3569'
---------------------------------------------------------------------

When we try and search for anything we get the following error

-----------------------------------------------------------------
Script: D:\wwwroot\www_fishingwarehouse_co_uk\ubbthreads\dosearch.php
Line#: 263
SQL Error: Table 'fw_ubb.w3t_searchresults' doesn't exist
SQL Error #: 1146
Query: DELETE FROM w3t_SearchResults WHERE S_Session='2765ec260c3db414e214d1fb80a9f449' OR S_SearchTime < 1122368752
---------------------------------------------------------------

We also get an error when we try to post but at the moment we've got a maximum thread execution time out error due to sessions not working properly. Our host is trying to fix this but I'm sure the missing fields/tables is another problem.

I've also fixed a couple of errors already and it seems to be the altertable-6.5.php script that hasn't completed properly although I can't find where it creates the searchresults table.

I wondered if I could just re-run this script or not?

Cheers

Rob

You shouldn't be running that particular altertable script on your own - it's meant to be run by the upgrade scripts. Did the upgrade scripts complete the entire process, including updating your language files, etc? Were there any errors in that process?