View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Plugin Screen Customization error while creating new field - ProjeQtOr
 

Plugin Screen Customization error while creating new field

More
12 Apr 2018 19:16 #1 by karl.binet
Plugin Screen Customization error while creating new field was created by karl.binet
Hi,

V7.0.3

I created a new field in Project screen

name of the field : referenceCode
caption for the field : Numéro de Référence
Format : varchar
lenght : 25

When I hit OK to save, everyone who was connected to Projeqtor was kick out instantly.

Got this error in log (See below)

The project table in database was completly wipe out
when i got back in projector all screen were empyt, no more project, no more activities, no more nothing, everything was empty
I had to restore from backup.

Can you help ?

2018-04-12 09:52:32.061 ***** ERROR ***** [V7.0.3] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'resource.userName' in 'where clause'
2018-04-12 09:52:32.061 ***** ERROR ***** [V7.0.3] For query : select resource.id as id, resource.fullName as name, 32 as photo, resource.initials as initials, T1.name as nameClient, T2.name as nameProfile, resource.name as userName, resource.isUser as isUser, resource.isResource as isResource, resource.idle as idle from resource left join client as T1 on resource.idClient = T1.id left join profile as T2 on resource.idProfile = T2.id where ( 1=2 or resource.name LIKE '%LGT%' or resource.userName LIKE '%LGT%' or resource.initials LIKE '%LGT%' or resource.email LIKE '%LGT%' or resource.function LIKE '%LGT%' or resource.phone LIKE '%LGT%' or resource.mobile LIKE '%LGT%' or resource.fax LIKE '%LGT%' or resource.description LIKE '%LGT%' or resource.designation LIKE '%LGT%' or resource.street LIKE '%LGT%' or resource.complement LIKE '%LGT%' or resource.zip LIKE '%LGT%' or resource.city LIKE '%LGT%' or resource.state LIKE '%LGT%' or resource.country LIKE '%LGT%' or resource.password LIKE '%LGT%' or exists ( select 'x' from note where note.refType='Contact' and note.refId=resource.id and note.note LIKE '%LGT%' ) ) and ((1=1)) and resource.isContact='1' order by resource.id desc
2018-04-12 09:52:32.061 ***** ERROR ***** [V7.0.3] Strack trace :
2018-04-12 09:52:32.061 ***** ERROR ***** [V7.0.3] #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:722]
2018-04-12 10:01:12.087 ===== TRACE ===== NEW CONNECTED USER 'jst-gelais'
2018-04-12 11:13:08.246 ===== TRACE ===== =====================================
2018-04-12 11:13:08.246 ===== TRACE =====
2018-04-12 11:13:08.246 ===== TRACE ===== PLUGIN SQL FILE : ../plugin/screenCustomization/temp.sql
2018-04-12 11:13:08.246 ===== TRACE =====
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/Sql.php' at line (92)
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] cause = PDO::query(): MySQL server has gone away
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/Sql.php' at line (92)
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] cause = PDO::query(): Error reading result set's header
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] For query : ALTER TABLE `project` ADD `referenceCode` varchar(25);
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] Strack trace :
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:71]
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] #1 runScript called at [/var/www/html/plugin/screenCustomization/screenCustomizationSaveField.php:848]
2018-04-12 11:13:08.424 ===== TRACE =====
2018-04-12 11:13:08.424 ===== TRACE ===== Error # 1 => SQL error while executing Plugin query in file ../plugin/screenCustomization/temp.sql (see above message)
2018-04-12 11:13:08.424 ===== TRACE =====
2018-04-12 11:13:08.424 ===== TRACE ===== *************************************************
2018-04-12 11:13:08.424 ===== TRACE =====
2018-04-12 11:13:08.424 ===== TRACE =====
2018-04-12 11:13:08.424 ===== TRACE ===== DATABASE UPDATED
2018-04-12 11:13:08.424 ===== TRACE ===== WITH 1 ERROR
2018-04-12 11:13:08.424 ===== TRACE =====
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] EXCEPTION *****
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/Sql.php' at line (239)
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] cause = Call to a member function quote() on null
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] => #0 /var/www/html/model/persistence/SqlElement.php (2289) -> str()
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] => #1 /var/www/html/model/persistence/SqlElement.php (2616) -> getSqlElementsFromCriteria()
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] => #2 /var/www/html/model/Audit.php (145) -> getSingleSqlElementFromCriteria()
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] => #3 /var/www/html/tool/projeqtor.php (263) -> updateAudit()
2018-04-12 11:13:08.541 ***** ERROR ***** [V7.0.3] => #4 /var/www/html/view/objectDetail.php (30) -> require_once()
2018-04-12 11:13:08.543 ***** ERROR ***** [V7.0.3] EXCEPTION *****
2018-04-12 11:13:08.544 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/Sql.php' at line (239)
2018-04-12 11:13:08.544 ***** ERROR ***** [V7.0.3] cause = Call to a member function quote() on null
2018-04-12 11:13:08.544 ***** ERROR ***** [V7.0.3] => #0 /var/www/html/model/persistence/SqlElement.php (2289) -> str()
2018-04-12 11:13:08.544 ***** ERROR ***** [V7.0.3] => #1 /var/www/html/model/persistence/SqlElement.php (2616) -> getSqlElementsFromCriteria()
2018-04-12 11:13:08.544 ***** ERROR ***** [V7.0.3] => #2 /var/www/html/model/Audit.php (145) -> getSingleSqlElementFromCriteria()
2018-04-12 11:13:08.544 ***** ERROR ***** [V7.0.3] => #3 /var/www/html/tool/projeqtor.php (263) -> updateAudit()
2018-04-12 11:13:08.544 ***** ERROR ***** [V7.0.3] => #4 /var/www/html/plugin/screenCustomization/screenCustomizationFields.php (27) -> require_once()
2018-04-12 11:13:10.527 ***** ERROR ***** [V7.0.3] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.project' doesn't exist
2018-04-12 11:13:10.527 ***** ERROR ***** [V7.0.3] For query : select project.id as id, project.creationDate as creationDate, convert(concat(COALESCE(T1.sortOrder,''),'#split#',T1.name,'#split#',COALESCE(T1.color,'')) using utf8) as colorNameHealth, project.projectCode as projectCode, T2.name as nameClient, project.name as name, convert(concat(COALESCE(T3.sortOrder,''),'#split#',T3.name,'#split#',COALESCE(T3.color,'')) using utf8) as colorNameStatus, projectplanningelement.plannedEndDate as plannedEndDate, T4.fullName as nameResource, project.idResource as idResource, T5.name as nameOverallProgress, T6.name as nameOrganization,project.idProject as idproject from project left join health as T1 on project.idHealth = T1.id left join client as T2 on project.idClient = T2.id left join status as T3 on project.idStatus = T3.id left join planningelement as projectplanningelement on (projectplanningelement.refId=project.id and projectplanningelement.refType='Project') left join resource as T4 on project.idResource = T4.id left join overallprogress as T5 on project.idOverallProgress = T5.id left join organization as T6 on project.idOrganization = T6.id where project.idle=0 and ( (project.id not in (0) or project.id is null ) and (project.id not in (0) or project.id is null or (project.idResource='22') ) and (project.id not in (0) or project.id is null or (project.idUser='22') ) or project.codeType='TMP' ) order by projectplanningelement.wbsSortable , project.sortOrder
2018-04-12 11:13:10.527 ***** ERROR ***** [V7.0.3] Strack trace :
2018-04-12 11:13:10.527 ***** ERROR ***** [V7.0.3] #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:722]
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.project' doesn't exist
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] For query : select * from project where id=1170
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Strack trace :
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2763]
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] #1 SqlElement->getSqlElement called at [/var/www/html/model/persistence/SqlElement.php:588]
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] #2 SqlElement->__construct called at [/var/www/html/model/ProjectMain.php:167]
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] #3 ProjectMain->__construct called at [/var/www/html/model/custom/Project.php:75]
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] #4 Project->__construct called at [/var/www/html/view/objectDetail.php:71]
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'id' for Class 'Project' : field 'id' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'name' for Class 'Project' : field 'name' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idProjectType' for Class 'Project' : field 'idProjectType' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idOrganization' for Class 'Project' : field 'idOrganization' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idCategory' for Class 'Project' : field 'idCategory' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'organizationInherited' for Class 'Project' : field 'organizationInherited' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'organizationElementary' for Class 'Project' : field 'organizationElementary' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'codeType' for Class 'Project' : field 'codeType' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idClient' for Class 'Project' : field 'idClient' not found in Database.
2018-04-12 11:13:10.542 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idContact' for Class 'Project' : field 'idContact' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'projectCode' for Class 'Project' : field 'projectCode' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'contractCode' for Class 'Project' : field 'contractCode' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idProject' for Class 'Project' : field 'idProject' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'idUser' for Class 'Project' : field 'idUser' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'creationDate' for Class 'Project' : field 'creationDate' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'lastUpdateDateTime' for Class 'Project' : field 'lastUpdateDateTime' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'color' for Class 'Project' : field 'color' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'longitude' for Class 'Project' : field 'longitude' not found in Database.
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.543 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'latitude' for Class 'Project' : field 'latitude' not found in Database.
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'description' for Class 'Project' : field 'description' not found in Database.
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2821)
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.544 ***** ERROR ***** [V7.0.3] Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2018-04-12 11:13:10.545 ***** ERROR ***** [V7.0.3] ERROR *****
2018-04-12 11:13:10.545 ***** ERROR ***** [V7.0.3] on file '/var/www/html/model/persistence/SqlElement.php' at line (2819)
2018-04-12 11:13:10.545 ***** ERROR ***** [V7.0.3] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-04-12 11:13:10.555 ***** ERROR ***** [V7.0.3] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.project' doesn't exist
2018-04-12 11:13:10.555 ***** ERROR ***** [V7.0.3] For query : select * from project where id=1170
2018-04-12 11:13:10.555 ***** ERROR ***** [V7.0.3] Strack trace :

Please Log in or Create an account to join the conversation.

More
12 Apr 2018 19:40 #2 by babynus
Replied by babynus on topic Plugin Screen Customization error while creating new field
Hi, this is very strange as :
- plugin cannot drop a table (can remove a column but cannot drop a table)
- update of table failed

2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] For query : ALTER TABLE `project` ADD `referenceCode` varchar(25);
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] Strack trace :
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:71]
2018-04-12 11:13:08.424 ***** ERROR ***** [V7.0.3] #1 runScript called at

Message "MySQL server has gone away" means connection to server is lost.
So possibly MySql server was stopped.
This may explain why all users were deconnected.

It seems someone did strange thing on DB while you were using plugin, but I really don't think it is the plugin who set the mess.
My advises :
- test on a test instance, where no-one is working
- avoid updating db structure with plugin while other users are working, result may be unexpected.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.038 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form