|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
Thoughts? 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'
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
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.. alter table ubbt_USER_PROFILE
add USER_GROUP_IMAGES varchar(255) and alter table ubbt_USER_PROFILE
add USER_NOTIFY_MULTI tinyint(1) unsigned not null default '0' in your admin cpanel Database tools
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
Should i expect to see this? 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)
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
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..
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
0 members (),
850
guests, and
177
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|