Missing attachments after upgrade v2.0.17 to v2.6.9

[Sebzy]

Have over 700 faqs and many with attachments within our DB (mysql) and all attachments seem to have disappeared during the upgrade

I went from v2.0.17 to v2.6.9 and the upgrade completed without any problems
Each faq shows the normal content but no mention of attachments. I have had a look at the DB to verify

Select * faqdata where solution_id="1692"
+-----+------+-------------+-------------+--------+--------+---------------------------------------+------------------------------------------+----------------------------+--------+---------------------+---------+----------------+-------------+------------------+----------------+----------------+
| id | lang | solution_id | revision_id | active | sticky | keywords | thema | content | author | email | comment | datum | links_state | links_check_date | date_start | date_end |
+-----+------+-------------+-------------+--------+--------+---------------------------------------+------------------------------------------+----------------------------+--------+---------------------+---------+----------------+-------------+------------------+----------------+----------------+
| 693 | en | 1692 | 1 | yes | 0 | XXX | XXX | See attached document
| Ian | xxx@xxx.com | n | 20100730120609 | nolinks | 1280487970 | 00010101000000 | 99991231235959 |
+-----+------+-------------+-------------+--------+--------+---------------------------------------+------------------------------------------+----------------------------+--------+---------------------+---------+----------------+-------------+------------------+----------------+----------------+


I see that both tables faqattachment and faqattachment_file are empty 0 records.

All the files are still there on the filesystem under the right IDs but not linked to the faq


Can anyone help?

Thanks

[Thorsten]

Hi,

you have to run the migration script located in /install/attachment.php

bye
Thorsten

[Sebzy]

Hi Thorsten

That work and everything looks fine now. Thank you very much for all of your fine development and support work on the FAQ it's much appreciated.

[Thorsten]

Hi,

great news.

Thanks for using phpMyFAQ!

bye
Thorsten

[tzwicker]

Hi I updated from v2.0x to v.2.6.11 (latest one so far)
and the script you mentioned above did nothing.
When I type it in the url it displays a white page and thats it
Any ideas?

[Thorsten]

Hi,

I'll check this issue.

bye
Thorsten

[tzwicker]

I went partly back to Version v.2.6.9 and the script worked half.
Only English articles have been updated, but the sql result generated by the script could be copied for German entries.
So i am finished.
So far 2.6.11 has attachment bugs and rss bugs -> seperate task viewtopic.php?f=3&t=10705&p=32149
Thanks for improving phpMyFAQ

Gruß Thorsten Z.

[Thorsten]

Hi,

this should fix the issue: https://github.com/thorsten/phpMyFAQ/co ... aa4ef74989

bye
Thorsten