Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
SQL question (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: SQL question
#20308
SQL question 1 Year, 1 Month 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
Marshall (User)
Junior Boarder
Posts: 42
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#20311
Re:SQL question 1 Year, 1 Month ago  
nope, just run.
palebluedot (Moderator)
FB Documentation Team
Template Documentation Project
Moderator
Posts: 622
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Minneapolis, MN US Birthdate: 1973-01-12
Logged Logged
 
 
The administrator has disabled public write access.  
#20314
Re:SQL question 1 Year, 1 Month ago  
thank you i did but now i get this msg "You have to choose at least one column to display"
Marshall (User)
Junior Boarder
Posts: 42
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#20315
Re:SQL question 1 Year, 1 Month 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'
Marshall (User)
Junior Boarder
Posts: 42
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#20329
Re:SQL question 1 Year, 1 Month ago  
when looking at jos_fb_categories....is there a item listed for "id_last_msg"?
palebluedot (Moderator)
FB Documentation Team
Template Documentation Project
Moderator
Posts: 622
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Minneapolis, MN US Birthdate: 1973-01-12
Logged Logged
 
 
The administrator has disabled public write access.  
#20331
Re:SQL question 1 Year, 1 Month 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
Marshall (User)
Junior Boarder
Posts: 42
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#20335
Re:SQL question 1 Year, 1 Month ago  
Sorry, I am not an expert in SQL. Hopefully someone will be able to answer better for you
palebluedot (Moderator)
FB Documentation Team
Template Documentation Project
Moderator
Posts: 622
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Minneapolis, MN US Birthdate: 1973-01-12
Logged Logged
 
 
The administrator has disabled public write access.  
#20338
Re:SQL question 1 Year, 1 Month 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
Marshall (User)
Junior Boarder
Posts: 42
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#20346
Re:SQL question 1 Year, 1 Month 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 :/
Marshall (User)
Junior Boarder
Posts: 42
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#20405
Re:SQL question 1 Year, 1 Month 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...???
Overberg (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top