After upgrading to version 7.0.121306, viewing the Assets main page causes the Red Bar Error:
"There was an error retrieving the data for this page. Please refresh the page.
If the error persists, try resetting the default page layout.
Asset Types, Locations, Import Assets tabs should still be visible without any errors
Sample Logs from Settings | Logs | Server Errors
[Mon Mar 20 09:13:33.619672 2017] [proxy_fcgi:error] [pid 93623:tid 34473086976] [client 10.10.10.10:57735] AH01071:
Got error 'PHP message: Exception in KGridPage::GetPagedData: mysqli error: [1064:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY ASSET.ID ) total_records_query' at line 39] in EXECUTE("select count(*) from (SELECT ASSET.ID, ASSET.NAME AS ASSET_NAME, T.NAME AS ASSET_TYPE, COALESCE(AC.NAME, 'None') AS ASSET_SUBTYPE,\n IF(U.FULL_NAME != '', U.FULL_NAME, U.USER_NAME) AS USER, \n T.MAPPED_TABLE, T.DETAIL_PAGE, ASSET.ASSET_DATA_ID, ASSET.MAPPED_ID,\n M.NAME AS MACHINE_NAME,\n ASSET.ASSET_TYPE_ID,\n L.NAME AS LOCATION,\n GROUP_CONCAT(DISTINCT D.NAME) AS DEPARTMENT, \n GROUP_CONCAT(DISTINCT C.NAME) AS COST_CENTER,\n ASSET.ARCHIVE AS ASSET_ARCHIVE, ARCHIVE_ASSET_DEVICE.NAME AS ARCHIVED_MACHINE_NAME FROM ASSET\n INNER JOIN ASSET_TYPE T ON T.ID = ASSET.ASSET_TYPE_ID\n\n LEFT JOIN ASSET_CLAS...\n', referer: http://k1000/adminui/assets.php
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center