Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (M4TT, JAISP, mmkk), 61 guests, and 262 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 25
Joined: November 2012
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
M4TT 11
FREAK 11
mmkk 5
Ruben 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
[NOTABUG] My Preferences Error Message #166266
10/16/06 01:54 AM
10/16/06 01:54 AM
Joined: Aug 2006
Posts: 51
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 51
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 03: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 09:59 AM
10/16/06 09: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 06:25 PM
10/16/06 06:25 PM
Joined: Aug 2006
Posts: 51
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 51
Florida
That did it. Thanks!


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,534
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)