Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
8 registered (David Dreezer, Island Piper, jacampbe, QSS Tim, Rick, Ruben Rocha, Thelockman, 1 invisible), 37 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 09/18/08
Posts: 9
Top Posters (30 Days)
Ruben Rocha 184
Gizmo 110
Rick 101
Thelockman 83
driv 41
AllenAyres 35
ntdoc 28
Sirdude 27
Ian 24
ScriptKeeper 18
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#197217 - 09/14/07 12: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
#197218 - 09/14/07 03:23 AM Re: Fatal Error After Upgrade [Re: Absinthe]
blaaskaak Offline

****

Registered: 08/30/06
Posts: 1299
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


Shout Box

Today's Birthdays
kimteague_5@msn.com, Trekkie, Trixie
Recent Topics
Inclusion of Locked/Closed thread capabilities
by QSS Tim
12/03/08 11:17 AM
Contact Page Problem
by David DelMonte
12/03/08 09:05 AM
FAQ bug,
by BreeOge
12/03/08 08:36 AM
I'm the Admin but.....
by David DelMonte
12/02/08 11:12 AM
Fatal error: Smarty::require_once
()

by ThreadsUser
12/02/08 08:17 AM
Forum Stats
4261 Members
33 Forums
30538 Topics
155004 Posts

Max Online: 978 @ 06/24/07 08:19 PM