I got this when logging in for first time to projeqtor 5.1.2., should I do something? or i can keep working normally?
this is the logo file.
2015-11-11 14:45:36.740 ===== TRACE =====
2015-11-11 14:45:36.741 ===== TRACE ===== =====================================
2015-11-11 14:45:36.741 ===== TRACE =====
2015-11-11 14:45:36.741 ===== TRACE ===== DataBase actual Version = V5.1.0
2015-11-11 14:45:36.741 ===== TRACE ===== ProjeQtOr actual Version = V5.1.2
2015-11-11 14:45:36.741 ===== TRACE =====
2015-11-11 14:45:36.742 ===== TRACE ===== =====================================
2015-11-11 14:45:36.742 ===== TRACE =====
2015-11-11 14:45:36.742 ===== TRACE ===== VERSION V5.1.1
2015-11-11 14:45:36.742 ===== TRACE =====
2015-11-11 14:45:36.750 ===== TRACE ===== 0 lines deleted from table "plannedwork".
2015-11-11 14:45:36.807 ===== TRACE ===== 66 lines deleted from table "columnselector".
2015-11-11 14:45:36.809 ** ERROR ** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '21' for key 'PRIMARY'
2015-11-11 14:45:36.809 ** ERROR ** For query : INSERT INTO `planningmode` (`id`, `applyTo`, `name`, `code`, `sortOrder`, `idle`, `mandatoryStartDate`, `mandatoryEndDate`) VALUES
(21, 'TestSession', 'PlanningModeSTART', 'START', 130, 0 , 1, 0);
2015-11-11 14:45:36.809 ** ERROR ** Strack trace :
2015-11-11 14:45:36.809 ** ERROR ** #0 Sql->query called at [/Applications/MAMP/htdocs/projeqtor5/db/maintenanceFunctions.php:71]
2015-11-11 14:45:36.809 ** ERROR ** #1 runScript called at [/Applications/MAMP/htdocs/projeqtor5/db/maintenance.php:99]
2015-11-11 14:45:36.809 ** ERROR ** #2 include called at [/Applications/MAMP/htdocs/projeqtor5/tool/loginCheck.php:117]
2015-11-11 14:45:36.810 ===== TRACE =====
2015-11-11 14:45:36.810 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V5.1.1 (see above message)
2015-11-11 14:45:36.810 ===== TRACE =====
2015-11-11 14:45:36.810 ===== TRACE ===== *************************************************
2015-11-11 14:45:36.810 ===== TRACE =====
2015-11-11 14:45:36.810 ===== TRACE =====
2015-11-11 14:45:36.811 ===== TRACE ===== DATABASE UPDATED
2015-11-11 14:45:36.811 ===== TRACE ===== WITH 1 ERROR
2015-11-11 14:45:36.811 ===== TRACE =====
2015-11-11 14:45:37.086 ===== TRACE ===== =====================================
2015-11-11 14:45:37.086 ===== TRACE =====
2015-11-11 14:45:37.086 ===== TRACE ===== 1 ERRORS DURING UPDATE TO VERSION V5.1.2
2015-11-11 14:45:37.086 ===== TRACE =====
2015-11-11 14:45:37.087 ===== TRACE ===== =====================================
2015-11-11 14:45:37.087 ===== TRACE =====
2015-11-11 14:45:43.958 ===== TRACE ===== NEW CONNECTED USER 'jbarrero'
Hi,
Could you please post content of table "planningmode" ?
As text like this is ok?
-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: localhost:8889
-- Generation Time: Nov 11, 2015 at 03:44 PM
-- Server version: 5.5.42
-- PHP Version: 5.5.26SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";--
-- Database: `gapsadb`
---- --------------------------------------------------------
--
-- Table structure for table `planningmode`
--CREATE TABLE `planningmode` (
`id` int(12) unsigned NOT NULL,
`name` varchar(100) DEFAULT NULL,
`code` varchar(5) DEFAULT NULL,
`sortOrder` int(3) unsigned DEFAULT NULL,
`mandatoryStartDate` int(1) unsigned DEFAULT '0',
`mandatoryEndDate` int(1) unsigned DEFAULT '0',
`applyTo` varchar(20) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
`mandatoryDuration` int(1) unsigned DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;--
-- Dumping data for table `planningmode`
--INSERT INTO `planningmode` (`id`, `name`, `code`, `sortOrder`, `mandatoryStartDate`, `mandatoryEndDate`, `applyTo`, `idle`, `mandatoryDuration`) VALUES
(1, 'PlanningModeASAP', 'ASAP', 100, 0, 0, 'Activity', 0, 0),
(2, 'PlanningModeREGUL', 'REGUL', 200, 1, 1, 'Activity', 0, 0),
(3, 'PlanningModeFULL', 'FULL', 300, 1, 1, 'Activity', 0, 0),
(4, 'PlanningModeALAP', 'ALAP', 400, 0, 1, 'Activity', 0, 0),
(5, 'PlanningModeFLOAT', 'FLOAT', 100, 0, 0, 'Milestone', 0, 0),
(6, 'PlanningModeFIXED', 'FIXED', 200, 0, 1, 'Milestone', 0, 0),
(7, 'PlanningModeHALF', 'HALF', 320, 1, 1, 'Activity', 0, 0),
(8, 'PlanningModeFDUR', 'FDUR', 450, 0, 0, 'Activity', 0, 1),
(9, 'PlanningModeASAP', 'ASAP', 100, 0, 0, 'TestSession', 0, 0),
(10, 'PlanningModeREGUL', 'REGUL', 200, 1, 1, 'TestSession', 0, 0),
(11, 'PlanningModeFULL', 'FULL', 300, 1, 1, 'TestSession', 0, 0),
(12, 'PlanningModeALAP', 'ALAP', 400, 0, 1, 'TestSession', 0, 0),
(13, 'PlanningModeHALF', 'HALF', 320, 1, 1, 'TestSession', 0, 0),
(14, 'PlanningModeFDUR', 'FDUR', 450, 0, 0, 'TestSession', 0, 1),
(16, 'PlanningModeFIXED', 'FIXED', 100, 1, 0, 'Meeting', 0, 0),
(17, 'PlanningModeGROUP', 'GROUP', 150, 0, 0, 'Activity', 0, 0),
(18, 'PlanningModeGROUP', 'GROUP', 150, 0, 0, 'TestSession', 0, 0),
(19, 'PlanningModeSTART', 'START', 130, 1, 0, 'Activity', 0, 0),
(20, 'PlanningModeQUART', 'QUART', 340, 1, 1, 'Activity', 0, 0),
(21, 'PlanningModeSTART', 'START', 130, 1, 0, 'TestSession', 0, 0);--
-- Indexes for dumped tables
----
-- Indexes for table `planningmode`
--
ALTER TABLE `planningmode`
ADD PRIMARY KEY (`id`),
ADD KEY `planningmodeApplyTo` (`applyTo`);--
-- AUTO_INCREMENT for dumped tables
----
-- AUTO_INCREMENT for table `planningmode`
--
ALTER TABLE `planningmode`
MODIFY `id` int(12) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
OK, so you already have line that upgrade tried to insert.
All is OK, you can work without worry.
ok! don't really know what happend hehehe I just updated and an alert said check log file because of 1 error.
So i'll go on.. thank you very much