DIR Return Create A Forum - Home
---------------------------------------------------------
Create A Forum - Support Forums
HTML https://support.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: General Support
*****************************************************
#Post#: 4545--------------------------------------------------
getting Database Error !!
DIR By: Thelegend
Date: May 19, 2012, 12:15 pm
---------------------------------------------------------
hi everyone,today i created a forum called
league of legends
HTML http://leagueoflegends.createaforum.com/index.php
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)
--- End Quote ---
please help me fast!!
my forum link -
HTML http://leagueoflegends.createaforum.com/
Note - this is my 1st Forum on Create A Forumsupport
#Post#: 4547--------------------------------------------------
Re: getting Database Error !!
DIR By: CreateAForum
Date: May 19, 2012, 5:59 pm
---------------------------------------------------------
Fixed.
#Post#: 4548--------------------------------------------------
Re: getting Database Error !!
DIR By: Thelegend
Date: May 20, 2012, 1:36 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 ?
#Post#: 4550--------------------------------------------------
Re: getting Database Error !!
DIR By: xboi209
Date: May 20, 2012, 11:01 am
---------------------------------------------------------
You can enable karma in the core features configuration and you
can change your status by going to your forum profile.
*****************************************************
Page 1 of 1