Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (driv), 35 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/22/06
Posts: 163
Top Posters (30 Days)
Ruben 51
DennyP 24
Gizmo 24
Dunny 15
SteveS 14
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#197217 - 09/14/07 03:29 AM Fatal Error After Upgrade
Absinthe Offline
stranger
Registered: 10/05/06
Posts: 1
After uploading all of the changed files from a 7.1.1 version to 7.2 and running the upgrade.php script, I've encountered the following error:


 Code:
We encountered a problem. The reason reported was

Script: /var/www/vhosts/domain.com/httpdocs/dir/libs/ubbthreads.inc.php
Line#: 2231
SQL Error: Unknown column 't1.USER_RULES_ACCEPTED' in 'field list'
SQL Error #: 1054
Query: select t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT,t1.USER_DISPLAY_NAME,t1.USER_PASSWORD,t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t2.USER_TOTAL_PM, t1.USER_ID, t1.USER_IS_BANNED,t1.USER_IS_UNDERAGE, t2.USER_STYLE,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN,t2.USER_LANGUAGE,t2.USER_MOOD,t2.USER_RELATIVE_TIME,t1.USER_RULES_ACCEPTED from ubbt_USERS AS t1, ubbt_USER_PROFILE as t2 where t1.USER_ID = '2' and t1.USER_ID = t2.USER_ID



Please click back to return to the previous page.

Any idea what happened? Thanks.

- Absinthe
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."
#197218 - 09/14/07 06:23 AM Re: Fatal Error After Upgrade [Re: Absinthe]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
The USER_RULES_ACCEPTED is a new column for ubb 7.2. Maybe something went wrong in the upgrade that it was not created.

Try this one:

 Code:
ALTER TABLE `ubbt_USERS` ADD `USER_RULES_ACCEPTED` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'


This will add the new column.
_________________________
Top



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

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10491 Members
36 Forums
33842 Topics
181709 Posts

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