Skip to Content Skip to Menu

debug points to Unknown column 'cp.cb_geburtstag'

  • bherren
  • bherren
  • OFFLINE
  • Posts: 1
  • Thanks: 0
  • Karma: 0
12 years 11 months ago #183412 by bherren
Suddenly, IE will not show entire page. debug gives me this:
500 - JDatabaseMySQL::query: 1054 - Unknown column 'cp.cb_geburtstag' in 'field list' SQL=SELECT cp.user_id, u.username, cp.firstname, cp.lastname, cp.cb_geburtstag, @birthday:=ifnull(date(concat(year(now()), '-', month(cp.cb_geburtstag), '-', DAYOFMONTH(cp.cb_geburtstag))), adddate(date(concat(year(now()), '-', month(cp.cb_geburtstag), '-', DAYOFMONTH(cp.cb_geburtstag)-1)), INTERVAL 1 DAY)) birthday, if(DATEDIFF(@birthday,now())<0,DATEDIFF(adddate(@birthday, INTERVAL 1 YEAR),now()),DATEDIFF(@birthday,now())) days_to_birthday,if(DATEDIFF(@birthday,now())<0, year(now()) - year(cp.cb_geburtstag) +1, year(now()) - year(cp.cb_geburtstag)) age, day(cp.cb_geburtstag) day_of_birthday FROM jos_comprofiler cp, jos_users u where cp.user_id = u.id and cp.cb_geburtstag is not null and cp.cb_geburtstag != date('0000-00-00') and u.block = 0 order by 7 LIMIT 0,5

Any help? Running Joomla 1.5 with CB 1.7.1

www.thelakesatcedargrove.info

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
12 years 11 months ago #183436 by nant

bherren wrote: Suddenly,


Welcome to our forums.

IE will not show entire page. debug gives me this:
500 - JDatabaseMySQL::query: 1054 - Unknown column 'cp.cb_geburtstag' in 'field list' SQL=SELECT cp.user_id, u.username, cp.firstname, cp.lastname, cp.cb_geburtstag, @birthday:=ifnull(date(concat(year(now()), '-', month(cp.cb_geburtstag), '-', DAYOFMONTH(cp.cb_geburtstag))), adddate(date(concat(year(now()), '-', month(cp.cb_geburtstag), '-', DAYOFMONTH(cp.cb_geburtstag)-1)), INTERVAL 1 DAY)) birthday, if(DATEDIFF(@birthday,now())<0,DATEDIFF(adddate(@birthday, INTERVAL 1 YEAR),now()),DATEDIFF(@birthday,now())) days_to_birthday,if(DATEDIFF(@birthday,now())<0, year(now()) - year(cp.cb_geburtstag) +1, year(now()) - year(cp.cb_geburtstag)) age, day(cp.cb_geburtstag) day_of_birthday FROM jos_comprofiler cp, jos_users u where cp.user_id = u.id and cp.cb_geburtstag is not null and cp.cb_geburtstag != date('0000-00-00') and u.block = 0 order by 7 LIMIT 0,5

Any help? Running Joomla 1.5 with CB 1.7.1

www.thelakesatcedargrove.info


The cb_geburtstag field is something that core CB did not create.

Something else you installed (cb plugin?) must be expecting it and it is not present.

Find what extra cb plugin this is and remove it.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum