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.

    yeah, this code creates the tables for your database.

    do you have anything like phpmyadmin installed on the server?

      Originally posted by thorpe
      yeah, this code creates the tables for your database.

      do you have anything like phpmyadmin installed on the server?

      I just installed the lastest phpmyadmin 2.6.2 and my web hosting suports the requirements, now what do I do?

        Write a Reply...