|
Hey!
I gotta problem...I followed the instructions from the pdf and everything worked well until I tried to run the sql upgrade script (Fireboard_101_to_1.0.3.Stable.sql).
I got the following Error:
[code:1]
Error
SQL query:
-- __^__ __^__
- - ( ___ ) ----------------------------------------- - ( ___ ) -- | / | SQL Upgrade | |
-- | / | Fireboard 1.0.1 to 1.0.3 Stable | |
-- |___| Rename jos_ to your db prefix |___|
- - ( _____ ) ----------------------------------------- - ( _____ ) --
/* Alter table in Second database */ 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` ,
ADD KEY `msg_id` ( `id_last_msg` ) ,
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]
It says something about a syntax and that my server has a different one?!
I'm not very good at MySQL, any ideas?
Thanks a lot.
|
