Forum

custom screen ticke...
 
Notifications
Retirer tout

custom screen ticket

2 Posts
2 Utilisateurs
0 Reactions
1,049 Vu
(@pdecloedt)
Posts: 165
Active Member
Début du sujet
 
[#8445]

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


 
Posté : 30 Août AM 10:088
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 30 Août PM 22:088
Share:
Retour en haut