Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (isaac, whk), 53 guests, and 386 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
whk
whk
Portsmouth, RI
Posts: 90
Joined: January 2009
Show All Member Profiles 
Top Posters(30 Days)
isaac 47
Gizmo 31
Ruben 10
Morgan 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 01:54 AM
10/16/06 01: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 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: 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
PHP 7.0
by Jake. 02/20/18 01:20 PM
Anyway to Reset a Members password in ControlPanel
by peter gariepy. 02/16/18 12:11 AM
My forums will not send emails
by peter gariepy. 02/16/18 12:08 AM
error when trying to email everyone
by . 02/11/18 06:02 AM
Forum Statistics
Forums36
Topics35,077
Posts190,978
Members12,058
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1.1