Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (isaac), 68 guests, and 351 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 585
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Morgan 13
Gizmo 12
isaac 11
Ruben 10
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
[NOTABUG] My Preferences Error Message #166266
10/16/06 02:54 AM
10/16/06 02:54 AM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
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/06 04:23 PM.
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: My Preferences Error Message [Re: Geoff] #166292
10/16/06 10:59 AM
10/16/06 10:59 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
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'

Re: My Preferences Error Message [Re: Rick] #166361
10/16/06 07:25 PM
10/16/06 07:25 PM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
That did it. Thanks!


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
https http
by sundance. 05/22/18 05:46 PM
Want to Delete All Old Private Messages
by BellaOnline. 05/19/18 02:00 AM
How to remove Shout Chat
by Outdoorking. 05/17/18 08:37 AM
I am trying to put a banner ad on email template.
by sundance. 05/14/18 01:59 PM
Pruning Members Best Practices
by Shawn Grim. 05/10/18 05:36 PM
Forum Statistics
Forums36
Topics35,114
Posts191,269
Members12,075
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)