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...
Is \"msg_id\" versus \"msgid\" an issue?
TOPIC: Is \"msg_id\" versus \"msgid\" an issue?
#21369
Is \"msg_id\" versus \"msgid\" an issue? 10 Years ago  
Hi all,

I\'ve got FB at version 1.0.1 but also with a few updates from SVN prior to 1.0.2 (if that makes sense) and realise that some of the SQL commands will fail as I already have some of the variables in my tables.

So I did a quick look to see what commands I do need to run to do the update to 1.0.3 and what ones I don\'t. For example, to alter jos_fb_categories I\'m only going to have to run...

[code:1]add column `headerdesc` text NOT NULL after `description`,
add column `class_sfx` varchar(20) NOT NULL after `headerdesc`,
add KEY `msg_id`(`id_last_msg`) [/code:1]

That last bit...the key, gets me slightly confused...as there is a key already there that has \"id_last_msg\" as its field, but it is called \"msgid\" (note no _ in the name).

Should I delete the existing key or rename it? Not sure how keys work.

Cheers, Phil
#21369
Is \"msg_id\" versus \"msgid\" an issue? 10 Years ago  
Hi all,

I\'ve got FB at version 1.0.1 but also with a few updates from SVN prior to 1.0.2 (if that makes sense) and realise that some of the SQL commands will fail as I already have some of the variables in my tables.

So I did a quick look to see what commands I do need to run to do the update to 1.0.3 and what ones I don\'t. For example, to alter jos_fb_categories I\'m only going to have to run...

[code:1]add column `headerdesc` text NOT NULL after `description`,
add column `class_sfx` varchar(20) NOT NULL after `headerdesc`,
add KEY `msg_id`(`id_last_msg`) [/code:1]

That last bit...the key, gets me slightly confused...as there is a key already there that has \"id_last_msg\" as its field, but it is called \"msgid\" (note no _ in the name).

Should I delete the existing key or rename it? Not sure how keys work.

Cheers, Phil
#21407
Re:Is \"msg_id\" versus \"msgid\" an issue? 10 Years ago  
one is enough
Page: 1