Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Forums
Requests
Submit issues
Kanban Plugin doesn...
 
Notifications
Clear all

Kanban Plugin doesn't work

 
Submit issues
Last Post by babynus 8 years ago
10 Posts
2 Users
0 Reactions
8,295 Views
RSS
 Di Maggio Yann
(@yannobi)
Posts: 69
Active Member
Topic starter
 
[#5373]

Hi,

We work with Projeqtor and just installed Kanban.

It's ok for the installation and we see the front page updated with this new fonctionnality. But it doesn't work.
When we want to create a new kanban for example, nothing appears (alert message or the new kanban)

Here are logs of the installation et the first attempt to create a column :
2018-08-22 09:01:55.335 ===== TRACE ===== New plugin found : kanban_V3.5.zip
2018-08-22 09:01:55.352 ===== TRACE ===== Plugin unzipped succefully
2018-08-22 09:01:55.357 ===== TRACE ===== Plugin descriptor information :
2018-08-22 09:01:55.357 ===== TRACE ===== => name : kanban
2018-08-22 09:01:55.357 ===== TRACE ===== => description : Kanban
2018-08-22 09:01:55.357 ===== TRACE ===== => version : 3.5
2018-08-22 09:01:55.357 ===== TRACE ===== => compatibility : V6.3.7
2018-08-22 09:01:56.066 ===== TRACE ===== Plugin kanban V3.5 completely deployed
2018-08-22 09:02:01.205 ===== TRACE ===== Cannot check Version at http://projeqtor.org/admin/getVersion.php
2018-08-22 09:02:01.205 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.kanban' doesn't exist
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] For query : select * from kanban where id=-1
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] Strack trace :
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2694]
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] #1 SqlElement->getSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:573]
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] #2 SqlElement->__construct called at [/var/www/html/projeqtor/model/Kanban.php:50]
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] #3 Kanban->__construct called at [/var/www/html/projeqtor/plugin/kanban/kanbanView.php:54]
2018-08-22 09:02:27.295 ** ERROR ** [V6.5.2] #4 include called at [/var/www/html/projeqtor/plugin/kanban/kanbanViewMain.php:27]


 
Posted : 22 Aug 2018 11H11
babynus
 babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

It seems table kanban was not created correctly.

Did you try and install plugin several times ?
Whare is your Database (postgres or mysql) ?
Can you check for table kanban in db ?


 
Posted : 22 Aug 2018 17H00
 Di Maggio Yann
(@yannobi)
Posts: 69
Active Member
Topic starter
 

We try 3 times the install but with no sucess.

The DB is MariaDB and there is no table Kanban.


 
Posted : 23 Aug 2018 11H24
babynus
 babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

OK,
If plugin is considered installed, db updates are not replayed.

So : go to table plugin and remove all lines with name "kaban"
Then try again to install plugin.


 
Posted : 23 Aug 2018 12H00
 Di Maggio Yann
(@yannobi)
Posts: 69
Active Member
Topic starter
 

Done !

CHECK PLUGINS INSTALLED

]MariaDB [projeqtor]> select * from plugin;
| 1 | Kanban | kanban | ../plugin/kanban_V3.5.zip | 2018-07-13 | 1 | V6.5.2 | V6.3.7 | 3.5
| 2 | Kanban | kanban | ../plugin/kanban_V3.5.zip | 2018-08-22 | 1 | V6.5.2 | V6.3.7 | 3.5
| 3 | Kanban | kanban | ../plugin/kanban_V3.5.zip | 2018-08-23 | 1 | V6.5.2 | V6.3.7 | 3.5
| 4 | Kanban | kanban | ../plugin/kanban_V3.5.zip | 2018-08-23 | 1 | V6.5.2 | V6.3.7 | 3.5
4 rows in set (0.00 sec)

DELETE THE PLUGIN
MariaDB [projeqtor]> delete from plugin where name ='Kanban';
Query OK, 4 rows affected (0.00 sec)

CHECK THE ACTION
MariaDB [projeqtor]> select * from plugin;
-> ;
Empty set (0.00 sec)

Then i tried to reload the plugin. Same problem : Plugin installed in the interface but there is no possibility to create some board.

MariaDB [projeqtor]> select * from plugin;
| 5 | Kanban | kanban | ../plugin/kanban_V3.5.zip | 2018-08-23 | 1 | V6.5.2 | V6.3.7 | 3.5
1 row in set (0.00 sec)


 
Posted : 23 Aug 2018 13H09
babynus
 babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Can you please post log file showing trace of install of plugin ?


 
Posted : 23 Aug 2018 13H14
 Di Maggio Yann
(@yannobi)
Posts: 69
Active Member
Topic starter
 

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 http://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]


 
Posted : 23 Aug 2018 13H17
babynus
 babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

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 ;

 
Posted : 23 Aug 2018 13H37
 Di Maggio Yann
(@yannobi)
Posts: 69
Active Member
Topic starter
 

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


 
Posted : 23 Aug 2018 13H45
babynus
 babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

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)


 
Posted : 23 Aug 2018 13H50
Forum Jump:
  Previous Topic
Next Topic  
Share:

Scroll to Top