View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL problem when upgrading from 5.5.4 to 6.0.5 - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

SQL problem when upgrading from 5.5.4 to 6.0.5

More
28 Déc 2016 09:38 #1 by ParnBlade
Hi !

I have this message when i upgrade Projstor from 5.5.4 to 6.0.5.

It is a serious error or juste a warning ?

016-12-27 23:14:47.200 ===== TRACE ===== =====================================
2016-12-27 23:14:47.200 ===== TRACE =====
2016-12-27 23:14:47.201 ===== TRACE ===== VERSION V6.0.3
2016-12-27 23:14:47.201 ===== TRACE =====
2016-12-27 23:14:47.202 ===== TRACE ===== 0 lines updated into table "".
2016-12-27 23:14:47.202 ***** ERROR ***** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 D uplicate entry '43' for key 'PRIMARY'
2016-12-27 23:14:47.202 ***** ERROR ***** For query : INSERT INTO `importable` (`id`, `name`, `idle`) VALUES ('4 3', 'Provider', '0');
2016-12-27 23:14:47.203 ***** ERROR ***** Strack trace :
2016-12-27 23:14:47.203 ***** ERROR ***** #0 Sql->query called at [/var/www/clients/client6/web34/web/projet/db/ maintenanceFunctions.php:71]
2016-12-27 23:14:47.203 ***** ERROR ***** #1 runScript called at [/var/www/clients/client6/web34/web/projet/db/m aintenance.php:101]
2016-12-27 23:14:47.203 ***** ERROR ***** #2 include called at [/var/www/clients/client6/web34/web/projet/tool/l oginCheck.php:135]
2016-12-27 23:14:47.203 ===== TRACE =====
2016-12-27 23:14:47.203 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.0 .3 (see above message)
2016-12-27 23:14:47.203 ===== TRACE =====
2016-12-27 23:14:47.204 ===== TRACE ===== *************************************************
2016-12-27 23:14:47.204 ===== TRACE =====
2016-12-27 23:14:47.204 ===== TRACE =====
2016-12-27 23:14:47.204 ===== TRACE ===== DATABASE UPDATED
2016-12-27 23:14:47.204 ===== TRACE ===== WITH 1 ERROR
2016-12-27 23:14:47.204 ===== TRACE =====
2016-12-27 23:14:47.327 ===== TRACE ===== =====================================
2016-12-27 23:14:47.327 ===== TRACE =====
2016-12-27 23:14:47.327 ===== TRACE ===== 1 ERRORS DURING UPDATE TO VERSION V6.0.5
2016-12-27 23:14:47.327 ===== TRACE =====
2016-12-27 23:14:47.328 ===== TRACE ===== =====================================

Please Connexion or Create an account to join the conversation.

More
28 Déc 2016 09:57 #2 by babynus
This is a minor issue.
It just add Provider as Importable item.

But I don't understand how you got it.
Could you please post dump of table Importable ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
28 Déc 2016 14:31 #3 by ParnBlade
-- MySQL dump 10.15 Distrib 10.0.27-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: turbolea_projectorria
--
-- Server version 10.0.27-MariaDB-0+deb8u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `importable`
--

DROP TABLE IF EXISTS `importable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `importable` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `importable`
--

LOCK TABLES `importable` WRITE;
/*!40000 ALTER TABLE `importable` DISABLE KEYS */;
INSERT INTO `importable` VALUES (1,'Ticket',0),(2,'Activity',0),(3,'Milestone',0),(4,'Risk',0),(5,'Action',0),(6,'Issue',0),(7,'Meeting',0),(8,'Decision',0),(9,'Question',0),(10,'IndividualExpense',0),(11,'ProjectExpense',0),(12,'Client',0),(13,'Contact',0),(14,'Project',0),(15,'Team',0),(16,'Resource',0),(17,'Affectation',0),(18,'Assignment',0),(19,'Product',0),(20,'ProductVersion',0),(21,'Document',0),(22,'Requirement',0),(23,'TestCase',0),(24,'TestSession',0),(25,'TestCaseRun',0),(26,'Opportunity',0),(27,'Command',0),(28,'Quotation',0),(29,'Work',0),(30,'Component',0),(31,'ComponentVersion',0),(32,'ProductStructure',0),(33,'Bill',0),(34,'Payment',0),(35,'ResourceCost',0),(42,'DocumentDirectory',0),(43,'Component',0),(44,'ComponentVersion',0),(45,'ProductStructure',0),(46,'Bill',0),(47,'Payment',0),(48,'ResourceCost',0),(49,'Component',0),(50,'ComponentVersion',0),(51,'ProductStructure',0),(52,'Bill',0),(53,'Payment',0),(54,'ResourceCost',0),(55,'Component',0),(56,'ComponentVersion',0),(57,'ProductStructure',0),(58,'Bill',0),(59,'Payment',0),(60,'ResourceCost',0),(61,'Component',0),(62,'ComponentVersion',0),(63,'ProductStructure',0),(64,'Bill',0),(65,'Payment',0),(66,'ResourceCost',0),(67,'Component',0),(68,'ComponentVersion',0),(69,'ProductStructure',0),(70,'Bill',0),(71,'Payment',0),(72,'ResourceCost',0),(73,'Component',0),(74,'ComponentVersion',0),(75,'ProductStructure',0),(76,'Bill',0),(77,'Payment',0),(78,'ResourceCost',0),(79,'Component',0),(80,'ComponentVersion',0),(81,'ProductStructure',0),(82,'Bill',0),(83,'Payment',0),(84,'ResourceCost',0),(85,'Component',0),(86,'ComponentVersion',0),(87,'ProductStructure',0),(88,'Bill',0),(89,'Payment',0),(90,'ResourceCost',0),(91,'Component',0),(92,'ComponentVersion',0),(93,'ProductStructure',0),(94,'Bill',0),(95,'Payment',0),(96,'ResourceCost',0),(97,'Component',0),(98,'ComponentVersion',0),(99,'ProductStructure',0),(100,'Bill',0),(101,'Payment',0),(102,'ResourceCost',0),(103,'Component',0),(104,'ComponentVersion',0),(105,'ProductStructure',0),(106,'Bill',0),(107,'Payment',0),(108,'ResourceCost',0),(109,'Component',0),(110,'ComponentVersion',0),(111,'ProductStructure',0),(112,'Bill',0),(113,'Payment',0),(114,'ResourceCost',0);
/*!40000 ALTER TABLE `importable` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-12-28 14:30:28

Please Connexion or Create an account to join the conversation.

More
28 Déc 2016 14:58 #4 by babynus
It seems you have many dupplicates.
Maybe your ran same upgrade several times ?

Delete items in table 'importable' with id >= 43
DELETE FROM `importable` WHERE id >=43;
Then inser new one :
INSERT INTO `importable` (`id`, `name`, `idle`) VALUES ('43', 'Provider', '0');

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
28 Déc 2016 15:03 #5 by ParnBlade
Thank you

I think I have done only one time the update ... But i could make a mistake ...

MariaDB [projectorria]> DELETE FROM `importable` WHERE id >=43;
Query OK, 72 rows affected (0.00 sec)

MariaDB [projectorria]> INSERT INTO `importable` (`id`, `name`, `idle`) VALUES ('43', 'Provider', '0');
Query OK, 1 row affected (0.00 sec)

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.037 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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