View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Increase the number of fields in the database - 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)

 

 

 
 

Increase the number of fields in the database

More
13 Oct 2021 15:00 #1 by LEADER
Hello,

I need to personalize the screen (from the pluggin with adding fields) and i have an error message on the logs: 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 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

I don't know how to do. I cannot supress rows (error msg). I am blocked. Do you have an idea ?

Thank you in advance

Please Connexion or Create an account to join the conversation.

More
15 Oct 2021 12:39 #2 by babynus
Hi, this is a technical limitation for MySql.
Sum of size for all fields cannot be more than 8126/
Try and reduce size for fields that don't require default size : reference, externalReference could be changed to varchar(20) instead of varchar(100).
Try also to reduce size of fields you added.
At last, you can try a replace some varchar fields with mediumtext (these are blobs and their size is not counted in total size for table). Not that you then won't be able to use the field in list.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
15 Oct 2021 12:52 - 15 Oct 2021 12:53 #3 by babynus
Another thing to try, it you defined DB in charset UTF8MB4, try and change to UTFB.
This format uses a bit less space (3 bits per char instead of 4 bits per char) 

You could also change to Latin1, but you'll then need to convert the DB

Babynus
Administrator of ProjeQtOr web site
Last edit: 15 Oct 2021 12:53 by babynus.

Please Connexion or Create an account to join the conversation.

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