ok
I uploaded a fresh copy ubbthreads 6.5.5
I'v run a few of the alt table scripts

on the upgrade.php I get the following error
The following files do not exist in your install
(Make sure these are uploaded)templates/default/ubbt_instant_ubbcode.tmpl


The following files are reporting a wrong version #
(Make sure you updated these files)All files report proper version #.

The following files need to be removedAll files tagged for removal have been removed.

the file is there as it's a fresh copy
just trying to get my database updated so I can move on to 7.2.2
any idea's here

never mind got it to work

We cannot proceed.
Script: /home/boneyard/public_html/forum2/ubbt.inc.php
Line#: 1608
SQL Error: Unknown column 'U_OC_Userid' in 'field list'
SQL Error #: 1054
Query: SELECT U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned,U_LastOn,U_OC_Userid FROM w3t_Users WHERE U_Number = ''

Please use your back button to return to the previous page.

ok finished the upgrade but I get this error
now whats wrong

It looks like you missed a step perhaps. The U_OC_Userid field was added in the altertable-6-3-6.4.php script. Did this one get run? And if so, did it return any errors?

I ran that one & it was fine
can I do it all over again or do I have to start over with another fresh 6.3 db ?

here I ran it again to see
Adding a new table to save database queries that are used frequently from the admin section
Adding a new field to the Groups table to allow for disabling of groups.
Grabbing all old poll data for conversion.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boneyard/public_html/forum2/mysql.inc.php on line 140

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boneyard/public_html/forum2/mysql.inc.php on line 140
Dropping old poll tables and creating new ones for the updated poll system.
importing old poll data...
Adding a table for calendar events...
Altering the user's table to add a few new fields/preferences...
Altering the online table to store info a bit differently...
Altering the board's table to allow admin's to associate an image with a forum...
Altering the posts table so posts can be linked to a calendar event...
Reworking some indexes for speed, this may take awhile. You will get a few errors about indexes not being able to be dropped. This is ok, index names might be a bit different depending on when you installed but they will be dropped properly...
Creating a cache table for some things that don't change to often...
Creating a table to store version info to make future upgrades easier...
Done

same result still getting the same SQL Error: Unknown column 'U_OC_Userid' in 'field list'

ok lloks like alt table 6.3-6.4 did not add these lines
well thats what I'v found so far
board is up & running after adding these lines
now to check to see if anything else got left out

ALTER TABLE w3t_Users
ADD U_Birthday VARCHAR(10) NOT NULL DEFAULT '0',
ADD U_ShowBday INT(1) NOT NULL DEFAULT '0',
ADD U_TimeFormat VARCHAR(6),
ADD U_Ignored TEXT,
ADD U_OC_Userid VARCHAR(64),
ADD INDEX birthday_ndx (U_Birthday,U_ShowBday)