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

Next training sessions

 

 

 

Demonstration of ProjeQtOr

(free - registration required)
 

September, 12th (4pm - 5:30pm)

 

 

places are limited, register quickly ! 

 

92 Error during updrade to 10.0.2

More
22 Jul 2022 13:05 #1 by ganeshkandu
Hi,

i was trying to install projeqtor 10.0.2 while installing i found issue,

Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

After debug i found database table CHARSET and COLLATE are changes to utf8mb4

there are some tables who have varchar columns with 4000 length those columns are causing this issue.

when i am trying with utf8 it working and causing error when its utf8mb4

CREATE TABLE `prepq_issue` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idProject` int(12) unsigned DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`idIssueType` int(12) unsigned DEFAULT NULL,
`cause` varchar(4000) DEFAULT NULL,
`impact` varchar(4000) DEFAULT NULL,
`idPriority` int(12) unsigned DEFAULT NULL,
`creationDate` date DEFAULT NULL,
`idUser` int(12) unsigned DEFAULT NULL,
`idStatus` int(12) unsigned DEFAULT NULL,
`idResource` int(12) unsigned DEFAULT NULL,
`initialEndDate` date DEFAULT NULL,
`actualEndDate` date DEFAULT NULL,
`closureDate` date DEFAULT NULL,
`result` varchar(4000) DEFAULT NULL,
`comment` varchar(4000) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ;


I think you should use small number for those varchars.present in opportunity, risk, issue  tables.


 
Attachments:

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

More
22 Jul 2022 14:16 - 22 Jul 2022 14:17 #2 by babynus
Error message is wrongRow size too large.
The maximum row size for the used table type, not counting BLOBs, is 65535
But 4000 x 4 = 16000 < 65535
MySql parameter must be adapted :
innodb_default_row_format=dynamic
(this is a prerequisite to projeqtor installation)

Babynus
Administrator of ProjeQtOr web site
Last edit: 22 Jul 2022 14:17 by babynus.

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

More
24 Jul 2022 22:08 #3 by gauvain
Hello,

For information, the MariaDB config you ask for is the default value since 10.2.2 (mariadb.com/kb/en/innodb-system-variable...b_default_row_format).

But I still have tried to set this parameter to MariaDB and I get the same errrors.

Regards,

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

More
25 Jul 2022 11:23 #4 by ganeshkandu
Hi,

I tried to do what you suggested but i wasn't able to do
i got this error

#1193 - Unknown system variable 'innodb_default_row_format'

This is because "innodb_default_row_format" variable was Introduced in version 5.7.9 of MySQL, ( dev.mysql.com/doc/mysqld-version-referen...var-changes-5-7.html ) its not there in MySQL 5.6

And according to Compatibility Matrix projeqtor works on MySQL 5.6 ( www.projeqtor.org/en/product-en/technica...uct-prerequisites-en )

its also not working on Barracuda format of mysql 5.6.

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

More
25 Jul 2022 11:46 - 25 Jul 2022 11:48 #5 by ganeshkandu
Setting innodb_default_row_format to dynamic also not working on MySQL 5.7.37

65535 is a total size of all fields of table excluding BLOB and TEXT ( dev.mysql.com/doc/mysql-reslimits-excerp...umn-count-limit.html )

But 4000 x 4 = 16000 < 65535 this is not a case here
if i count only varchar(4000) of table that is 4000 x 4 x 5= 80000 > 65535
Last edit: 25 Jul 2022 11:48 by ganeshkandu.

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

More
25 Jul 2022 13:57 #6 by babynus
Hi, 

This issue may occur on older version of MySql (I did not test).
To avoid the issue : install V9.5.5, then migrate to V10.0.2

Babynus
Administrator of ProjeQtOr web site

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

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