Layton ServiceDesk - Troubleshooting - Images Not Displayed or File Links Broken
m (Jpainter moved page Layton ServiceDesk™ - General Troubleshooting - Images Not Displayed or File Links Broken to Layton ServiceDesk - General Troubleshooting - Images Not Displayed or File Links Broken: Removed the TM symbol for a cleaner URL) |
(Major revision) |
||
(2 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
+ | __FORCETOC__ | ||
+ | =Overview= | ||
When Layton ServiceDesk is installed, the install path is written to the database. If the application is moved to another server, the path may not be updated. This will cause images to not be displayed or links to files to be broken. | When Layton ServiceDesk is installed, the install path is written to the database. If the application is moved to another server, the path may not be updated. This will cause images to not be displayed or links to files to be broken. | ||
− | + | =Analysis= | |
+ | In Management Studio, run this query: | ||
+ | SELECT sys_admin_value AS "Current Path" | ||
+ | |||
+ | FROM [admin] | ||
+ | |||
+ | WHERE sys_admin_id = 'ap_serverpath' | ||
+ | |||
+ | The result is the currently configured path. Compare this to the URL in your browser's URL field. If it's different, it needs to be changed in the database. | ||
+ | |||
+ | =Fix= | ||
+ | By default, the URL is ''<nowiki>http://servername/laytonservicedesk</nowiki>''. Replace ''<nowiki>ENTERPATHNAMEHERE</nowiki>'' in the below query with your path, including the port number (default :80). For example, if your path is | ||
+ | |||
+ | <nowiki>http://ithelpdeskserver/laytonservicedesk</nowiki> | ||
+ | |||
+ | then the path to enter will be | ||
+ | |||
+ | <nowiki>http://ithelpdeskserver:80/laytonservicedesk</nowiki> | ||
+ | |||
+ | You must get this right. | ||
+ | |||
+ | ==Query== | ||
DECLARE @Path VARCHAR(255) | DECLARE @Path VARCHAR(255) | ||
SET @Path = 'ENTERPATHNAMEHERE' | SET @Path = 'ENTERPATHNAMEHERE' | ||
Line 16: | Line 39: | ||
Open an existing Request containing images or files to ensure that the path is correct. | Open an existing Request containing images or files to ensure that the path is correct. | ||
− | Note that the query will fail if your path is greater than 50 characters, as that is the length of the column. | + | ==Pre-6.5.7== |
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | Note that if you are running a version earlier than 6.5.7, the query will fail if your path is greater than 50 characters, as that is the length of the column. We advise you '''[[LSD Current Version|upgrade to the latest version]]''' as soon as possible, but in the meantime, use the IP address, e.g.: |
+ | |||
+ | <nowiki>http://10.1.1.10:80/laytonservicedesk</nowiki> | ||
+ | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
Latest revision as of 01:08, 23 November 2016
Contents |
[edit] Overview
When Layton ServiceDesk is installed, the install path is written to the database. If the application is moved to another server, the path may not be updated. This will cause images to not be displayed or links to files to be broken.
[edit] Analysis
In Management Studio, run this query:
SELECT sys_admin_value AS "Current Path" FROM [admin] WHERE sys_admin_id = 'ap_serverpath'
The result is the currently configured path. Compare this to the URL in your browser's URL field. If it's different, it needs to be changed in the database.
[edit] Fix
By default, the URL is http://servername/laytonservicedesk. Replace ENTERPATHNAMEHERE in the below query with your path, including the port number (default :80). For example, if your path is
http://ithelpdeskserver/laytonservicedesk
then the path to enter will be
http://ithelpdeskserver:80/laytonservicedesk
You must get this right.
[edit] Query
DECLARE @Path VARCHAR(255) SET @Path = 'ENTERPATHNAMEHERE' UPDATE [admin] SET sys_admin_value = @Path WHERE sys_admin_id = 'ap_serverpath'
Open an existing Request containing images or files to ensure that the path is correct.
[edit] Pre-6.5.7
Note that if you are running a version earlier than 6.5.7, the query will fail if your path is greater than 50 characters, as that is the length of the column. We advise you upgrade to the latest version as soon as possible, but in the meantime, use the IP address, e.g.:
http://10.1.1.10:80/laytonservicedesk