View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - 1 Error during update to 5.1.2 - ProjeQtOr
 
 

1 Error during update to 5.1.2

More
11 Nov 2015 14:49 #1 by soyelsimo
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'

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

More
11 Nov 2015 15:22 #2 by babynus
Hi,

Could you please post content of table "planningmode" ?

Babynus
Administrator of ProjeQtOr web site

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

More
11 Nov 2015 15:47 #3 by soyelsimo
As text like this is ok?

-- phpMyAdmin SQL Dump
-- version 4.4.10
-- www.phpmyadmin.net
--
-- Host: localhost:8889
-- Generation Time: Nov 11, 2015 at 03:44 PM
-- Server version: 5.5.42
-- PHP Version: 5.5.26

SET 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;

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

More
11 Nov 2015 15:51 #4 by babynus
OK, so you already have line that upgrade tried to insert.

All is OK, you can work without worry.

Babynus
Administrator of ProjeQtOr web site

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

More
11 Nov 2015 15:57 #5 by soyelsimo
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

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

Moderators: babynusprotion
Time to create page: 0.031 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.