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...
Error 1064 SQL syntax
TOPIC: Error 1064 SQL syntax
#21881
Error 1064 SQL syntax 10 Years, 2 Months ago  
Thanks for an excellent component! :laugh:

I try to upgrade from 1.0.0 to 1.0.3 I but when I execute Fireboard_100_to_1.0.3.Stable.sql I get:
[code:1]Fel

Error

SQL query:

-- __^__ __^__
- - ( ___ ) ----------------------------------------- - ( ___ ) -- | / | SQL Upgrade | \\ |
-- | / | Fireboard 1.0.0 to 1.0.3 Stable | \\ |
-- |___| Rename jos_ to your db prefix |___|
- - ( _____ ) ----------------------------------------- - ( _____ ) --
/* Alter table in Second database */ ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = \'\';

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'--( ___ )------------------------------------------( ___ )
-- | / | \' at line 1 [/code:1]
#21881
Error 1064 SQL syntax 10 Years, 2 Months ago  
Thanks for an excellent component! :laugh:

I try to upgrade from 1.0.0 to 1.0.3 I but when I execute Fireboard_100_to_1.0.3.Stable.sql I get:
[code:1]Fel

Error

SQL query:

-- __^__ __^__
- - ( ___ ) ----------------------------------------- - ( ___ ) -- | / | SQL Upgrade | \\ |
-- | / | Fireboard 1.0.0 to 1.0.3 Stable | \\ |
-- |___| Rename jos_ to your db prefix |___|
- - ( _____ ) ----------------------------------------- - ( _____ ) --
/* Alter table in Second database */ ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = \'\';

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'--( ___ )------------------------------------------( ___ )
-- | / | \' at line 1 [/code:1]
#21885
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
Dont put this:

[code:1]-- __^__ __^__

- - ( ___ ) ----------------------------------------- - ( ___ ) -- | / | SQL Upgrade | \\ |

-- | / | Fireboard 1.0.0 to 1.0.3 Stable | \\ |

-- |___| Rename jos_ to your db prefix |___|

- - ( _____ ) ----------------------------------------- - ( _____ ) --[/code:1]

But start with:

[code:1]/* Alter table in Second database */ ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,

COMMENT = \'\';[/code:1]
#21888
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
Mien: Thanks! :)

I already try that and get:
[code:1]Error

SQL query:

/* Alter table in Second database */ ALTER TABLE `jos_fb_attachments` ADD KEY `mesid` ( `mesid` ) ,
COMMENT = \'\';

MySQL said: Documentation
#1061 - Duplicate key name \'mesid\' [/code:1]
#21923
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
duplicate means that its already there..and you are trying to do it double..so then continue with the next lines /* and try them one by one..duplicates means that they are there already..so then just continue again with the next one!
#21962
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
in MyPHPadmin I get a \"no database selected\" error when I try to run the upgrade query from 1.0.2 to 1.0.3

So, I can\'t run the upgrade query.

I think that causes the \"There are no forums in this category!\" line in the frontend.

Does anybody know how I can fix this problem?
#22066
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
Do you get that error even after you [b]have[/b] selected a database?
#22115
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
Mien: Thanks for try to help! :)

I try to execute one by one but after the second and all after I get these:
[code:1]Error

SQL query:

ALTER TABLE `jos_fb_categories` ADD COLUMN `headerdesc` text NOT NULL AFTER `description` ,
ADD COLUMN `class_sfx` varchar( 20 ) NOT NULL AFTER `headerdesc` ,
ADD COLUMN `id_last_msg` int( 10 ) NOT NULL DEFAULT \'0\' AFTER `class_sfx` ,
ADD COLUMN `numTopics` mediumint( 8 ) NOT NULL DEFAULT \'0\' AFTER `id_last_msg` ,
ADD COLUMN `numPosts` mediumint( 8 ) NOT NULL DEFAULT \'0\' AFTER `numTopics` ,
ADD COLUMN `time_last_msg` int( 11 ) NULL AFTER `numPosts` ,
DROP KEY `catid` ,
DROP KEY `catparent` ,
ADD KEY `msg_id` ( `id_last_msg` ) ,
ADD KEY `parent` ( `parent` ) ,
ADD PRIMARY KEY ( `id` ) ,
ADD KEY `published_pubaccess_id` ( `published` , `pub_access` , `id` ) ,
COMMENT = \'\'

MySQL said: Documentation
#1091 - Can\'t DROP \'catid\'; check that column/key exists
[/code:1]
#22120
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
[b]grumblemarc wrote:[/b]
[quote]Do you get that error even after you [b]have[/b] selected a database?[/quote]

I managed to select the database and run the query.

Everything is working fine now. Thanks!

The new version looks great!
#22133
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
Now I successfully execute two /* but when I go to administrator>Fireboard i get these:

[code:1]Warning: main(/home//components/com_fireboard/class.fireboard.php) [function.main]: failed to open stream: No such file or directory in /home/administrator/components/com_fireboard/admin.fireboard.php on line 22

Fatal error: main() [function.require]: Failed opening required \'/home/components/com_fireboard/class.fireboard.php\' (include_path=\'.:/usr/local/lib/php\') in /home/administrator/components/com_fireboard/admin.fireboard.php on line 22[/code:1]

I have control over and over again that I upload all files...
#22723
Re:Error 1064 SQL syntax 10 Years, 2 Months ago  
I am getting similar error of drop key.

Plz tell me whether you got solution or not ?
Page: 12