sorry if this was mentioned on the board before.
Let me explain my problem. Sorry if the message will be long I need to explain myself clearly.
Firstly, I made a database for my phpBB forum. I am trying to install a mod for my forum which is the faq admin 1.4.6. I did everything they said in the install file. Except that I don't know what the following below means:
#-----[ SQL ]------------------------------------------
CREATE TABLE phpbb_faq
(
lang_id
varchar(50) NOT NULL default 'english',
faq_id
tinyint(11) NOT NULL default '0',
faq_title
varchar(255) NOT NULL default '',
PRIMARY KEY (faq_id
,lang_id
)
) TYPE=MyISAM;
#-----[ SQL ]------------------------------------------
CREATE TABLE phpbb_faq_text
(
lang_id
varchar(50) NOT NULL default 'english',
q_id
tinyint(11) NOT NULL default '0',
faq_id
tinyint(11) NOT NULL default '0',
q
text NOT NULL,
a
text NOT NULL,
PRIMARY KEY (q_id
,lang_id
)
) TYPE=MyISAM;
#-----[ SQL ]------------------------------------------
CREATE TABLE phpbb_bbcode
(
lang_id
varchar(50) NOT NULL default 'english',
faq_id
tinyint(11) NOT NULL default '0',
faq_title
varchar(255) NOT NULL default '',
PRIMARY KEY (faq_id
,lang_id
)
) TYPE=MyISAM;
#-----[ SQL ]------------------------------------------
CREATE TABLE phpbb_bbcode_text
(
lang_id
varchar(50) NOT NULL default 'english',
q_id
tinyint(11) NOT NULL default '0',
faq_id
tinyint(11) NOT NULL default '0',
q
text NOT NULL,
a
text NOT NULL,
PRIMARY KEY (q_id
,lang_id
)
) TYPE=MyISAM;
I think it has to do with creating a mysql database. And I don't know how to do that and I tried to get help on many websites including the forum on www.phpbb.com and no luck. I am an amateur when it comes to php / sql.
When I go into my admin control panel in my phpbb forum I see that
FAQ Admin
BBCode Admin
FAQ Admin
FAQ lang installer
is installed but when I click on any of the links such as faq admin or bbcode admin it says this;
General Error
Couldn't get list of Languages
DEBUG MODE
SQL Error : 1146 Table 'forum_michaeljatas_ca.FAQ_TABLE' doesn't exist
SELECT lang_id, count(faq_id) AS faq_count FROM FAQ_TABLE GROUP BY lang_id
Line : 177
File : admin_faq.php
Please help me. I have been searching for ever.