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!
(Solved) SQL Upgrade Error (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: (Solved) SQL Upgrade Error
#20983
(Solved) SQL Upgrade Error 1 Year, 1 Month ago  
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 2
skyxliner (User)
Junior Boarder
Posts: 20
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/09/07 16:07 By skyxliner.
 
Running Joomla 1.0.13 with Fireboard 1.0.3
 
The administrator has disabled public write access.  
#20986
Re:SQL Upgrade Error 1 Year, 1 Month ago  
ahh stupid error, nvm i figured it out.


remove the stupid comments
skyxliner (User)
Junior Boarder
Posts: 20
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Running Joomla 1.0.13 with Fireboard 1.0.3
 
The administrator has disabled public write access.  
Go to top