Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (SteveS), 29 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 105
Top Posters (30 Days)
Ruben 49
Gizmo 24
DennyP 24
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#170287 - 12/14/06 07:54 PM Oops ... problem with upgrade ...
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
I just upgraded my test site from beta to 7.02 (yeah, I'm behind times! :p), and when I went into my preferences, this is the error message I received ...

Quote:
Script: /home/adwoff/forums/scripts/editdisplay.inc.php
Line#: 68
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_72006USERS as t1, ubbt_72006USER_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.


Soooooooooo ... those who know a hell of a lot more than I do, HOW DO I FIX IT?! LOL

Thanks.

~Sue
adwoff.com
Top
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."
#170311 - 12/15/06 03:26 AM Re: Oops ... problem with upgrade ... [Re: ADWOFF]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Did you run upgrade.php from the install directory?

And I'm still at 7.0 ;)...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#170315 - 12/15/06 04:12 AM Re: Oops ... problem with upgrade ... [Re: Gizmo]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
Originally Posted By: Gizmo
Did you run upgrade.php from the install directory?


I thought I did!

Hmmm ... can I do a do-over without the system screaming at me?!

~Sue
adwoff.com
Top
#170319 - 12/15/06 07:16 AM Re: Oops ... problem with upgrade ... [Re: ADWOFF]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Yup, it'll just give you an error if you've already run it ;\)


Edited by Gizmo (12/15/06 07:16 AM)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#170323 - 12/15/06 08:01 AM Re: Oops ... problem with upgrade ... [Re: Gizmo]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
Originally Posted By: Gizmo
Yup, it'll just give you an error if you've already run it ;\)


I dunno, Giz.

This what the computer told me:

Quote:
This upgrade has been completed. Please remove the entire install directory


And I did do the upgrade from the install directory ... so now what? LOL

~Sue
adwoff.com

ETA: It's just giving me grief (for now) when I'm trying to get into "My Preferences."


Edited by ADWOFF (12/15/06 08:03 AM)
Top
#170332 - 12/15/06 10:57 AM Re: Oops ... problem with upgrade ... [Re: ADWOFF]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
That field was added waaaaaaay back in the early beta releases. You'll probably need to manually add it with the following SQL command:

alter table ubbt_72006USER_PROFILE add USER_EMAIL_WATCHLISTS tinyint(1) not null default '0'
Top
#170335 - 12/15/06 11:43 AM Re: Oops ... problem with upgrade ... [Re: Rick]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
Originally Posted By: Rick
That field was added waaaaaaay back in the early beta releases. You'll probably need to manually add it with the following SQL command:

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


All-righty, Rick, I shall try to do this (when I get up--gotta go to sleep because I work the graveyard tonight) ... but I have a very stooooooopid question for you ... where do I add that command and HOW do I add it?!

This stuff is ALL new for me!

Be gentle!

Thanks.

~Sue
adwoff.com
Top
#170336 - 12/15/06 11:52 AM Re: Oops ... problem with upgrade ... [Re: ADWOFF]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Control Panel -> DB Tools -> SQL Command tab

Just paste it into the box ;\)
Top
#170347 - 12/15/06 05:50 PM Re: Oops ... problem with upgrade ... [Re: ADWOFF]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Originally Posted By: ADWOFF
Be gentle!
you've got to love the suzie ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
Yesterday at 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33840 Topics
181693 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image