Does iTop is suppose to change url of image in private/public log of ticket when changing domain ?
I imported PROD database into my DEV setup, and when I specified localhost:8055 in the wizard setup, it didn't modified the url images.
I deleted cache-production folder too, no success.
Is there a way to tell iTop, switch domain to another of url images?
My workaround: I have to modify carefully (without changing numbers of characters in column 'private_log') by adding space like that:
UPDATE
itopnoclive.ticket
SET
private_log = REPLACE(private_log, 'src="https://my.production.domain/pages/ajax.document.php?operation=download_inlineimage',
'src="http://localhost:8055/pages/ajax.document.php?operation=download_inlineimage')
(Pay attention to the spaces before src)
WHERE
private_log LIKE '%https://my.production.domain/pages/ajax.document.php?operation=download_inlineimage%'
and id = xxxxx
If we change number of characters, display of private_log in the UI will be corrupt.
Any better tips to solve this issue?
Thanks a lot for your time.
Last edit: Maxime Charbonneau 2022-08-16
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
To complete my previous message, I would rather try to apply the modifications in the above commit rather than touch the DB. As Jeffrey mentioned, the caselog indexes are very sensitive.
Actually Combodo has a module to fix caselog indexes but I think it's customers only for now.
Cheers,
Guillaume
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
iTop version 3.0.1-9191
Does iTop is suppose to change url of image in private/public log of ticket when changing domain ?
I imported PROD database into my DEV setup, and when I specified localhost:8055 in the wizard setup, it didn't modified the url images.
I deleted cache-production folder too, no success.
Is there a way to tell iTop, switch domain to another of url images?
My workaround: I have to modify carefully (without changing numbers of characters in column 'private_log') by adding space like that:
UPDATE
itopnoclive.ticket
SET
private_log = REPLACE(private_log, 'src="https://my.production.domain/pages/ajax.document.php?operation=download_inlineimage',
'
src="http://localhost:8055/pages/ajax.document.php?operation=download_inlineimage')(Pay attention to the spaces before src)
WHERE
private_log LIKE '%https://my.production.domain/pages/ajax.document.php?operation=download_inlineimage%'
and id = xxxxx
If we change number of characters, display of private_log in the UI will be corrupt.
Any better tips to solve this issue?
Thanks a lot for your time.
Last edit: Maxime Charbonneau 2022-08-16
I have a similar issue. The problem is that also the length etc of each log entry is stored in the database.
I'm not sure if there's an easy way, other than writing a custom script which fixes the length indicator of each log entry as well.
Hello Maxime,
I think has been fixed in the upcoming 3.0.2 version, planned to be released in September.
The corresponding commit : d21b577dd79
Cheers,
Guillaume
To complete my previous message, I would rather try to apply the modifications in the above commit rather than touch the DB. As Jeffrey mentioned, the caselog indexes are very sensitive.
Actually Combodo has a module to fix caselog indexes but I think it's customers only for now.
Cheers,
Guillaume