Hi,
I've got an issue with the customization screen of ticket. Somone create a field call "Test" an, I cannot delete it in custom screen module.
How I can resolve it ?
show the log file below:
2022-08-30 08:14:49.586 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:14:49.586 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:14:49.587 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:14:49.588 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:14:49.589 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:14:49.589 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:14:49.590 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:14:49.591 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:24:53.819 ===== TRACE ===== =====================================
2022-08-30 08:24:53.819 ===== TRACE =====
2022-08-30 08:24:53.819 ===== TRACE ===== PLUGIN SQL FILE : ../plugin/screenCustomization/temp.sql
2022-08-30 08:24:53.819 ===== TRACE =====
2022-08-30 08:24:53.819 ** ERROR ** [V10.0.4] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP COLUMN `test`; check that it exists
2022-08-30 08:24:53.819 ** ERROR ** [V10.0.4] For query : ALTER TABLE `ticket` DROP COLUMN `test` ;
2022-08-30 08:24:53.819 ** ERROR ** [V10.0.4] Strack trace :
2022-08-30 08:24:53.819 ** ERROR ** [V10.0.4] #0 Sql->query called at [/var/www/html/projeqtor/db/maintenanceFunctions.php:72]
2022-08-30 08:24:53.819 ** ERROR ** [V10.0.4] #1 runScript called at [/var/www/html/projeqtor/plugin/screenCustomization/screenCustomizationSaveField.php:968]
2022-08-30 08:24:53.820 ===== TRACE =====
2022-08-30 08:24:53.820 ===== TRACE ===== Error # 1 => SQL error while executing Plugin query in file ../plugin/screenCustomization/temp.sql (see above message)
2022-08-30 08:24:53.820 ===== TRACE =====
2022-08-30 08:24:53.820 ===== TRACE ===== **********************************************
2022-08-30 08:24:53.820 ===== TRACE =====
2022-08-30 08:24:53.820 ===== TRACE =====
2022-08-30 08:24:53.820 ===== TRACE ===== DATABASE UPDATED
2022-08-30 08:24:53.820 ===== TRACE ===== WITH 1 ERROR
2022-08-30 08:24:53.820 ===== TRACE =====
2022-08-30 08:25:24.431 ===== TRACE ===== NEW CONNECTED USER 'tmartin' (using remember me feature)
2022-08-30 08:25:24.594 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.803 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.888 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.890 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.891 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.891 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.892 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.893 ** ERROR ** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-30 08:25:27.895 ** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
You can edit the file projeqtor/model/custom/Ticket.php and remove
public $Test;
As last option, you can try and reset customization : just delete projeqtor/model/custom/Ticket.php