|
|
Member
|
ewanm
-
3/22/2011 9:20:26 AM
Lost Avitar images and page template images after upgrade to 5.5R2
I have just upgrades and migrated existing websites from V5.0 to V5.5R2 and although the upgrade appeared to go without any problems, Once I stared using the new system, I noticed that all of my Avatar images have disappeared. Also when I try and create a new page, and select a template, the thumbnail image displayed is blank. Can anyone tell me where the images are stored.
I have also exported the sites from 5.5R2 and then performed a clean install of 5.5R2 and the images still appear to be missing. Can anyone help?
Ewanm
|
|
|
|
|
Kentico Developer
|
kentico_ivanat
-
3/23/2011 4:55:49 AM
RE:Lost Avitar images and page template images after upgrade to 5.5R2
Hi,
images can be stored (binary data) in the file system (Store files in file system), database (Store files in database) or both. It depends on which setting is selected in the Site Manager - Settings - Files.
If storing in the File system is selected, files exist in the folder, which is defined in the Site Manager -> Settings -> Files ->Files folder. If nothing is filled here avatars are stored in ~/CMSFiles folder.
In database are avatars stored in the CMS_Avatar table.
If avatars are stored in the file system, could you please check if the option Export files was checked, when you created the export?
Page templates thumbnails are stored in the database CMS_MetaFile table or in the file system in the same location as avatars.
Best regards,
Ivana Tomanickova
|
|
|
|
|
Member
|
ewanm
-
4/12/2011 2:28:00 AM
RE:Lost Avitar images and page template images after upgrade to 5.5R2
Hi Ivana,
Sorry for the delay, I have been on holiday.
The export files option was checked during export.
I have created a new site from the blank template and when I attempt to create a new page using a default template, the graphics/thumbnails are all blank. Also if I create a new user and try to choose a pre-defined avitar image, they are all blank.
It appears that the pre-defined Avitar and page template images/thumbnail images are missing. If I select a photo for an avitar, it is stored and works OK.
Regards,
Ewanm
|
|
|
|
|
Kentico Developer
|
kentico_ivanat
-
4/12/2011 5:10:04 AM
RE:Lost Avitar images and page template images after upgrade to 5.5R2
Hi,
could you please check, where the files should be stored in the Site Manager - Settings - Files. In the database or in the file system (Where the files were stored in the original 5.5 version?)
It seems that you are storing files in the file system. (Otherwise, they would be probably displayed correctly.)
Now, could you please check if you defined some directory in the Files folder? Please select appropriate site in the upper left corner first to see a settings for the mentioned site.
Now you could take a look into your project folder and look for the avatar file. Maybe in the settings is set some folder, but original avatar images are in the default CMSFiles directory.
To summarise, please take a look at link with some missing avatar image. In the link you could find the guid of the image and then you could be able to find appropriate record in the database or in the file system. If you will not, please send an export of your site to support@kentico.com with a reference to this thread.
Best regards,
Ivana Tomanickova
|
|
|
|
|
Member
|
ewanm
-
4/13/2011 3:49:18 AM
RE:Lost Avitar images and page template images after upgrade to 5.5R2
Hi Ivana,
I have checked back to my original site (5.0) which is still online and the same problem seems to be there also, no pre-defined Avitars and no pre-defined page template thunbnails.
The first thing I noticed is that you mention the folder CMSFiles and my folder is CMS_Files. Is this OK, the path under my settings is CMS_Files?
Can you give me a list of what folders should be under CMSFiles (CMS_Files). I only seem to have folders relating to my websites.
Regards,
Ewanm
|
|
|
|
|
Kentico Developer
|
kentico_ivanat
-
4/14/2011 5:56:03 AM
RE:Lost Avitar images and page template images after upgrade to 5.5R2
Hi,
1. As a test, please take a look at CMS_Avatars table and look for file with AvatarGUID='D78D8CA2-D9FF-4DA4-8CF1-16363F253E1B'
2. If avatar with this ID exists in your system, check if AvatarBinary column is null or there are binary data.
3. If there are not binary data, you could take a look into your ~/CMS_Files folder and take a look into directory d7 to see if the avatar image is inside or not.
4. If the avatar image will not be found, you could try to create a clear Kentico CMS installation (avatars would be installed by default). Then you could export CMS_Metafile and CMS_Avatar table data and insert rows into tables in your old installation. You can do this directly in the database. This way the missing records would be added.
Please backup your database first to be able to restore it in case things went wrong.
P.S. You can export data in the form if insert query in the SQL Server Manager. Right click on your database - > Tasks - Generate Scripts. In the wizard select appropriate tables, select Advanced and on the bottom set Schema only: Data only. This way the insert script will be generated.
Best regards,
Ivana Tomanickova
|
|
|
|
|
Member
|
ewanm
-
4/20/2011 6:48:45 AM
RE:Lost Avitar images and page template images after upgrade to 5.5R2
Hi Ivana,
Yes this seemed to work. It cured the Avitar problem but the page templates thumbnails are now incorrect. Some of the page templates now show incorrect thumbnail images for the template selected. eg when I select an Article List with Left Menu, the thumbnail shown is for a News Article. The page created is correct.
I can go through all of the page templates and select the correct image files for the thumbnail but I need to know where all of the images are stored. Is it possible that the images with the correct names could be sent to me to allow me to do this?
Regards,
Ewanm
|
|
|
|
|
Kentico Developer
|
kentico_ivanat
-
4/20/2011 7:25:31 AM
RE:Lost Avitar images and page template images after upgrade to 5.5R2
Hi,
images are stored in the CMS_MetaFile table, templates are stored in the CMS_PageTemplate table.
Image thumbnail is connected with the template via MetaFileObjectID (CMS_MetaFile) which is equal to PageTemplateID (CMS_PageTemplate).
Editing MetaFileObjectID column you could assign images to the correct templates.
Best regards,
Ivana Tomanickova
|
|
|