[Ragnarak]

We upgraded from nuke 7.1 to CPG 8.2b we're gettng the error:
Everythign is fine but when clicking on the coppermine module we get:

While executing query "SELECT * FROM nuke_users, nuke_cpg_usergroups WHERE user_group_cp = group_id AND user_id='2' AND user_active_cp = 'YES'" on 0

mySQL error: Unknown column 'user_group_cp' in 'where clause'

When we were testing cpg i remember getting this error and fixing it really easily but now i can't for the life of me remember how i did it and can't seem to find an answer in here, though a few posts do mention the error..

[Śyama_Dāsa]

In phpmyadmin check that all these fields exist in *_users in this order:

Code:

  user_id int(11) unsigned NOT NULL auto_increment,
  name varchar(60) NOT NULL default "",
  username varchar(25) NOT NULL default "",
  user_email varchar(255) NOT NULL default "",
  femail varchar(255) NOT NULL default "",
  user_website varchar(255) NOT NULL default "",
  user_avatar varchar(255) NOT NULL default "",
  user_regdate varchar(20) NOT NULL default "",
  user_icq varchar(15) default NULL,
  user_occ varchar(100) default NULL,
  user_from varchar(100) default NULL,
  user_interests varchar(150) NOT NULL default "",
  user_sig varchar(255) default NULL,
  user_viewemail tinyint(1) NOT NULL default "0",
  user_aim varchar(18) default NULL,
  user_yim varchar(25) default NULL,
  user_msnm varchar(25) default NULL,
  user_password varchar(40) NOT NULL default "",
  storynum tinyint(4) NOT NULL default "10",
  umode varchar(10) NOT NULL default "",
  uorder tinyint(1) NOT NULL default "0",
  thold tinyint(1) NOT NULL default "0",
  noscore tinyint(1) NOT NULL default "0",
  bio tinytext NOT NULL,
  ublockon tinyint(1) NOT NULL default "0",
  ublock tinytext NOT NULL,
  theme varchar(255) NOT NULL default "",
  commentmax int(11) NOT NULL default "4096",
  counter int(11) NOT NULL default "0",
  newsletter int(1) NOT NULL default "0",
  user_posts int(10) NOT NULL default "0",
  user_attachsig int(2) NOT NULL default "1",
  user_rank int(10) NOT NULL default "0",
  user_level int(10) NOT NULL default "1",
  broadcast tinyint(1) NOT NULL default "1",
  user_active tinyint(1) default "1",
  user_session_time int(11) NOT NULL default "0",
  user_session_page smallint(5) NOT NULL default "0",
  user_lastvisit int(11) NOT NULL default "0",
  user_timezone tinyint(4) NOT NULL default "0",
  user_style tinyint(4) default NULL,
  user_lang varchar(255) NOT NULL default "english",
  user_dateformat varchar(14) NOT NULL default "D M d, Y g:i a",
  user_new_privmsg smallint(5) unsigned NOT NULL default "0",
  user_unread_privmsg smallint(5) unsigned NOT NULL default "0",
  user_last_privmsg int(11) NOT NULL default "0",
  user_emailtime int(11) default NULL,
  user_allowhtml tinyint(1) default "1",
  user_allowbbcode tinyint(1) default "1",
  user_allowsmile tinyint(1) default "1",
  user_allowavatar tinyint(1) NOT NULL default "1",
  user_allow_pm tinyint(1) NOT NULL default "1",
  user_allow_viewonline tinyint(1) NOT NULL default "1",
  user_notify tinyint(1) NOT NULL default "0",
  user_notify_pm tinyint(1) NOT NULL default "0",
  user_popup_pm tinyint(1) NOT NULL default "0",
  user_avatar_type tinyint(4) NOT NULL default "3",
  user_sig_bbcode_uid varchar(10) default NULL,
  user_actkey varchar(32) default NULL,
  user_newpasswd varchar(32) default NULL,
  user_group_cp int(11) NOT NULL default "2",
  user_group_list_cp varchar(100) NOT NULL default "2",
  user_active_cp enum("YES","NO") NOT NULL default "YES",

if not add or delete as necessary...