UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support sql errors after upgrade to 6.4.2

Hi,
I get these errors, the first when I am logged in the second whne not logged in. This happens withteh search function. UBBthreads 6.4.2 after upgrade.
Thanks in advance.

when I try and edit a user profile, or the users tryy to update profile.:
SQL ERROR: Unable to do_query: UPDATE w3t_Users SET U_ProfileHash='923305122521ca86a53d7902edb1b744' WHERE U_Number='172'
Unknown column 'U_ProfileHash' in 'field list'

When not logged into the system:
Warning: Variable passed to each() is not an array or object in /usr/local/httpd/htdocs/ubbthreads/search.php on line 115

Did you run the 6.4-6.4.1 altertable? That field was added in the 6.4-6.4.1 altertable. When upgrading, you have to run each altertable, in order, to the current version.

Hello,

Thanks for the prompt reply. I did not run the altertable script. What happens if I did not do the altertable 6-3 to 6.4. ?? Do I need to do a reinstall or someething ?

Thanks in advance

hi there:

did you not run any of them? if not, you'll need to upload the upgrading file from the zip, then run 6.3-6.4 and 6.4-6.4.1.