Dear FireBoard users,
In order to further develope the need of Joomla for a robust forum, FireBoard component has been moved to its own new home and new name. You can find more information regarding the Kunena, the successor of FireBoard, at kunena.com. The current forum here will stay for some time more for referencing needs. You can find the FireBoard files under joomlacode.org and other files
Upgrading to Kunena is highly recommended!

Kunena! - To Speak!

A revolution is coming... Kunena - Swahili for: To Speak! THE Next generation of native Joomla based Forum ultra component. Forget what you know about Joomla based forums...
Amazingly Simple Lean and Clean Easier Customization
Kunena is about to redefine the world of Joomla! with the most simplistic ultra component out there. For ultimate performance based on state of the art development techniques, Kunena! is about to bring you... With an integrated plugin system that will allow you to extend Kunena beyond your wildest imaginations...
TOPIC: SQL question
#20308
SQL question 10 Years ago  
sorry just a SQL question before i execute the Fireboard_102_to_1.0.3.Stable.sql ......
in phpmyadmin do i select all the tables before i execute ? or i just select the jos_fb_ ones?
sorry i just donno much about that
#20308
SQL question 10 Years ago  
sorry just a SQL question before i execute the Fireboard_102_to_1.0.3.Stable.sql ......
in phpmyadmin do i select all the tables before i execute ? or i just select the jos_fb_ ones?
sorry i just donno much about that
#20311
Re:SQL question 10 Years ago  
nope, just run.
#20314
Re:SQL question 10 Years ago  
thank you i did but now i get this msg \"You have to choose at least one column to display\"
#20315
Re:SQL question 10 Years ago  
ops no now i get this error


Error

SQL query:

/* Alter table in Second database */ ALTER TABLE `jos_fb_categories` CHANGE `moderated` `moderated` tinyint( 4 ) NOT NULL DEFAULT \'0\' AFTER `alert_admin` ,
ADD COLUMN `headerdesc` text NOT NULL AFTER `description` ,
ADD COLUMN `class_sfx` varchar( 20 ) NOT NULL AFTER `headerdesc` ,
CHANGE `id_last_msg` `id_last_msg` int( 10 ) NOT NULL DEFAULT \'0\' AFTER `class_sfx` ,
COMMENT = \'\';

MySQL said: Documentation
#1054 - Unknown column \'id_last_msg\' in \'jos_fb_categories\'
#20329
Re:SQL question 10 Years ago  
when looking at jos_fb_categories....is there a item listed for \"id_last_msg\"?
#20331
Re:SQL question 10 Years ago  
no i dont see any
thats all i have there ....



id int(11) No auto_increment Browse distinct values Change Drop Primary Unique Index Fulltext
parent int(11) Yes 0 Browse distinct values Change Drop Primary Unique Index Fulltext
name tinytext latin1_swedish_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
cat_emoticon tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
locked tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
alert_admin tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
moderated tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
moderators varchar(15) latin1_swedish_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
pub_access tinyint(4) Yes 1 Browse distinct values Change Drop Primary Unique Index Fulltext
pub_recurse tinyint(4) Yes 1 Browse distinct values Change Drop Primary Unique Index Fulltext
admin_access tinyint(4) Yes 0 Browse distinct values Change Drop Primary Unique Index Fulltext
admin_recurse tinyint(4) Yes 1 Browse distinct values Change Drop Primary Unique Index Fulltext
ordering tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
future2 int(11) Yes 0 Browse distinct values Change Drop Primary Unique Index Fulltext
published tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
checked_out tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
checked_out_time datetime No 0000-00-00 00:00:00 Browse distinct values Change Drop Primary Unique Index Fulltext
review tinyint(4) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
hits int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
description text latin1_swedish_ci No
#20335
Re:SQL question 10 Years ago  
Sorry, I am not an expert in SQL. Hopefully someone will be able to answer better for you
#20338
Re:SQL question 10 Years ago  
oh god :/
well thank you man anyways u did good but now sadly i have to wait for someone to help me means more offline time for me forum :(
#20346
Re:SQL question 10 Years ago  
hmmm i didnt find many tables in the jos_fe_categoris so i used the Fireboard_101_to_1.0.3.Stable.sql & it worked \"Your SQL query has been executed successfully\"
so strange i am sure i had the 1.0.2 version not 1.0.1 but now anyways i dont see anytopics in my categories but i still have the same stats so the categories are there but not shown :/
#20405
Re:SQL question 10 Years ago  
I´m upgrading from 1.0.0 and have a question. In the desciption it says. Open \"Upgrades/Fireboard_100_to_1.0.3.Stable.sql\" file
Thats ok...but now to the stupid question. What shall i do with the file?? Whats the next step?

Am i going to load it somewhere or...???
Page: 12