Script: F:\xampp\htdocs\forum\scripts\editdisplay.inc.php
Line#: 72
SQL Error: Unknown column 't2.USER_EMAIL_WATCHLISTS' in 'field list'
SQL Error #: 1054
Query: SELECT t1.USER_DISPLAY_NAME,t2.USER_START_VIEW,t2.USER_FAVORITES_TAB,t2.USER_FAVORITES_SORT,t2.USER_TOPIC_VIEW_TYPE, t2.USER_TOPICS_PER_PAGE,t2.USER_POSTS_PER_TOPIC,t2.USER_SHOW_AVATARS,t2.USER_SHOW_SIGNATURES,t2.USER_NOTIFY_ON_PM, t2.USER_ACCEPT_PM,t2.USER_TIME_OFFSET,t2.USER_TIME_FORMAT,t2.USER_VISIBLE_ONLINE_STATUS,t2.USER_UNAPPROVED_POST_NOTIFY, t2.USER_TEXT_EDITOR,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN,t2.USER_STYLE,t2.USER_EMAIL_WATCHLISTS FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID = 2 and t1.USER_ID = t2.USER_ID

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

Script: F:\xampp\htdocs\forum\scripts\changedisplay.inc.php
Line#: 139
SQL Error: Unknown column 'USER_EMAIL_WATCHLISTS' in 'field list'
SQL Error #: 1054
Query: UPDATE ubbt_USER_PROFILE SET USER_START_VIEW = 'cfrm', USER_FAVORITES_TAB = 'forums', USER_FAVORITES_SORT = 'reply', USER_TOPIC_VIEW_TYPE = 'flat', USER_SHOW_AVATARS = 1, USER_NOTIFY_ON_PM = 'yes', USER_POSTS_PER_TOPIC = 15, USER_TOPICS_PER_PAGE = 30, USER_ACCEPT_PM = 'yes', USER_TIME_FORMAT = 'd.m.Y | H:i', USER_TIME_OFFSET = 0, USER_VISIBLE_ONLINE_STATUS = 'yes', USER_SHOW_SIGNATURES = 'yes', USER_STYLE = 0, USER_UNAPPROVED_POST_NOTIFY = 0 , USER_HIDE_LEFT_COLUMN = 0 , USER_HIDE_RIGHT_COLUMN = 0 , USER_EMAIL_WATCHLISTS = '' WHERE USER_ID = 2

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

What where you doing when these errors occoured?

In My Stuff > My Preferences > Edit display preferences...

Did you run the upgrade script completely? That was a new field that was added during the database alteration step.

No, I have used the old data bank (b4).

Ok, If you run through the upgrade script it will add the new db field.

Yes everything very well, Rick. Thank you

I have a same problem, and I did run my upgrade throught the upgrade script, but did not notice at which stage did suppouse to add the new DB field. Can somebody give me more info. Thank you.

The database is upgraded on the very last step, after the language files are upgraded/checked. It will tell you what fields it's adding and that it's finalizing the upgrade to 7.0.0b5.

For some reason when I upgraded it stopes on langugage upgrade.

I have done the field by hand in addition.

I still do not fill 100% comfortable playing with manual field addition and for that reason I left that option as a last resort. Do you mind giving me a few guidlines on manual field upgrade?

In the table USER_PROFILE this field
USER_EMAIL_WATCHLISTS tinyint(1) not null default '0'
add to
USER_ACCEPT_PM varchar(3) default 'yes'.

Thank you, it works now but I still do not know why the import script did not take care of entering a new db field? Well at list there is always (almost) more then one way to fix a "problem". Thank you once again.

Well it works, almost. At list now I am able to open MY PREFERENCES without displaying an error about mising DB field.
But now my new DB field is not responding. Firstly there is no default value in my form under MY PREFERENCES, and even when I select YES value it is not registering. Same happens if I install B5 using a brand new DATA BASE. Any ideas?

That looks like a legitimate bug as it's happening here as well. Need to get that fixed up.