Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hi everybody,
When i tried to login using the credentials admin/admin the following error message appears :
Invalid login parameters
Below the log file :
2014-01-24 15:39:38 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2014-01-24 15:39:38 ** ERROR ** For query : desc user
2014-01-24 15:39:38 ** ERROR ** Strack trace :
2014-01-24 15:39:38 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1935]
2014-01-24 15:39:38 ** ERROR ** #1 SqlElement->getFormatList called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1712]
2014-01-24 15:39:38 ** ERROR ** #2 SqlElement->getDataType called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1252]
2014-01-24 15:39:38 ** ERROR ** #3 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtortoolloginCheck.php:36]
2014-01-24 15:39:38 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2014-01-24 15:39:38 ** ERROR ** For query : select * from user where user.name='admin' and user.isUser = '1'
2014-01-24 15:39:38 ** ERROR ** Strack trace :
2014-01-24 15:39:38 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1285]
2014-01-24 15:39:38 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtortoolloginCheck.php:36]
2014-01-24 15:39:38 ===== TRACE ===== Login error for user 'admin'
2014-01-24 15:41:42 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2014-01-24 15:41:42 ** ERROR ** For query : desc user
2014-01-24 15:41:42 ** ERROR ** Strack trace :
2014-01-24 15:41:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1935]
2014-01-24 15:41:42 ** ERROR ** #1 SqlElement->getFormatList called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1712]
2014-01-24 15:41:42 ** ERROR ** #2 SqlElement->getDataType called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1252]
2014-01-24 15:41:42 ** ERROR ** #3 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtortoolloginCheck.php:36]
2014-01-24 15:41:42 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2014-01-24 15:41:42 ** ERROR ** For query : select * from user where user.name='admin' and user.isUser = '1'
2014-01-24 15:41:42 ** ERROR ** Strack trace :
2014-01-24 15:41:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1285]
2014-01-24 15:41:42 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtortoolloginCheck.php:36]
2014-01-24 15:41:42 ===== TRACE ===== Login error for user 'admin'
It seems like projeqtOr points to the table "user" and not "resource".
In fact, the table "user" was renamed "resource" since the version 3.0.
Could you help me please.
Thank you.
Hin
Is it a brand new set-up or already running database ?
Which version ?
Hi,
It's a brand new set-up 4.1.2.
Is it your first connextion ?
What is the status of your database ? (empty or not ?)
Could you post here the full log file ?
You will find the Log file attached.
2014-01-24 16:43:08 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2014-01-24 16:43:08 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2014-01-24 16:43:08 ** ERROR ** Strack trace :
2014-01-24 16:43:08 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1283]
2014-01-24 16:43:08 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelParameter.php:511]
2014-01-24 16:43:08 ** ERROR ** #2 Parameter->getGlobalParameter called at [C:wampwwwprojeqtorviewlogin.php:50]
2014-01-24 16:43:08 ** ERROR ** #3 include called at [C:wampwwwprojeqtortoolprojeqtor.php:122]
2014-01-24 16:43:08 ** ERROR ** #4 require_once called at [C:wampwwwprojeqtorviewmain.php:10]
2014-01-24 16:43:08 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2014-01-24 16:43:08 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2014-01-24 16:43:08 ** ERROR ** Strack trace :
2014-01-24 16:43:08 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1283]
2014-01-24 16:43:08 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelParameter.php:511]
2014-01-24 16:43:08 ** ERROR ** #2 Parameter->getGlobalParameter called at [C:wampwwwprojeqtorviewlogin.php:194]
2014-01-24 16:43:08 ** ERROR ** #3 include called at [C:wampwwwprojeqtortoolprojeqtor.php:122]
2014-01-24 16:43:08 ** ERROR ** #4 require_once called at [C:wampwwwprojeqtorviewmain.php:10]
2014-01-24 16:43:08 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2014-01-24 16:43:08 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2014-01-24 16:43:08 ** ERROR ** Strack trace :
2014-01-24 16:43:08 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1283]
2014-01-24 16:43:08 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelParameter.php:511]
2014-01-24 16:43:08 ** ERROR ** #2 Parameter->getGlobalParameter called at [C:wampwwwprojeqtorviewlogin.php:200]
2014-01-24 16:43:08 ** ERROR ** #3 include called at [C:wampwwwprojeqtortoolprojeqtor.php:122]
2014-01-24 16:43:08 ** ERROR ** #4 require_once called at [C:wampwwwprojeqtorviewmain.php:10]
2014-01-24 16:44:42 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2014-01-24 16:44:42 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2014-01-24 16:44:42 ** ERROR ** Strack trace :
2014-01-24 16:44:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1283]
2014-01-24 16:44:42 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelParameter.php:511]
2014-01-24 16:44:42 ** ERROR ** #2 Parameter->getGlobalParameter called at [C:wampwwwprojeqtormodelUser.php:86]
2014-01-24 16:44:42 ** ERROR ** #3 User->__construct called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1416]
2014-01-24 16:44:42 ** ERROR ** #4 SqlElement->getSingleSqlElementFromCriteria called at [C:wampwwwprojeqtortoolgetHash.php:11]
2014-01-24 16:44:42 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2014-01-24 16:44:42 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2014-01-24 16:44:42 ** ERROR ** Strack trace :
2014-01-24 16:44:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1283]
2014-01-24 16:44:42 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelParameter.php:511]
2014-01-24 16:44:42 ** ERROR ** #2 Parameter->getGlobalParameter called at [C:wampwwwprojeqtormodelUser.php:86]
2014-01-24 16:44:42 ** ERROR ** #3 User->__construct called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1243]
2014-01-24 16:44:42 ** ERROR ** #4 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1424]
2014-01-24 16:44:42 ** ERROR ** #5 SqlElement->getSingleSqlElementFromCriteria called at [C:wampwwwprojeqtortoolgetHash.php:11]
2014-01-24 16:44:42 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2014-01-24 16:44:42 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2014-01-24 16:44:42 ** ERROR ** Strack trace :
2014-01-24 16:44:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1283]
2014-01-24 16:44:42 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelParameter.php:511]
2014-01-24 16:44:42 ** ERROR ** #2 Parameter->getGlobalParameter called at [C:wampwwwprojeqtormodelUser.php:86]
2014-01-24 16:44:42 ** ERROR ** #3 User->__construct called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1923]
2014-01-24 16:44:42 ** ERROR ** #4 SqlElement->getFormatList called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1710]
2014-01-24 16:44:42 ** ERROR ** #5 SqlElement->getDataType called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1250]
2014-01-24 16:44:42 ** ERROR ** #6 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1424]
2014-01-24 16:44:42 ** ERROR ** #7 SqlElement->getSingleSqlElementFromCriteria called at [C:wampwwwprojeqtortoolgetHash.php:11]
2014-01-24 16:44:42 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2014-01-24 16:44:42 ** ERROR ** For query : desc resource
2014-01-24 16:44:42 ** ERROR ** Strack trace :
2014-01-24 16:44:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1933]
2014-01-24 16:44:42 ** ERROR ** #1 SqlElement->getFormatList called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1710]
2014-01-24 16:44:42 ** ERROR ** #2 SqlElement->getDataType called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1250]
2014-01-24 16:44:42 ** ERROR ** #3 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1424]
2014-01-24 16:44:42 ** ERROR ** #4 SqlElement->getSingleSqlElementFromCriteria called at [C:wampwwwprojeqtortoolgetHash.php:11]
2014-01-24 16:44:42 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2014-01-24 16:44:42 ** ERROR ** For query : select * from resource where resource.name='admin' and resource.isUser = '1'
2014-01-24 16:44:42 ** ERROR ** Strack trace :
2014-01-24 16:44:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1283]
2014-01-24 16:44:42 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:wampwwwprojeqtormodelpersistenceSqlElement.php:1424]
2014-01-24 16:44:42 ** ERROR ** #2 SqlElement->getSingleSqlElementFromCriteria called at [C:wampwwwprojeqtortoolgetHash.php:11]
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== =====================================
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== DataBase actual Version =
2014-01-24 16:44:42 ===== TRACE ===== ProjeQtOr actual Version = V4.1.0
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== =====================================
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== VERSION V0.3.0
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== Table "accessprofile" created.
2014-01-24 16:44:42 ===== TRACE ===== 9 lines inserted into table "accessprofile".
2014-01-24 16:44:42 ===== TRACE ===== Table "accessright" created.
2014-01-24 16:44:42 ===== TRACE ===== 56 lines inserted into table "accessright".
2014-01-24 16:44:42 ===== TRACE ===== Table "accessscope" created.
2014-01-24 16:44:42 ===== TRACE ===== 4 lines inserted into table "accessscope".
2014-01-24 16:44:42 ===== TRACE ===== Table "action" created.
2014-01-24 16:44:42 ===== TRACE ===== Table "activity" created.
2014-01-24 16:44:42 ===== TRACE ===== Table "affectation" created.
2014-01-24 16:44:42 ===== TRACE ===== Table "attachement" created.
2014-01-24 16:44:42 ===== TRACE ===== Table "client" created.
2014-01-24 16:44:42 ===== TRACE ===== Table "criticality" created.
2014-01-24 16:44:42 ===== TRACE ===== 4 lines inserted into table "criticality".
2014-01-24 16:44:42 ===== TRACE ===== Table "habilitation" created.
2014-01-24 16:44:42 ===== TRACE ===== 343 lines inserted into table "habilitation".
2014-01-24 16:44:42 ===== TRACE ===== Table "history" created.
2014-01-24 16:44:42 ** ERROR ** Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
2014-01-24 16:44:42 ** ERROR ** For query : CREATE TABLE `issue` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idProject` int(12) unsigned DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`idIssueType` int(12) unsigned DEFAULT NULL,
`cause` varchar(4000) DEFAULT NULL,
`impact` varchar(4000) DEFAULT NULL,
`idPriority` int(12) unsigned DEFAULT NULL,
`creationDate` date DEFAULT NULL,
`idUser` int(12) unsigned DEFAULT NULL,
`idStatus` int(12) unsigned DEFAULT NULL,
`idResource` int(12) unsigned DEFAULT NULL,
`initialEndDate` date DEFAULT NULL,
`actualEndDate` date DEFAULT NULL,
`closureDate` date DEFAULT NULL,
`result` varchar(4000) DEFAULT NULL,
`comment` varchar(4000) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2014-01-24 16:44:42 ** ERROR ** Strack trace :
2014-01-24 16:44:42 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:42 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:42 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V0.3.0 (see above message)
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== **********************************************
2014-01-24 16:44:42 ===== TRACE =====
2014-01-24 16:44:42 ===== TRACE ===== Table "likelihood" created.
2014-01-24 16:44:42 ===== TRACE ===== 3 lines inserted into table "likelihood".
2014-01-24 16:44:42 ===== TRACE ===== Table "menu" created.
2014-01-24 16:44:42 ===== TRACE ===== 45 lines inserted into table "menu".
2014-01-24 16:44:42 ===== TRACE ===== Table "message" created.
2014-01-24 16:44:42 ===== TRACE ===== 1 lines inserted into table "message".
2014-01-24 16:44:42 ===== TRACE ===== Table "milestone" created.
2014-01-24 16:44:42 ===== TRACE ===== Table "note" created.
2014-01-24 16:44:42 ===== TRACE ===== Table "parameter" created.
2014-01-24 16:44:42 ===== TRACE ===== 17 lines inserted into table "parameter".
2014-01-24 16:44:42 ===== TRACE ===== Table "planningelement" created.
2014-01-24 16:44:42 ===== TRACE ===== Index "planningelementTopId" created.
2014-01-24 16:44:42 ===== TRACE ===== Index "planningelementRef" created.
2014-01-24 16:44:43 ===== TRACE ===== Index "planningelementTopRef" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "priority" created.
2014-01-24 16:44:43 ===== TRACE ===== 4 lines inserted into table "priority".
2014-01-24 16:44:43 ===== TRACE ===== Table "profile" created.
2014-01-24 16:44:43 ===== TRACE ===== 7 lines inserted into table "profile".
2014-01-24 16:44:43 ===== TRACE ===== Table "project" created.
2014-01-24 16:44:43 ** ERROR ** Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
2014-01-24 16:44:43 ** ERROR ** For query : CREATE TABLE `risk` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idProject` int(12) unsigned DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`idRiskType` int(12) unsigned DEFAULT NULL,
`cause` varchar(4000) DEFAULT NULL,
`impact` varchar(4000) DEFAULT NULL,
`idSeverity` int(12) unsigned DEFAULT NULL,
`idLikelihood` int(12) unsigned DEFAULT NULL,
`idCriticality` int(12) unsigned DEFAULT NULL,
`creationDate` date DEFAULT NULL,
`idUser` int(12) unsigned DEFAULT NULL,
`idStatus` int(12) unsigned DEFAULT NULL,
`idResource` int(12) unsigned DEFAULT NULL,
`initialEndDate` date DEFAULT NULL,
`actualEndDate` date DEFAULT NULL,
`closureDate` date DEFAULT NULL,
`result` varchar(4000) DEFAULT NULL,
`comment` varchar(4000) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2014-01-24 16:44:43 ** ERROR ** Strack trace :
2014-01-24 16:44:43 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:43 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:43 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V0.3.0 (see above message)
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== *******************************************
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== Table "severity" created.
2014-01-24 16:44:43 ===== TRACE ===== 3 lines inserted into table "severity".
2014-01-24 16:44:43 ===== TRACE ===== Table "sla" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "status" created.
2014-01-24 16:44:43 ===== TRACE ===== 12 lines inserted into table "status".
2014-01-24 16:44:43 ===== TRACE ===== Table "task" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "ticket" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "type" created.
2014-01-24 16:44:43 ===== TRACE ===== 24 lines inserted into table "type".
2014-01-24 16:44:43 ===== TRACE ===== Table "urgency" created.
2014-01-24 16:44:43 ===== TRACE ===== 3 lines inserted into table "urgency".
2014-01-24 16:44:43 ===== TRACE ===== Table "resource" created.
2014-01-24 16:44:43 ===== TRACE ===== 2 lines inserted into table "resource".
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:43 ===== TRACE ===== WITH 2 ERRORS
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== =====================================
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== VERSION V0.4.0
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== Table "resource" altered.
2014-01-24 16:44:43 ===== TRACE ===== Table "team" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "menu" truncated.
2014-01-24 16:44:43 ===== TRACE ===== 46 lines inserted into table "menu".
2014-01-24 16:44:43 ===== TRACE ===== Table "accessright" truncated.
2014-01-24 16:44:43 ===== TRACE ===== 63 lines inserted into table "accessright".
2014-01-24 16:44:43 ===== TRACE ===== Table "habilitation" truncated.
2014-01-24 16:44:43 ===== TRACE ===== 350 lines inserted into table "habilitation".
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:43 ===== TRACE ===== WITH NO ERROR
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== =====================================
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== VERSION V0.5.0
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== Table "link" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "linkable" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "activity" altered.
2014-01-24 16:44:43 ===== TRACE ===== Table "ticket" altered.
2014-01-24 16:44:43 ===== TRACE ===== Table "milestone" altered.
2014-01-24 16:44:43 ===== TRACE ===== 3 lines inserted into table "linkable".
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:43 ===== TRACE ===== WITH NO ERROR
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== =====================================
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== VERSION V0.6.0
2014-01-24 16:44:43 ===== TRACE =====
2014-01-24 16:44:43 ===== TRACE ===== Table "assignment" created.
2014-01-24 16:44:43 ===== TRACE ===== Table "task" dropped.
2014-01-24 16:44:43 ===== TRACE ===== Table "planningelement" altered.
2014-01-24 16:44:43 ===== TRACE ===== 1 lines inserted into table "type".
2014-01-24 16:44:43 ===== TRACE ===== Table "project" altered.
2014-01-24 16:44:43 ===== TRACE ===== Index "accessrightProfile" created.
2014-01-24 16:44:43 ===== TRACE ===== Index "" created.
2014-01-24 16:44:43 ===== TRACE ===== Index "actionProject" created.
2014-01-24 16:44:43 ===== TRACE ===== Index "actionUser" created.
2014-01-24 16:44:43 ===== TRACE ===== Index "actionResource" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "actionStatus" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "activityProject" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "activityUser" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "activityResource" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "activityStatus" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "activityType" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "activityActivity" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "affectationProject" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "affectationResource" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "assignmentProject" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "assignmentResource" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "assignmentRef" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "attachementUser" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "attachementRef" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "habilitationProfile" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "habilitationMenu" created.
2014-01-24 16:44:44 ===== TRACE ===== Index "historyUser" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "historyRef" created.
2014-01-24 16:44:45 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:45 ** ERROR ** For query : CREATE INDEX issueProject ON `issue` (`idProject`);
2014-01-24 16:44:45 ** ERROR ** Strack trace :
2014-01-24 16:44:45 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:45 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:45 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== *******************************************
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:45 ** ERROR ** For query : CREATE INDEX issueUser ON `issue` (`idUser`);
2014-01-24 16:44:45 ** ERROR ** Strack trace :
2014-01-24 16:44:45 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:45 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:45 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== *******************************************
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:45 ** ERROR ** For query : CREATE INDEX issueResource ON `issue` (`idResource`);
2014-01-24 16:44:45 ** ERROR ** Strack trace :
2014-01-24 16:44:45 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:45 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:45 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== *******************************************
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:45 ** ERROR ** For query : CREATE INDEX issueStatus ON `issue` (`idStatus`);
2014-01-24 16:44:45 ** ERROR ** Strack trace :
2014-01-24 16:44:45 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:45 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:45 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== *******************************************
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:45 ** ERROR ** For query : CREATE INDEX issueType ON `issue` (`idIssueType`);
2014-01-24 16:44:45 ** ERROR ** Strack trace :
2014-01-24 16:44:45 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:45 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:45 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== *******************************************
2014-01-24 16:44:45 ===== TRACE =====
2014-01-24 16:44:45 ===== TRACE ===== Index "linkRef1" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "linkRef2" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "menuMenu" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "messageProject" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "messageUser" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "messageType" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "messageProfile" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "milestoneProject" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "milestoneUser" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "milestoneResource" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "milestoneStatus" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "milestoneType" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "milestoneActivity" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "noteUser" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "noteRef" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "parameterProject" created.
2014-01-24 16:44:45 ===== TRACE ===== Index "parameterUser" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "planningelementProject" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "planningelementWbsSortable" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "projectProject" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "projectClient" created.
2014-01-24 16:44:46 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:46 ** ERROR ** For query : CREATE INDEX riskProject ON `risk` (`idProject`);
2014-01-24 16:44:46 ** ERROR ** Strack trace :
2014-01-24 16:44:46 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:46 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:46 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== *******************************************
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:46 ** ERROR ** For query : CREATE INDEX riskUser ON `risk` (`idUser`);
2014-01-24 16:44:46 ** ERROR ** Strack trace :
2014-01-24 16:44:46 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:46 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:46 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== *******************************************
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:46 ** ERROR ** For query : CREATE INDEX riskResource ON `risk` (`idResource`);
2014-01-24 16:44:46 ** ERROR ** Strack trace :
2014-01-24 16:44:46 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:46 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:46 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== *******************************************
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:46 ** ERROR ** For query : CREATE INDEX riskStatus ON `risk` (`idStatus`);
2014-01-24 16:44:46 ** ERROR ** Strack trace :
2014-01-24 16:44:46 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:46 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:46 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== Error # 9 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== *******************************************
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:46 ** ERROR ** For query : CREATE INDEX riskType ON `risk` (`idRiskType`);
2014-01-24 16:44:46 ** ERROR ** Strack trace :
2014-01-24 16:44:46 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:46 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:46 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== Error # 10 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== *******************************************
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== Index "ticketProject" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "ticketUser" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "ticketResource" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "ticketStatus" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "ticketType" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "ticketActivity" created.
2014-01-24 16:44:46 ===== TRACE ===== Table "work" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "workDay" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "workWeek" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "workMonth" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "workYear" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "workRef" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "workResource" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "workAssignment" created.
2014-01-24 16:44:46 ===== TRACE ===== 1 lines updated into table "menu".
2014-01-24 16:44:46 ===== TRACE ===== 7 lines updated into table "habilitation".
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:46 ===== TRACE ===== WITH 10 ERRORS
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== =====================================
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== VERSION V0.7.0
2014-01-24 16:44:46 ===== TRACE =====
2014-01-24 16:44:46 ===== TRACE ===== Table "plannedwork" created.
2014-01-24 16:44:46 ===== TRACE ===== Index "plannedworkDay" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "plannedworkWeek" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "plannedworkMonth" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "plannedworkYear" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "plannedworkRef" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "plannedworkResource" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "plannedworkAssignment" created.
2014-01-24 16:44:47 ===== TRACE ===== Table "assignment" altered.
2014-01-24 16:44:47 ===== TRACE ===== Table "dependency" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "dependencyPredecessorRef" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "dependencyPredecessorId" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "dependencySuccessorRef" created.
2014-01-24 16:44:47 ===== TRACE ===== Index "dependencySuccessorId" created.
2014-01-24 16:44:47 ===== TRACE ===== Table "dependable" created.
2014-01-24 16:44:47 ===== TRACE ===== 3 lines inserted into table "dependable".
2014-01-24 16:44:47 ===== TRACE ===== Table "planningelement" altered.
2014-01-24 16:44:47 ===== TRACE ===== Index "planningElementDependencyLevel" created.
2014-01-24 16:44:47 ===== TRACE ===== 0 lines updated into table "planningelement".
2014-01-24 16:44:47 ===== TRACE ===== Table "ticket" altered.
2014-01-24 16:44:47 ===== TRACE ===== Table "criticality" truncated.
2014-01-24 16:44:47 ===== TRACE ===== 4 lines inserted into table "criticality".
2014-01-24 16:44:47 ===== TRACE ===== Table "likelihood" truncated.
2014-01-24 16:44:47 ===== TRACE ===== 3 lines inserted into table "likelihood".
2014-01-24 16:44:47 ===== TRACE ===== Table "priority" truncated.
2014-01-24 16:44:47 ===== TRACE ===== 4 lines inserted into table "priority".
2014-01-24 16:44:47 ===== TRACE ===== Table "severity" truncated.
2014-01-24 16:44:47 ===== TRACE ===== 3 lines inserted into table "severity".
2014-01-24 16:44:47 ===== TRACE ===== Table "urgency" truncated.
2014-01-24 16:44:47 ===== TRACE ===== 3 lines inserted into table "urgency".
2014-01-24 16:44:47 ===== TRACE ===== 1 lines inserted into table "menu".
2014-01-24 16:44:47 ===== TRACE ===== 7 lines inserted into table "habilitation".
2014-01-24 16:44:47 ===== TRACE =====
2014-01-24 16:44:47 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:47 ===== TRACE ===== WITH NO ERROR
2014-01-24 16:44:47 ===== TRACE =====
2014-01-24 16:44:47 ===== TRACE ===== =====================================
2014-01-24 16:44:47 ===== TRACE =====
2014-01-24 16:44:47 ===== TRACE ===== VERSION V0.8.0
2014-01-24 16:44:47 ===== TRACE =====
2014-01-24 16:44:47 ===== TRACE ===== Table "planningelement" altered.
2014-01-24 16:44:47 ===== TRACE ===== Table "planningmode" created.
2014-01-24 16:44:48 ===== TRACE ===== 6 lines inserted into table "planningmode".
2014-01-24 16:44:48 ===== TRACE ===== Table "resource" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "ticket" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "ticket" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "activity" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "milestone" altered.
2014-01-24 16:44:48 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:48 ** ERROR ** For query : ALTER TABLE `risk` ADD done int(1) unsigned DEFAULT '0',
ADD `doneDate` date DEFAULT NULL;
2014-01-24 16:44:48 ** ERROR ** Strack trace :
2014-01-24 16:44:48 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:48 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:48 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V0.8.0 (see above message)
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== *******************************************
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:48 ** ERROR ** For query : ALTER TABLE `risk` CHANGE `closureDate` `idleDate` date DEFAULT NULL;
2014-01-24 16:44:48 ** ERROR ** Strack trace :
2014-01-24 16:44:48 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:48 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:48 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V0.8.0 (see above message)
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== *******************************************
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Table "action" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "action" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "project" altered.
2014-01-24 16:44:48 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:48 ** ERROR ** For query : ALTER TABLE `issue` ADD done int(1) unsigned DEFAULT '0',
ADD `doneDate` date DEFAULT NULL;
2014-01-24 16:44:48 ** ERROR ** Strack trace :
2014-01-24 16:44:48 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:48 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:48 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V0.8.0 (see above message)
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== *******************************************
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:48 ** ERROR ** For query : ALTER TABLE `issue` CHANGE `closureDate` `idleDate` date DEFAULT NULL;
2014-01-24 16:44:48 ** ERROR ** Strack trace :
2014-01-24 16:44:48 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:48 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:48 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V0.8.0 (see above message)
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== *******************************************
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Table "status" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "planningelement" altered.
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:48 ===== TRACE ===== WITH 4 ERRORS
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== =====================================
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== VERSION V0.9.0
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Table "workflow" dropped.
2014-01-24 16:44:48 ===== TRACE ===== Table "workflow" created.
2014-01-24 16:44:48 ===== TRACE ===== Table "workflowstatus" dropped.
2014-01-24 16:44:48 ===== TRACE ===== Table "workflowstatus" created.
2014-01-24 16:44:48 ===== TRACE ===== 0 lines deleted from table "menu".
2014-01-24 16:44:48 ===== TRACE ===== 2 lines inserted into table "menu".
2014-01-24 16:44:48 ===== TRACE ===== 2 lines inserted into table "habilitation".
2014-01-24 16:44:48 ===== TRACE ===== Table "type" altered.
2014-01-24 16:44:48 ===== TRACE ===== Table "action" altered.
2014-01-24 16:44:48 ===== TRACE ===== 3 lines inserted into table "type".
2014-01-24 16:44:48 ===== TRACE ===== 4 lines inserted into table "workflow".
2014-01-24 16:44:48 ===== TRACE ===== 503 lines inserted into table "workflowstatus".
2014-01-24 16:44:48 ===== TRACE ===== 28 lines updated into table "type".
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:48 ===== TRACE ===== WITH NO ERROR
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== =====================================
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== VERSION V1.0.0
2014-01-24 16:44:48 ===== TRACE =====
2014-01-24 16:44:48 ===== TRACE ===== Table "action" altered.
2014-01-24 16:44:49 ===== TRACE ===== Table "assignment" altered.
2014-01-24 16:44:49 ===== TRACE ===== Table "filter" created.
2014-01-24 16:44:49 ===== TRACE ===== Table "filtercriteria" created.
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:49 ===== TRACE ===== WITH NO ERROR
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== =====================================
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== VERSION V1.1.0
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== Table "report" created.
2014-01-24 16:44:49 ===== TRACE ===== Table "reportparameter" created.
2014-01-24 16:44:49 ===== TRACE ===== Table "reportcategory" created.
2014-01-24 16:44:49 ===== TRACE ===== 1 lines inserted into table "menu".
2014-01-24 16:44:49 ===== TRACE ===== 3 lines inserted into table "habilitation".
2014-01-24 16:44:49 ===== TRACE ===== 2 lines inserted into table "reportcategory".
2014-01-24 16:44:49 ===== TRACE ===== 6 lines inserted into table "report".
2014-01-24 16:44:49 ===== TRACE ===== 6 lines inserted into table "reportparameter".
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:49 ===== TRACE ===== WITH NO ERROR
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== =====================================
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== VERSION V1.2.0
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== Table "reportparameter" altered.
2014-01-24 16:44:49 ===== TRACE ===== 1 lines inserted into table "report".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines updated into table "reportparameter".
2014-01-24 16:44:49 ===== TRACE ===== 4 lines updated into table "reportparameter".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines updated into table "reportparameter".
2014-01-24 16:44:49 ===== TRACE ===== 4 lines inserted into table "reportparameter".
2014-01-24 16:44:49 ===== TRACE ===== Table "decision" created.
2014-01-24 16:44:49 ===== TRACE ===== Table "question" created.
2014-01-24 16:44:49 ===== TRACE ===== Table "meeting" created.
2014-01-24 16:44:49 ===== TRACE ===== 1 lines updated into table "menu".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines updated into table "menu".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines updated into table "menu".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines updated into table "menu".
2014-01-24 16:44:49 ===== TRACE ===== 8 lines inserted into table "menu".
2014-01-24 16:44:49 ===== TRACE ===== 28 lines inserted into table "accessright".
2014-01-24 16:44:49 ===== TRACE ===== 56 lines inserted into table "habilitation".
2014-01-24 16:44:49 ===== TRACE ===== 7 lines updated into table "habilitation".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines updated into table "habilitation".
2014-01-24 16:44:49 ===== TRACE ===== 9 lines inserted into table "type".
2014-01-24 16:44:49 ===== TRACE ===== 3 lines inserted into table "linkable".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines inserted into table "status".
2014-01-24 16:44:49 ===== TRACE ===== 3 lines inserted into table "workflow".
2014-01-24 16:44:49 ===== TRACE ===== 21 lines deleted from table "workflowstatus".
2014-01-24 16:44:49 ===== TRACE ===== 144 lines inserted into table "workflowstatus".
2014-01-24 16:44:49 ===== TRACE ===== Table "mailable" created.
2014-01-24 16:44:49 ===== TRACE ===== 9 lines inserted into table "mailable".
2014-01-24 16:44:49 ===== TRACE ===== Table "statusmail" created.
2014-01-24 16:44:49 ===== TRACE ===== 63 lines inserted into table "statusmail".
2014-01-24 16:44:49 ===== TRACE ===== Table "mail" created.
2014-01-24 16:44:49 ===== TRACE ===== Table "assignment" altered.
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:49 ===== TRACE ===== WITH NO ERROR
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== =====================================
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== VERSION V1.3.0
2014-01-24 16:44:49 ===== TRACE =====
2014-01-24 16:44:49 ===== TRACE ===== 1 lines inserted into table "report".
2014-01-24 16:44:49 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2014-01-24 16:44:49 ===== TRACE ===== Index "actionType" created.
2014-01-24 16:44:49 ===== TRACE ===== Index "decisionProject" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "decisionType" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "decisionUser" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "decisionResource" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "decisionStatus" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "filterUser" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "filtercriteriaFilter" created.
2014-01-24 16:44:50 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:50 ** ERROR ** For query : CREATE INDEX issuePriority ON `issue` (idPriority);
2014-01-24 16:44:50 ** ERROR ** Strack trace :
2014-01-24 16:44:50 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:50 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:50 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:50 ===== TRACE =====
2014-01-24 16:44:50 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:50 ===== TRACE =====
2014-01-24 16:44:50 ===== TRACE ===== *******************************************
2014-01-24 16:44:50 ===== TRACE =====
2014-01-24 16:44:50 ===== TRACE ===== Index "mailProject" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "mailUser" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "mailRef" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "mailStatus" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "meetingProject" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "meetingType" created.
2014-01-24 16:44:50 ===== TRACE ===== Index "meetingUser" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "meetingResource" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "meetingStatus" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "planningelementPlanningMode" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "projectUser" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "questionProject" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "questionType" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "questionUser" created.
2014-01-24 16:44:51 ===== TRACE ===== Index "questionResource" created.
2014-01-24 16:44:52 ===== TRACE ===== Index "questionStatus" created.
2014-01-24 16:44:52 ===== TRACE ===== Index "reportReportCategory" created.
2014-01-24 16:44:52 ===== TRACE ===== Index "reportparameterReport" created.
2014-01-24 16:44:52 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:52 ** ERROR ** For query : CREATE INDEX riskSeverity ON `risk` (idSeverity);
2014-01-24 16:44:52 ** ERROR ** Strack trace :
2014-01-24 16:44:52 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:52 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:52 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ===== TRACE ===== *******************************************
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:52 ** ERROR ** For query : CREATE INDEX riskLikelihood ON `risk` (idLikelihood);
2014-01-24 16:44:52 ** ERROR ** Strack trace :
2014-01-24 16:44:52 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:52 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:52 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ===== TRACE ===== *******************************************
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:52 ** ERROR ** For query : CREATE INDEX riskCriticality ON `risk` (idCriticality);
2014-01-24 16:44:52 ** ERROR ** Strack trace :
2014-01-24 16:44:52 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:52 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:52 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ===== TRACE ===== *******************************************
2014-01-24 16:44:52 ===== TRACE =====
2014-01-24 16:44:52 ===== TRACE ===== Index "statusmailStatus" created.
2014-01-24 16:44:52 ===== TRACE ===== Index "statusmailMailable" created.
2014-01-24 16:44:52 ===== TRACE ===== Index "ticketUrgency" created.
2014-01-24 16:44:52 ===== TRACE ===== Index "ticketPriority" created.
2014-01-24 16:44:52 ===== TRACE ===== Index "ticketCriticality" created.
2014-01-24 16:44:53 ===== TRACE ===== Index "typeScope" created.
2014-01-24 16:44:53 ===== TRACE ===== Index "userProfile" created.
2014-01-24 16:44:53 ===== TRACE ===== Index "userTeam" created.
2014-01-24 16:44:53 ===== TRACE ===== Index "workflowstatusProfile" created.
2014-01-24 16:44:53 ===== TRACE ===== Index "workflowstatusWorkflow" created.
2014-01-24 16:44:53 ===== TRACE ===== Index "workflowstatusStatusFrom" created.
2014-01-24 16:44:53 ===== TRACE ===== Index "workflowstatusStatusTo" created.
2014-01-24 16:44:53 ===== TRACE ===== 1 lines inserted into table "reportcategory".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines inserted into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 5 lines inserted into table "reportparameter".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines inserted into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 4 lines inserted into table "reportparameter".
2014-01-24 16:44:53 ===== TRACE ===== 6 lines inserted into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 24 lines inserted into table "reportparameter".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines updated into table "priority".
2014-01-24 16:44:53 ===== TRACE ===== 2 lines inserted into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 6 lines inserted into table "reportparameter".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines updated into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines updated into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines updated into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines updated into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 1 lines updated into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 2 lines inserted into table "reportcategory".
2014-01-24 16:44:53 ===== TRACE ===== 7 lines inserted into table "report".
2014-01-24 16:44:53 ===== TRACE ===== 11 lines inserted into table "reportparameter".
2014-01-24 16:44:53 ===== TRACE ===== Table "type" altered.
2014-01-24 16:44:53 ===== TRACE ===== 37 lines updated into table "".
2014-01-24 16:44:53 ===== TRACE ===== Table "status" altered.
2014-01-24 16:44:54 ===== TRACE ===== 9 lines updated into table "status".
2014-01-24 16:44:54 ===== TRACE ===== 6 lines updated into table "status".
2014-01-24 16:44:54 ===== TRACE ===== Table "workflow" altered.
2014-01-24 16:44:54 ===== TRACE ===== Table "type" altered.
2014-01-24 16:44:54 ===== TRACE ===== 37 lines updated into table "type".
2014-01-24 16:44:54 ===== TRACE ===== Table "ticket" altered.
2014-01-24 16:44:54 ===== TRACE ===== Table "activity" altered.
2014-01-24 16:44:54 ===== TRACE ===== Table "milestone" altered.
2014-01-24 16:44:54 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:54 ** ERROR ** For query : ALTER TABLE `risk` ADD `handled` int(1) unsigned DEFAULT '0',
ADD `handledDate` date DEFAULT NULL;
2014-01-24 16:44:54 ** ERROR ** Strack trace :
2014-01-24 16:44:54 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:54 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:54 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== *******************************************
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Table "action" altered.
2014-01-24 16:44:54 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:54 ** ERROR ** For query : ALTER TABLE `issue` ADD `handled` int(1) unsigned DEFAULT '0',
ADD `handledDate` date DEFAULT NULL;
2014-01-24 16:44:54 ** ERROR ** Strack trace :
2014-01-24 16:44:54 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:54 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:54 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== *******************************************
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Table "question" altered.
2014-01-24 16:44:54 ===== TRACE ===== Table "meeting" altered.
2014-01-24 16:44:54 ===== TRACE ===== 0 lines updated into table "ticket".
2014-01-24 16:44:54 ===== TRACE ===== 0 lines updated into table "activity".
2014-01-24 16:44:54 ===== TRACE ===== 0 lines updated into table "milestone".
2014-01-24 16:44:54 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2014-01-24 16:44:54 ** ERROR ** For query : UPDATE `risk` set handled=1
where done=1;
2014-01-24 16:44:54 ** ERROR ** Strack trace :
2014-01-24 16:44:54 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:54 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:54 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== *******************************************
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== 0 lines updated into table "action".
2014-01-24 16:44:54 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:54 ** ERROR ** For query : UPDATE `issue` set handled=1
where done=1;
2014-01-24 16:44:54 ** ERROR ** Strack trace :
2014-01-24 16:44:54 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:54 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:54 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V1.3.0 (see above message)
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== *******************************************
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== 0 lines updated into table "question".
2014-01-24 16:44:54 ===== TRACE ===== 0 lines updated into table "ticket".
2014-01-24 16:44:54 ===== TRACE ===== Table "habilitationreport" created.
2014-01-24 16:44:54 ===== TRACE ===== Index "habilitationReportProfile" created.
2014-01-24 16:44:54 ===== TRACE ===== Index "habilitationReportReport" created.
2014-01-24 16:44:54 ===== TRACE ===== Table "habilitationother" created.
2014-01-24 16:44:54 ===== TRACE ===== 2 lines inserted into table "menu".
2014-01-24 16:44:54 ===== TRACE ===== 12 lines inserted into table "habilitation".
2014-01-24 16:44:54 ===== TRACE ===== 71 lines inserted into table "habilitationreport".
2014-01-24 16:44:54 ===== TRACE ===== 25 lines updated into table "report".
2014-01-24 16:44:54 ===== TRACE ===== 7 lines inserted into table "habilitationother".
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:54 ===== TRACE ===== WITH 8 ERRORS
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== =====================================
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== VERSION V1.4.0
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Table "planningmode" altered.
2014-01-24 16:44:54 ===== TRACE ===== 2 lines inserted into table "planningmode".
2014-01-24 16:44:54 ===== TRACE ===== 0 lines updated into table "planningelement".
2014-01-24 16:44:54 ===== TRACE ===== Table "resource" altered.
2014-01-24 16:44:54 ===== TRACE ===== 1 lines inserted into table "menu".
2014-01-24 16:44:54 ===== TRACE ===== 1 lines inserted into table "habilitation".
2014-01-24 16:44:54 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2014-01-24 16:44:54 ** ERROR ** For query : ALTER TABLE `issue` ADD idCriticality int(12) unsigned DEFAULT null;
2014-01-24 16:44:54 ** ERROR ** Strack trace :
2014-01-24 16:44:54 ** ERROR ** #0 Sql->query called at [C:wampwwwprojeqtordbmaintenance.php:363]
2014-01-24 16:44:54 ** ERROR ** #1 runScript called at [C:wampwwwprojeqtordbmaintenance.php:101]
2014-01-24 16:44:54 ** ERROR ** #2 include called at [C:wampwwwprojeqtortoolloginCheck.php:27]
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V1.4.0 (see above message)
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== **********************************************
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== DATABASE UPDATED
2014-01-24 16:44:54 ===== TRACE ===== WITH 1 ERROR
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== =====================================
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== VERSION V1.5.0
2014-01-24 16:44:54 ===== TRACE =====
2014-01-24 16:44:54 ===== TRACE ===== Table "affectation" altered.
2014-01-24 16:44:54 ===== TRACE ===== Table "assignment" altered.
2014-01-24 16:44:55 ===== TRACE ===== Table "work" altered.
2014-01-24 16:44:55 ===== TRACE ===== Table "plannedwork" altered.
2014-01-24 16:44:55 ===== TRACE ===== Table "resource" altered.
2014-01-24 16:44:55 ===== TRACE ===== Table "planningelement" altered.
2014-01-24 16:44:55 ===== TRACE ===== 0 lines updated into table "type".
2014-01-24 16:44:55 ===== TRACE ===== Table "resourcecost" created.
2014-01-24 16:44:55 ===== TRACE ===== Table "role" created.
2014-01-24 16:44:55 ===== TRACE ===== 1 lines inserted into table "menu".
2014-01-24 16:44:55 ===== TRACE ===== 1 lines inserted into table "habilitation".
2014-01-24 16:44:55 ===== TRACE ===== 5 lines inserted into table "role".
2014-01-24 16:44:55 ===== TRACE ===== Table "visibilityscope" created.
2014-01-24 16:44:55 ===== TRACE ===== 3 lines inserted into table "visibilityscope".
2014-01-24 16:44:55 ===== TRACE ===== 14 lines inserted into table "habilitationother".
2014-01-24 16:44:55 ===== TRACE ===== Table "ticket" altered.
2014-01-24 16:44:55 ===== TRACE ===== 1 lines inserted into table "reportcategory".
2014-01-24 16:44:55 ===== TRACE ===== 2 lines inserted into table "report".
2014-01-24 16:44:55 ===== TRACE ===== 2 lines inserted into table "reportparameter".
2014-01-24 16:44:55 ===== TRACE ===== 6 lines inserted into table "habilitationreport".
2014-01-24 16:44:55 ===== TRACE ===== 3 lines inserted into table "report".
2014-01-24 16:44:55 ===== TRACE ===== 3 lines inserted into table "reportparameter".
2014-01-24 16:44:55 ===== TRACE ===== 9 lines inser
Hi,
You had 2 issues when creating talbes Issue and Risk.
Other issues are link to the faul of these creations.
But these should not be blocking.
Could you try :
- check content of table "resource" (it replaces table user)
- clean log file, try to connect with admin.admin, snd new log file.
Thank you ! 🙂
It worked when i change the parameters in the table "parameter" :
id idUser idProject parameterCode parameterValue
1 NULL NULL dbVersion V4.1.2
Instead of :
id idUser idProject parameterCode parameterValue
1 NULL 0 dbVersion V4.1.2
Hi everybody,
I have the same problem when trying to authenticate on the Login form:
Invalid login parameters
Here is the content of my log file:
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'loginTry' for Class 'User' : field 'loginTry' not found in Database.
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'isLdap' for Class 'User' : field 'isLdap' not found in Database.
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'isContact' for Class 'User' : field 'isContact' not found in Database.
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'initials' for Class 'User' : field 'initials' not found in Database.
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'salt' for Class 'User' : field 'salt' not found in Database.
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'crypto' for Class 'User' : field 'crypto' not found in Database.
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'cookieHash' for Class 'User' : field 'cookieHash' not found in Database.
2014-03-16 02:06:00 ** ERROR ** Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'loginTry' for Class 'User' : field 'loginTry' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'isLdap' for Class 'User' : field 'isLdap' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'isContact' for Class 'User' : field 'isContact' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'initials' for Class 'User' : field 'initials' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'salt' for Class 'User' : field 'salt' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'crypto' for Class 'User' : field 'crypto' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'cookieHash' for Class 'User' : field 'cookieHash' not found in Database.
2014-03-16 02:06:01 ** ERROR ** Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found in Database.
2014-03-16 02:06:01 ===== TRACE ===== Login error for user 'admin'
I could find nowhere in projeqtor database the mentioned fields.
I installed Wampserver 2.4 with PHP 2.4.4 and MySQL 5.6.12 on my PC.
Is it the right version of Web server required?
Hi,
I think your PHP version is not 2.4.4, as current deployed version are 5.x, I guess it is 5.4.4.
I think you had an issue when upgrading database.
Could you retrieve the log file of database upgrade and post it here ?
The mentioned fileds should exist in table 'resource'.
To be correct this is my first installation (not an upgrade) of ‘Projeqtor’ (V4.2.1) and the web server installed is Wampserver 2.4 with:
• Apache 2.4.4
• PHP 5.4.16 (you guessed it!)
• MySQL 5.6.12
The structure of table ‘resource’ in ‘projeqtor’ database includes the following fields:
1) Id
2) Name
3) fullName
4) email
5) description
6) password
7) idProfile
8) isResource
9) isUser
10) locked
11) idle
12) phone
13) mobile
14) fax
15) idTeam
So, what’s wrong with table 'resource'?
Your Resource table is not as expected on a V4.2.1 version.
It seems some database update failed.
(for information, set-up of database is incremental and reproduces step by step upgrade from first to latest version)
Could you please try and retrieve install logs ?
Or maybe you can try another install (on new database) and post logs here.
To re-run the set-up is easy : just delete /tool/parametersLocaton.php file.
My first idea is that install stopped before end of process.
Maybe your php configuration refuses the set_time_limit at runtime, and then you got a timeout.
The first option of upgrading from the first version to the last version seems to be time-consuming if taking into account the fact that ‘Projector’ was issued in all 91 versions. I could try this alternative later at last resort.
So, I selected your recommended second option: re-run the set-up after deleting /tool/parametersLocaton.php file. But, after executing the setup procedure no log file was generated in C:wampwwwprojeqtorfileslogs!!
Also with Wampserver I don’t know where to set the parameter set_time_limit at runtime.
Should I also look at log files in C:wamplogs?


