View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Kanban Plugin doesn't work - Page 2 - ProjeQtOr
 

Kanban Plugin doesn't work

More
23 Aug 2018 11:17 #7 by Yannobi
Replied by Yannobi on topic Kanban Plugin doesn't work
2018-08-23 11:04:49.148 ===== TRACE ===== New plugin found : kanban_V3.5.zip
2018-08-23 11:04:49.163 ===== TRACE ===== Plugin unzipped succefully
2018-08-23 11:04:49.168 ===== TRACE ===== Plugin descriptor information :
2018-08-23 11:04:49.168 ===== TRACE ===== => name : kanban
2018-08-23 11:04:49.168 ===== TRACE ===== => description : Kanban
2018-08-23 11:04:49.168 ===== TRACE ===== => version : 3.5
2018-08-23 11:04:49.168 ===== TRACE ===== => compatibility : V6.3.7
2018-08-23 11:04:49.168 ===== TRACE ===== =====================================
2018-08-23 11:04:49.169 ===== TRACE =====
2018-08-23 11:04:49.169 ===== TRACE ===== PLUGIN SQL FILE : ../plugin/kanban/kanban.sql
2018-08-23 11:04:49.169 ===== TRACE =====
2018-08-23 11:04:49.169 ***** ERROR ***** [V6.5.2] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100006001' for key 'PRIMARY'
2018-08-23 11:04:49.169 ***** ERROR ***** [V6.5.2] For query : INSERT INTO `menu` (`id`, `name`, `idMenu`, `type`, `sortOrder`, `level`, `idle`, `menuClass`) VALUES
(100006001, 'menuKanban', 0, 'item', 35, NULL, 0, 'Work Risk RequirementTest Financial Meeting ');
2018-08-23 11:04:49.169 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:04:49.169 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/db/maintenanceFunctions.php:71]
2018-08-23 11:04:49.169 ***** ERROR ***** [V6.5.2] #1 runScript called at [/var/www/html/projeqtor/model/Plugin.php:257]
2018-08-23 11:04:49.169 ***** ERROR ***** [V6.5.2] #2 Plugin->load called at [/var/www/html/projeqtor/plugin/loadPlugin.php:53]
2018-08-23 11:04:49.169 ===== TRACE =====
2018-08-23 11:04:49.169 ===== TRACE ===== Error # 1 => SQL error while executing Plugin query in file ../plugin/kanban/kanban.sql (see above message)
2018-08-23 11:04:49.169 ===== TRACE =====
2018-08-23 11:04:49.169 ===== TRACE ===== *************************************************
2018-08-23 11:04:49.169 ===== TRACE =====
2018-08-23 11:04:49.170 ***** ERROR ***** [V6.5.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1142 CREATE command denied to user 'projeqtor_user'@'localhost' for table 'kanban'
2018-08-23 11:04:49.170 ***** ERROR ***** [V6.5.2] For query : CREATE TABLE `kanban` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idUser` int(12),
`isShared` int(1),
`name` varchar(64),
`type` varchar(64),
`param` varchar(10000),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2018-08-23 11:04:49.170 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:04:49.170 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/db/maintenanceFunctions.php:71]
2018-08-23 11:04:49.170 ***** ERROR ***** [V6.5.2] #1 runScript called at [/var/www/html/projeqtor/model/Plugin.php:257]
2018-08-23 11:04:49.170 ***** ERROR ***** [V6.5.2] #2 Plugin->load called at [/var/www/html/projeqtor/plugin/loadPlugin.php:53]
2018-08-23 11:04:49.170 ===== TRACE =====
2018-08-23 11:04:49.170 ===== TRACE ===== Error # 2 => SQL error while executing Plugin query in file ../plugin/kanban/kanban.sql (see above message)
2018-08-23 11:04:49.170 ===== TRACE =====
2018-08-23 11:04:49.170 ===== TRACE ===== *************************************************
2018-08-23 11:04:49.170 ===== TRACE =====
2018-08-23 11:04:49.170 ===== TRACE =====
2018-08-23 11:04:49.170 ===== TRACE ===== DATABASE UPDATED
2018-08-23 11:04:49.170 ===== TRACE ===== WITH 2 ERRORS
2018-08-23 11:04:49.170 ===== TRACE =====
2018-08-23 11:04:49.170 ===== TRACE ===== Plugin updated database with 2 errors from script ../plugin/kanban/kanban.sql
2018-08-23 11:04:49.648 ***** ERROR ***** [V6.5.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.kanban' doesn't exist
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] For query : insert into kanban ( idUser , name , type , param ) values ('1', 'Kanban', 'Status', '{\"column\":[{\"from\":\"1\",\"name\":\"Backlog\",\"cantDelete\":true},{\"from\":\"10\",\"name\":\"Pris en charge\"},{\"from\":\"4\",\"name\":\"Fait\"},{\"from\":\"7\",\"name\":\"Clos\"}],\"typeData\":\"Ticket\"}')
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1150]
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] #1 SqlElement->insertSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:954]
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] #2 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:622]
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] #3 SqlElement->save called at [/var/www/html/projeqtor/plugin/kanban/kanbanPostInstall.php:78]
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] #4 include called at [/var/www/html/projeqtor/model/Plugin.php:265]
2018-08-23 11:04:49.649 ***** ERROR ***** [V6.5.2] #5 Plugin->load called at [/var/www/html/projeqtor/plugin/loadPlugin.php:53]
2018-08-23 11:04:49.658 ===== TRACE ===== Plugin kanban V3.5 completely deployed
2018-08-23 11:04:54.822 ===== TRACE ===== Cannot check Version at projeqtor.org/admin/getVersion.php
2018-08-23 11:04:54.822 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2018-08-23 11:05:02.210 ***** ERROR ***** [V6.5.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.kanban' doesn't exist
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] For query : select * from kanban where idUser=1
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2286]
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:745]
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #2 plgKanbanListSelect called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:85]
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #3 include called at [/var/www/html/projeqtor/plugin/kanban/kanbanViewMain.php:27]
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.kanban' doesn't exist
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] For query : select * from kanban where idUser!=1 AND isShared=1
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2286]
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:746]
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #2 plgKanbanListSelect called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:85]
2018-08-23 11:05:02.211 ***** ERROR ***** [V6.5.2] #3 include called at [/var/www/html/projeqtor/plugin/kanban/kanbanViewMain.php:27]
2018-08-23 11:05:07.776 ***** ERROR ***** [V6.5.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.kanban' doesn't exist
2018-08-23 11:05:07.776 ***** ERROR ***** [V6.5.2] For query : insert into kanban ( idUser , name , type , param ) values ('1', 'rt', 'Status', '{\"column\":[{\"from\":\"1\",\"name\":\"Backlog\",\"cantDelete\":true}],\"typeData\":\"Activity\"}')
2018-08-23 11:05:07.776 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:05:07.776 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1150]
2018-08-23 11:05:07.776 ***** ERROR ***** [V6.5.2] #1 SqlElement->insertSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:954]
2018-08-23 11:05:07.776 ***** ERROR ***** [V6.5.2] #2 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:622]
2018-08-23 11:05:07.776 ***** ERROR ***** [V6.5.2] #3 SqlElement->save called at [/var/www/html/projeqtor/plugin/kanban/kanbanAdd.php:73]
2018-08-23 11:05:07.867 ***** ERROR ***** [V6.5.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.kanban' doesn't exist
2018-08-23 11:05:07.867 ***** ERROR ***** [V6.5.2] For query : select * from kanban where idUser=1
2018-08-23 11:05:07.867 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:05:07.867 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2286]
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:745]
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] #2 plgKanbanListSelect called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:85]
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.kanban' doesn't exist
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] For query : select * from kanban where idUser!=1 AND isShared=1
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] Strack trace :
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2286]
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:746]
2018-08-23 11:05:07.868 ***** ERROR ***** [V6.5.2] #2 plgKanbanListSelect called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:85]

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

More
23 Aug 2018 11:37 - 23 Aug 2018 11:37 #8 by babynus
Replied by babynus on topic Kanban Plugin doesn't work
OK.

Logs is explicit :
- insert into menu fails : normal, line already exists ;)
- create table kanaban : fails
Two possibilities for this error :
1) user does not have right to create table : check that the user projeqtor_user has grant to create tables on the db
2) syntax error : as the script succeeds on mySql, I think it is not the issue, but it is always possible to face a MariaDB specificity. Just try to directly execute script and if any error is reported, please post it here
CREATE TABLE `kanban` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idUser` int(12),
`isShared` int(1),
`name` varchar(64),
`type` varchar(64),
`param` varchar(10000),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
Babynus
Administrator of ProjeQtOr web site
Last edit: 23 Aug 2018 11:37 by babynus.

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

More
23 Aug 2018 11:45 - 23 Aug 2018 11:47 #9 by Yannobi
Replied by Yannobi on topic Kanban Plugin doesn't work
For the first possibility :

MariaDB [projeqtor]> SHOW GRANTS FOR 'projeqtor_user'@'localhost';
+
+
| Grants for projeqtor_user@localhost |
+
+
| GRANT USAGE ON *.* TO 'projeqtor_user'@'localhost' IDENTIFIED BY PASSWORD '*54EE49F236953EC3BD59F4A9919315B4E92CFF80' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `projeqtor`.* TO 'projeqtor_user'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `projeqtor`.`projeqtor` TO 'projeqtor_user'@'localhost' |
+
+
3 rows in set (0.00 sec)


It seems to come from privileges on projeqtor_user who cannot CREATE
Last edit: 23 Aug 2018 11:47 by Yannobi.

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

More
23 Aug 2018 11:50 #10 by babynus
Replied by babynus on topic Kanban Plugin doesn't work
Yes, the create privilege is given only to projeqtor.projeqtor (means table projeqtor af db projeqtor)
I thing it should be given to projeqtor.* (like previous line)

Please change grant options and retry (don't forget to remove lines in table plugin)
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: Yannobi

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

Moderators: babynus, protion
Time to create page: 0.061 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.

Login Form