View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Restore database error - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Restore database error

More
04 Déc 2018 09:50 #1 by bassem
Hello,

I tried for a while to restore my ProjeQtor database but without success.
And every time I receive this error message:

Erreur
Requête SQL :


--
-- Dumping data for table `accessprofile`
--

INSERT INTO `accessprofile` (`id`, `name`, `description`, `idAccessScopeRead`, `idAccessScopeCreate`, `idAccessScopeUpdate`, `idAccessScopeDelete`, `sortOrder`, `idle`) VALUES
(1, 'accessProfileRestrictedReader', 'Read only his projects', 3, 1, 1, 1, 100, 0),
(2, 'accessProfileGlobalReader', 'Read all projects', 4, 1, 1, 1, 150, 0),
(3, 'accessProfileRestrictedUpdater', 'Read and Update only his projects', 3, 1, 3, 1, 200, 0),
(4, 'accessProfileGlobalUpdater', 'Read and Update all projects', 4, 1, 4, 1, 250, 0),
(5, 'accessProfileRestrictedCreator', 'Read only his projects\nCan create\nUpdate and delete his own elements', 3, 3, 2, 2, 300, 0),
(6, 'accessProfileGlobalCreator', 'Read all projects\nCan create\nUpdate and delete his own elements', 4, 4, 2, 2, 350, 0),
(7, 'accessProfileRestrictedManager', 'Read only his projects\nCan create\nUpdate and delete his projects', 3, 3, 3, 3, 400, 0),
(8, 'accessProfileGlobalManager', 'Read all pro[...]
MySQL a répondu :

#1062 - Duplicata du champ '1' pour la clef 'PRIMARY'

P.S: I am using ProjeQt0r 7.2.5

Thank you for your help.
Attachments:

Please Connexion or Create an account to join the conversation.

More
04 Déc 2018 09:51 #2 by babynus
Replied by babynus on topic Restore database error
You must clean (empy) DB before restoring.
NB : better rename DB, so you keep existing version as backup

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
04 Déc 2018 09:58 #3 by bassem
Replied by bassem on topic Restore database error
I did it, but I still received this error message:
Erreur
Requête SQL :


--
-- Dumping data for table `accessprofile`
--

INSERT INTO `accessprofile` (`id`, `name`, `description`, `idAccessScopeRead`, `idAccessScopeCreate`, `idAccessScopeUpdate`, `idAccessScopeDelete`, `sortOrder`, `idle`) VALUES
(1, 'accessProfileRestrictedReader', 'Read only his projects', 3, 1, 1, 1, 100, 0),
(2, 'accessProfileGlobalReader', 'Read all projects', 4, 1, 1, 1, 150, 0),
(3, 'accessProfileRestrictedUpdater', 'Read and Update only his projects', 3, 1, 3, 1, 200, 0),
(4, 'accessProfileGlobalUpdater', 'Read and Update all projects', 4, 1, 4, 1, 250, 0),
(5, 'accessProfileRestrictedCreator', 'Read only his projects\nCan create\nUpdate and delete his own elements', 3, 3, 2, 2, 300, 0),
(6, 'accessProfileGlobalCreator', 'Read all projects\nCan create\nUpdate and delete his own elements', 4, 4, 2, 2, 350, 0),
(7, 'accessProfileRestrictedManager', 'Read only his projects\nCan create\nUpdate and delete his projects', 3, 3, 3, 3, 400, 0),
(8, 'accessProfileGlobalManager', 'Read all pro[...]
MySQL a répondu :

#1062 - Duplicata du champ '1' pour la clef 'PRIMARY'

Please Connexion or Create an account to join the conversation.

More
04 Déc 2018 10:07 #4 by babynus
Replied by babynus on topic Restore database error

#1062 - Duplicata du champ '1' pour la clef 'PRIMARY'

sure your db is not empty.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
04 Déc 2018 10:14 #5 by bassem
Replied by bassem on topic Restore database error
please find the attached file
Attachments:

Please Connexion or Create an account to join the conversation.

More
04 Déc 2018 10:22 #6 by bassem
Replied by bassem on topic Restore database error
P.S : I use mysqlbackupandftp tool to backup my database
Maybe the settings are incorrect (please find attached file)
Attachments:

Please Connexion or Create an account to join the conversation.

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