戻る
-
タイトル
Oops error when saving an asset type -
説明
When saving an Asset Type an error may be received: "Oops! Something went wrong.". With this specific situation, when clicking on 'More Info' the error may reference: Duplicate column name. The column name may be the same as a default column name.
Default column names:
- ID
- ASSET_TYPE_ID
- ASSET_DATA_ID
- MODIFIED
- CREATED
- OWNER_ID
- MAPPED_ID
- ASSET_CLASS_ID
- ARCHIVE
- ARCHIVE_DATE
- ARCHIVE_REASON
- LOCATION_ID
- ASSET_STATUS_ID
Example Error:
PHP Error: Uncaught Unhandled Exception in /kbox/kboxwww/include/AssetViewCreator.class.php on line 77: mysqli error: [1060: Duplicate column name 'Modified'] in EXECUTE("CREATE OR REPLACE VIEW ASSET_DATA_VIEW_Device AS SELECT AD.ID, A.ID AS ASSET_ID, A.NAME, A.OWNER_ID, A.MODIFIED, A.CREATED, A.MAPPED_ID, A.ASSET_CLASS_ID, A.ARCHIVE, A.ARCHIVE_DATE, A.ARCHIVE_REASON , AD.FIELD_9921 AS 'Contact', AD.FIELD_9922 AS 'Location', AD.FIELD_9923 AS 'Black_Toner___Description', AD.FIELD_9924 AS 'Black_Toner___Maximum_Level', AD.FIELD_9925 AS 'Black_Toner___Current_Level', AD.FIELD_9926 AS 'Cyan_Toner___Description', AD.FIELD_9927 AS 'Cyan_Toner___Maximum_Level', AD.FIELD_9928 AS 'Cyan_Toner___Current_Level', AD.FIELD_9929 AS 'Magenta_Toner___Description', AD.FIELD_9930 AS 'Magenta_Toner___Maximum_Level', AD.FIELD_9931 AS 'Magenta_Toner___Current_Level', AD.FIELD_9932 AS 'Yellow_Toner___Description', AD.FIELD_9933 AS 'Yellow_Toner___Maximum_Level', AD.FIELD_9934 AS 'Yellow_Toner___Current_Level', AD.FIELD_9935 AS 'Contact_2', AD.FIELD_9936 AS 'Location_2', AD.FIELD_9937 AS 'Black_Toner___Description_2', AD.FIELD_9938 AS 'Black_Toner___Maximum_Level_2', AD.FIELD_9939 AS 'Black_Toner___Current_Level_2', AD.FIELD_10002 AS 'Modified' FROM ASSET_DATA_5 AD JOIN ASSET A ON A.ASSET_TYPE_ID = 5 AND A.ASSET_DATA_ID = AD.ID")