Previous Thread
Next Thread
Print Thread
Hop To
#223153 02/25/2009 11:12 PM
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
Thoughts?

Quote
Script: /var/www/vhosts/clubadventist.org/httpdocs/forum/libs/user.inc.php - Line: 467
SELECT t2.USER_TOPIC_VIEW_TYPE, t2.USER_TOPICS_PER_PAGE, t2.USER_SHOW_AVATARS, t2.USER_POSTS_PER_TOPIC, t2.USER_TIME_OFFSET,t2.USER_SHOW_SIGNATURES,t2.USER_TIME_FORMAT,t2.USER_IGNORE_LIST,t2.USER_SHOW_AVATARS,t2.USER_POST_LAYOUT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF,t2.USER_GROUP_IMAGES,t2.USER_TIME_FORMAT
FROM ubbt_USERS as t1,
ubbt_USER_PROFILE as t2
WHERE t1.USER_ID = ''
AND t1.USER_ID = t2.USER_ID
- Unknown column 't2.USER_GROUP_IMAGES' in 'field list'


http://clubadventist.com/forums

No longer following the carrot
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
sounds like your ubbt_USER_PROFILE table is missing the USER_GROUP_IMAGES field..

you can run this to add the field(s) required.. i'm assuming the other one got missed too..

SQL Query
alter table ubbt_USER_PROFILE
add USER_GROUP_IMAGES varchar(255)

and
SQL Query
alter table ubbt_USER_PROFILE
add USER_NOTIFY_MULTI tinyint(1) unsigned not null default '0'

in your admin cpanel Database tools smile


Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869

Should i expect to see this?
Quote
Script: /var/www/vhosts/clubadventist.org/httpdocs/forum/admin/dodbcommand.php
Line#: 101
SQL Error: Duplicate column name 'USER_GROUP_IMAGES'
SQL Error #: 1060
Query: alter table ubbt_USER_PROFILE add USER_GROUP_IMAGES varchar(255)


http://clubadventist.com/forums

No longer following the carrot
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
no.. then the initial error doesn't make sense. it was saying that column didn't exist..

t1.USER_ID='' is suspicious.. USER_ID is a key column and would never be null..

something else is going on with your board..


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
Who's Online Now
0 members (), 850 guests, and 177 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)