Images (insterted to tickets) not shown in Zammad (after upgrade to 6.3)

Technical assistance
1

Infos:

  • Used Zammad version: 6.3.0-1713783379.979314a7.bullseye
  • Used Zammad installation type: package
  • Operating system: Debian GNU/Linux 11 (bullseye)
  • Browser + version: any tested browser versions and operating-systems

We upgraded our zammad installation from zammad 6.2 to 6.3.
Everything worked well but images in Tickets (inserted via copy and paste) bevore Upgrade are not shown.
The used image url in the ticket-web-view hast the syntax: cid:97584.b1b1650a-b337-4681-806f-df57e1348d15@server.fqdn

New added images (inserted via copy and paste after upgrade) worked as expected.

Is there a way to reenable these old image-references ?

the command “sudo -u zammad zammad run rake zammad:searchindex:rebuild”
did not solve the problem.

I can revert the last update (restore snapshot before update) but the i will lose all tickts and changes of this day.

Do you have any suggestions to solve this problem or to find more information about whats happened / where the problem is located.

2

Hi @datenschuft ,

Can you give us some infos?

  • How old is your system? What was the starting version of zammad?
  • Did you migrate your database at some point? Maybe from MySQL to Postgres or to a different host?

Please provide me the output of the following command:

root> zammad run rails r "pp Store.where(\"o_id LIKE '%.0'\").count"
0
3

Hi rolfschmidt

the system was installed in 2018_03 as Zammad Version 2.x with MySQL.
and migrated many times to new Debian Versions (with Backup and Restore) and migrated from MySQL to PostgreSQL.
Database -migration was done before zammad announced the migration Infos:
so I wrote my own (2021_10)

and here the output of the command

zammad run rails r "pp Store.where(\"o_id LIKE '%.0'\").count"
114844
4

Hi @datenschuft ,

I prepared some advice for you, please check this:

Let me know if it helps please.

1 Like
5

Hi @rolfschmidt
Thanks.
the Dry-RUN looks good.

I used the following grep to verify the output of the DRY-Run; maybe this helps other users

zammad run rails r fix_store_object_o_id_floats.rb | grep -v -E "Change store object [0-9]+ \((Ticket\:\:Article(|\:\:Mail)|Avatar\:\:User\:\:(Resize|Full)|System\:\:Logo|UploadCache)\) o_id from [0-9]+\.0 to [0-9]+"

I would run the PROD Mode after a Backup in the afternoon (after the rush hours)
and give you a update here.

6

Hi @datenschuft,

is there any chance you still have the code/documentation from your MySQL → PostgreSQL migration lying around somewhere?

7

@t-shehab lookie lookie

8

Oh wow, lol. :joy:

I guess I missed the forest for the trees there.

9

Hi @rolfschmidt and the other core team members.

Thanks a lot
your script worked well.

all images are visible again

for other users:
put zammad in maintenance mode
run the script (after checking the output from the dry run)
disable maintenance mode
reload browser - feeling lucky

1 Like
10

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.