News:

Create A Forum Installed

Author Topic: getting Database Error !!  (Read 603 times)

0 Members and 1 Guest are viewing this topic.

Offline Thelegend

  • Newbie
  • *
  • Posts: 5
  • Karma: 1
    • View Profile

Badges: (View All)
Level 2 Windows User Topic Starter
getting Database Error !!
« on: May 19, 2012, 05:15:48 pm »
hi everyone,today i created a forum called
  league of legends

but at homepage and other some pages i was getting Database Error!!


Quote
Unknown column 'b.catimage' in 'field list'
File: C:\Inetpub\createaforum\Sources\Subs-BoardIndex.php
Line: 72



 SELECT
 c.id_cat, c.name AS cat_name,
 b.id_board, b.name AS board_name, b.description, b.catimage,
 CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,
 b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,
 IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name,
 m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name,
 1 AS is_read, 0 AS new_from,
 IFNULL(mem.id_member, 0) AS id_member, m.id_msg,
 IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name
 FROM leagueoflegends_boards AS b
 LEFT JOIN leagueoflegends_categories AS c ON (c.id_cat = b.id_cat)
 LEFT JOIN leagueoflegends_messages AS m ON (m.id_msg = b.id_last_msg)
 LEFT JOIN leagueoflegends_members AS mem ON (mem.id_member = m.id_member)
 LEFT JOIN leagueoflegends_moderators AS mods ON (mods.id_board = b.id_board)
 LEFT JOIN leagueoflegends_members AS mods_mem ON (mods_mem.id_member = mods.id_member)
 WHERE (FIND_IN_SET(-1, b.member_groups) != 0)



please help me fast!!
my forum link - http://leagueoflegends.createaforum.com/


Note - this is my 1st Forum on Create A Forumsupport
 
« Last Edit: May 19, 2012, 05:43:01 pm by Thelegend »

Share on Facebook Share on Twitter


Offline CreateAForum

  • Administrator
  • *****
  • Posts: 7186
  • Karma: 327
    • View Profile

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: getting Database Error !!
« Reply #1 on: May 19, 2012, 10:59:57 pm »
Fixed.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline Thelegend

  • Newbie
  • *
  • Posts: 5
  • Karma: 1
    • View Profile

Badges: (View All)
Level 2 Windows User Topic Starter
Re: getting Database Error !!
« Reply #2 on: May 20, 2012, 06:36:21 am »
Thank you very much! :)
can i add reputation System at my Forum?
how to give Karma Points to users?
i am Admin of my forum but i am Newbie so how can i change my status ?
« Last Edit: May 20, 2012, 10:21:37 am by Thelegend »

Offline aIURbliS

  • Hero Member
  • *****
  • Posts: 1215
  • Karma: 45
  • Gender: Male
  • Location: U.S.
    • View Profile

Badges: (View All)
Level 6 Sixth year Anniversary Fifth year Anniversary
Re: getting Database Error !!
« Reply #3 on: May 20, 2012, 04:01:32 pm »
You can enable karma in the core features configuration and you can change your status by going to your forum profile.
All codes I make are tested on the latest version of Google Chrome and upon request of other browsers.

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
605 Views
Last post September 16, 2010, 11:21:21 pm
by CreateAForum
2 Replies
691 Views
Last post October 09, 2011, 04:29:41 pm
by Justincase
3 Replies
359 Views
Last post February 01, 2013, 07:07:10 pm
by Willing to Help
6 Replies
670 Views
Last post September 06, 2013, 06:08:32 pm
by CreateAForum
database error

Started by lads Bugs

1 Replies
697 Views
Last post August 09, 2014, 01:56:06 pm
by CreateAForum