|
Joined: Aug 2006
Posts: 26
newbie
|
newbie
Joined: Aug 2006
Posts: 26 |
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.
Last edited by Rick; 09/12/2006 3:07 PM.
|
|
|
|
Joined: Aug 2006
Posts: 26
newbie
|
newbie
Joined: Aug 2006
Posts: 26 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
What where you doing when these errors occoured?
|
|
|
|
Joined: Aug 2006
Posts: 26
newbie
|
newbie
Joined: Aug 2006
Posts: 26 |
In My Stuff > My Preferences > Edit display preferences...
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Did you run the upgrade script completely? That was a new field that was added during the database alteration step.
|
|
|
|
Joined: Aug 2006
Posts: 26
newbie
|
newbie
Joined: Aug 2006
Posts: 26 |
No, I have used the old data bank (b4).
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, If you run through the upgrade script it will add the new db field.
|
|
|
|
Joined: Aug 2006
Posts: 26
newbie
|
newbie
Joined: Aug 2006
Posts: 26 |
Yes everything very well, Rick. Thank you
|
|
|
|
Joined: Jul 2006
Posts: 47
journeyman
|
journeyman
Joined: Jul 2006
Posts: 47 |
Ok, If you run through the upgrade script it will add the new db field. 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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Jul 2006
Posts: 47
journeyman
|
journeyman
Joined: Jul 2006
Posts: 47 |
For some reason when I upgraded it stopes on langugage upgrade.
|
|
|
|
Joined: Aug 2006
Posts: 26
newbie
|
newbie
Joined: Aug 2006
Posts: 26 |
I have done the field by hand in addition.
|
|
|
|
Joined: Jul 2006
Posts: 47
journeyman
|
journeyman
Joined: Jul 2006
Posts: 47 |
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?
|
|
|
|
Joined: Aug 2006
Posts: 26
newbie
|
newbie
Joined: Aug 2006
Posts: 26 |
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'.
|
|
|
|
Joined: Jul 2006
Posts: 47
journeyman
|
journeyman
Joined: Jul 2006
Posts: 47 |
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.
|
|
|
|
Joined: Jul 2006
Posts: 47
journeyman
|
journeyman
Joined: Jul 2006
Posts: 47 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
That looks like a legitimate bug as it's happening here as well. Need to get that fixed up.
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
0 members (),
1,009
guests, and
174
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|