Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (JAISP), 42 guests, and 416 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Pilgrim
Pilgrim
NH, USA
Posts: 235
Joined: December 2003
Show All Member Profiles 
Top Posters(30 Days)
isaac 44
Gizmo 34
Ruben 13
Morgan 8
Geoff 6
Latest Photos
Test
BSA photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
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 Online content OP
journeyman
Geoff  Online Content 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 Online content OP
journeyman
Geoff  Online Content OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
That did it. Thanks!


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
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
imageMagick test
by Morgan. 02/10/18 09:03 AM
Forum Statistics
Forums36
Topics35,074
Posts190,962
Members12,058
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1.1