Previous Thread
Next Thread
Print Thread
Hop To
Joined: Aug 2006
Posts: 96
Likes: 1
G
Journeyman
Journeyman
G Offline
Joined: Aug 2006
Posts: 96
Likes: 1
I receive the following error when I try to the following: My Stuff >My Preferences:

We cannot proceed.
Script: /usr2/home/oakmediacreations.com/htdocs/ubb/scripts/editdisplay.inc.php
Line#: 71
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.


I assume this may be a local issue with my database and may not be a bug as I do not receive the error message here. When I upgraded from the beta, all checked out ok.

Last edited by Rick; 10/16/2006 4:23 PM.

I am a Superstar! Testing signature here
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It sounds like during the upgrade process the database didn't get altered. Did you run through the upgrade script? It seems there was a bug in this for some people and it stopped at the languages. You can fix this by running this sql command:

alter table ubbt_USER_PROFILE add USER_EMAIL_WATCHLISTS tinyint(1) not null default '0'

Joined: Aug 2006
Posts: 96
Likes: 1
G
Journeyman
Journeyman
G Offline
Joined: Aug 2006
Posts: 96
Likes: 1
That did it. Thanks!


I am a Superstar! Testing signature here

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)