Fatal Error After Upgrade

Print Thread

Hop To

#197217 09/14/2007 3:29 AM

Joined: Oct 2006

Posts: 1

A

Absinthe

stranger

Absinthe

stranger

A

Joined: Oct 2006

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

Re: Fatal Error After Upgrade Absinthe #197218 09/14/2007 6:23 AM
Joined: Aug 2006 Posts: 1,360 Likes: 2 Utrecht, NL Y Yarp Veteran
Yarp Veteran Y Joined: Aug 2006 Posts: 1,360 Likes: 2 Utrecht, 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.

Link Copied to Clipboard

ShoutChat

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Fatal Error After Upgrade