Hostony Board > database table creation

Hostony Board > General Support > PHP/MySQL

Mystic

Sep 18 2004, 07:02 PM

due to my severe lack of Mysql knowledge and my desire not to have anything go wrong with my new forum,(mystic_khanbb database)

i was wondering if i could get some help with this. I'm lost after CREATE TABLE..

CODE

#
#-----[ 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;

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config VALUES (
'site_warning', 'If you can see this, the MOD was installed successfully. Now change the message in the ACP.'
);

#
#

Alexandre

Sep 18 2004, 08:56 PM

I hope this link will help you

http://dev.mysql.com/doc/mysql/en/

Mystic

Sep 18 2004, 09:25 PM

ok now you're just teasing me!

the rest of the mod was pretty easy to install cause it was just changes to the php/tpl files and the FIND x , AFTER x Paste y, instructions helped.

i found the phpmyadmin in cpanl, but it didnt seem as simple as just c/p that into a window.

ya know.

maybe after spending a month at that link i'll have a clue what i'm doing.

I just need to remember to make a back up this time haha

artrocity

Sep 18 2004, 09:30 PM

you were in the right place

just select the correct database on the right
click on the top tab called SQL

and there is your window you can c/p to!
Press GO and hope for the best !

And yes , it would be a good idea to make a backup
before doing this

Mystic

Sep 18 2004, 10:10 PM

oke did the c/p in the sql window there and the last one worked fine
but i'm getting this error for the other mods

(not forum breaking, as this mod only affects admin options and the errors are only seen when you try to access the options)

CODE

Couldn't get list of Languages

DEBUG MODE

SQL Error : 1146 Table 'mystic_khanbb.BBCODE_TABLE' doesn't exist

SELECT lang_id, count(faq_id) AS faq_count FROM BBCODE_TABLE GROUP BY lang_id

Line : 177
File : /home/mystic/public_html/khanforum/admin/admin_faq.php

CODE

Couldn't get list of Languages

DEBUG MODE

SQL Error : 1146 Table 'mystic_khanbb.FAQ_TABLE' doesn't exist

SELECT lang_id, count(faq_id) AS faq_count FROM FAQ_TABLE GROUP BY lang_id

Line : 177
File : /home/mystic/public_html/khanforum/admin/admin_faq.php

CODE

Couldn't get list of Languages

DEBUG MODE

SQL Error : 1146 Table 'mystic_khanbb.FAQ_TABLE' doesn't exist

SELECT lang_id, count(faq_id) AS faq_count FROM FAQ_TABLE GROUP BY lang_id

Line : 57
File : /home/mystic/public_html/khanforum/admin/admin_faq_inst.php

Dark Hedgehog

Sep 19 2004, 02:05 AM

Check what version of PhpBB you have and what the mod supports.

Also, I would recommend a trial version of IPB (Invision Power Board)
Here.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.

IPS Driver Error