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!
Upgrade 1.0.1 to 1.0.3 additional queries to run (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Upgrade 1.0.1 to 1.0.3 additional queries to run
#28145
Upgrade 1.0.1 to 1.0.3 additional queries to run 1 Year, 1 Month ago  
I had to change the file-links within the forum-messages from /components/com_fireboard/uploaded/files to /images/fbfiles/files. This was done by replacing the links in the database tables jos_fb_attachments and jos_fb_messages_text.
The SQL could be the following (if there is only one file per message), replacing siteurl, number, sitepath by what you need.
[code:1]UPDATE `jos_fb_messages_text`
SET message = concat(substr(message,1,LOCATE('siteurl/components/com_fireboard/uploaded',message)-1),
'siteurl/images/fbfiles', substr(message,LOCATE('siteurl/components/com_fireboard/uploaded',message)+ number))
WHERE message LIKE "%]siteurl/components/com_fireboard/uploaded%";

UPDATE `jos_fb_attachments`
SET filelocation = concat(substr(filelocation,1,LOCATE('sitepath/components/com_fireboard/uploaded',filelocation)-1),
'sitepath/images/fbfiles', substr(filelocation,LOCATE('sitepath/components/com_fireboard/uploaded',filelocation)+ number))
WHERE filelocation LIKE "%siteurl/components/com_fireboard/uploaded%";[/code:1]
mreiter (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/10/18 13:09 By mreiter.
 
The administrator has disabled public write access.  
#28310
Re:Upgrade 1.0.1 to 1.0.3 additional queries to ru 1 Year, 1 Month ago  
I haven't had a chance to actually run these but they look like they solve all those broken image link issues when upgrading.
grumblemarc (User)
Platinum Boarder
Posts: 3559
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
Go to top