Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

This category is for K 1.7 issues only.
To get started please see K 1.6 & K 1.7 Installation Guide in our Documentation Wiki

Question Upgrade to 1.6.1/ Images and Files, Some worked some did not

More
15 years 2 months ago #87991 by Matias
Replied by Matias on topic Re: Upgrade to 1.6.1/ Images and Files, Some worked some did not
So the issue was different than I thought it would be.. Luckily we did not delete the original files, so they are still in there.

Anyway, some version of FB/Kunena seems to have had broken attachments logic. The issue seems to be that the filename was accidentally tempfile, not the real name. Kunena 1.5 tried to find attachments by looking their name inside messages, but Kunena 1.6 was different and started to use information from the database (much faster).

During upgrade copying those files failed, mostly because of there was wrong filename saved into database. So the file was seen as deleted. The same issue comes when you copy the files -- they cannot be found because of Kunena looks at wrong file.

I think that it's possible to get the files to work again, but I'm not yet sure how to do it automatically.
The topic has been locked.
More
14 years 11 months ago - 14 years 11 months ago #95849 by fsoares
Replied by fsoares on topic Re: Upgrade to 1.6.1/ Images and Files, Some worked some did not
Hi Matias,

I have made an script for correct this(or part) in mySQL...

CAUTION: BACKUP YOUR DATABASE FIRST

Read all frist and if you´re not secure in run this, DO NOT DO

PROCESS TO GET ALL ATTACHMENTS WORKING RIGHT:

Note: This occurs because the converter script not worked as expected and made confusions... ( I´m refering to old versions of script go.php)

First you need copy all files from old folders to new folders:

-> from "images/fbfiles/files" to "/media/kunena/attachments/legacy/files"
and
-> from "images/fbfiles/images" to "/media/kunena/attachments/legacy/images"

Second, run these mysql scripts IN THIS ORDER:
Code:
UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'JPG', 'jpg'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'jpg', 'image/jpg'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'JPEG', 'jpeg'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'jpeg', 'image/jpeg'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'GIF', 'gif'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'gif', 'image/gif'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'PNG', 'png'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'png', 'image/png'); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'txt', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'TXT', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'rtf', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'RTF', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'pdf', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'PDF', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'zip', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'ZIP', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'rar', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'RAR', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'tar', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'TAR', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'gz', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'GZ', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'tgz', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'TGZ', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'bz2', ''); UPDATE jos_kunena_attachments SET filetype = REPLACE(filetype, 'BZ2', ''); UPDATE jos_kunena_attachments SET folder = REPLACE(folder, 'images/fbfiles/files', 'media/kunena/attachments/legacy/files'); UPDATE jos_kunena_attachments SET folder = REPLACE(folder, 'images/fbfiles/images', 'media/kunena/attachments/legacy/images'); UPDATE jos_kunena_attachments SET folder = REPLACE(folder, 'media/kunena/attachments/legacy/files', 'media/kunena/attachments/legacy/images') WHERE filetype LIKE '%image/%'; UPDATE jos_kunena_messages_text SET message = REPLACE(message, 'images/fbfiles/files', 'media/kunena/attachments/legacy/files'); UPDATE jos_kunena_messages_text SET message = REPLACE(message, 'images/fbfiles/images', 'media/kunena/attachments/legacy/images');

Tested with Kunena 1.6.4 after update from the Fireboard 1.0.4, in that the data have been migrated from a phpBB3 3.0.5 forum. :)
Fernando Soares - Mantendo sua Tecnologia
Hospedagem Joomla e VirtueMart Hosting
twitter.com/fernando_soares
www.fernandosoares.com.br
Last edit: 14 years 11 months ago by fsoares.
The topic has been locked.
More
14 years 5 months ago #112672 by audisport
Replied by audisport on topic Re: Upgrade to 1.6.1/ Images and Files, Some worked some did not
Little question, I did not made anything at the time of conversion of lots of those pictures are still with this problem.

Now I'm on Kunena 1.7.1. Can I still run this script without touching the attachements/posts made after that date?

Thanks a lot for your assistance ;)
The topic has been locked.
More
14 years 4 months ago - 14 years 4 months ago #113722 by fsoares
Replied by fsoares on topic Re: Upgrade to 1.6.1/ Images and Files, Some worked some did not
Think yes but I not tested it...
Fernando Soares - Mantendo sua Tecnologia
Hospedagem Joomla e VirtueMart Hosting
twitter.com/fernando_soares
www.fernandosoares.com.br
Last edit: 14 years 4 months ago by fsoares.
The topic has been locked.
Time to create page: 0.245 seconds