View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Error with plugin ScreenCustomization - 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)

 

 

 

Error with plugin ScreenCustomization

More
12 Sep 2018 12:17 - 12 Sep 2018 13:22 #1 by dnaton
Hello,

I've an environment of Production with ProjeQtor 7.1.4 and Plugin ScreenCustomization 5.1 and all works fine.

To test some ehancement (or upgrade,...) , I deployed an PréProd environment

It's a complete copy of the production environment, create with theses steps
  • Copy of the program directory in a new directory
  • Modification in file\config\parameters.php for the name of the database (ac_sepra for production, ac_seprapp for PreProd
  • Export of my Production Database via PhpMyAdmin
  • Modification of the name in this export file (ac_sepra--->ac_seprapp
  • Modification of any reference of ac_sepra in ac_seprapp

This new environment (PreProd" seems to be ok and operational : I retrieve all my data from my Prod environment, i can create items,...

Juste one problem with the screen customization plugin
I want to create (for tests) a new list to select field : the lis is correctly created but when I try to input data in this list, I've got this message and can not input anything :-(



The same process in my production environment work fine, without problem.

I think I forgot some step during the creation of my PreProd environment but I don't know what :-(

Here is th log of the error

2018-09-12 13:20:22.026 ***** ERROR ***** [V7.2.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ac_seprapp.plgcustomlist' doesn't exist
2018-09-12 13:20:22.032 ***** ERROR ***** [V7.2.2] For query : select plgcustomlist.id as id, plgcustomlist.name as name, plgcustomlist.sortOrder as sortOrder, plgcustomlist.idle as idle from plgcustomlist where plgcustomlist.idle=0 and ((1=1)) and plgcustomlist.scope='SousTraitance' order by plgcustomlist.sortOrder
2018-09-12 13:20:22.039 ***** ERROR ***** [V7.2.2] Strack trace :
2018-09-12 13:20:22.044 ***** ERROR ***** [V7.2.2] #0 Sql->query called at [C:\xampp5630\htdocs\ac_seprapp\tool\jsonQuery.php:565]
2018-09-12 13:20:24.743 ***** ERROR ***** [V7.2.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ac_seprapp.plgcustomlist' doesn't exist
2018-09-12 13:20:24.750 ***** ERROR ***** [V7.2.2] For query : desc plgcustomlist
2018-09-12 13:20:24.757 ***** ERROR ***** [V7.2.2] Strack trace :
2018-09-12 13:20:24.766 ***** ERROR ***** [V7.2.2] #0 Sql->query called at [C:\xampp5630\htdocs\ac_seprapp\model\persistence\SqlElement.php:3453]
2018-09-12 13:20:24.774 ***** ERROR ***** [V7.2.2] #1 SqlElement->getFormatList called at [C:\xampp5630\htdocs\ac_seprapp\model\persistence\SqlElement.php:3011]
2018-09-12 13:20:24.779 ***** ERROR ***** [V7.2.2] #2 SqlElement->getDataType called at [C:\xampp5630\htdocs\ac_seprapp\view\objectDetail.php:1265]
2018-09-12 13:20:24.788 ***** ERROR ***** [V7.2.2] #3 drawTableFromObject called at [C:\xampp5630\htdocs\ac_seprapp\view\objectDetail.php:285]
2018-09-12 13:20:28.635 ***** ERROR ***** [V7.2.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ac_seprapp.plgcustomlist' doesn't exist
2018-09-12 13:20:28.641 ***** ERROR ***** [V7.2.2] For query : insert into plgcustomlist (scope, name , sortOrder ) values ('SousTraitance', 'oui', '0')
2018-09-12 13:20:28.647 ***** ERROR ***** [V7.2.2] Strack trace :
2018-09-12 13:20:28.652 ***** ERROR ***** [V7.2.2] #0 Sql->query called at [C:\xampp5630\htdocs\ac_seprapp\model\persistence\SqlElement.php:1193]
2018-09-12 13:20:28.658 ***** ERROR ***** [V7.2.2] #1 SqlElement->insertSqlElement called at [C:\xampp5630\htdocs\ac_seprapp\model\persistence\SqlElement.php:992]
2018-09-12 13:20:28.663 ***** ERROR ***** [V7.2.2] #2 SqlElement->saveSqlElement called at [C:\xampp5630\htdocs\ac_seprapp\model\persistence\SqlElement.php:655]
2018-09-12 13:20:28.670 ***** ERROR ***** [V7.2.2] #3 SqlElement->save called at [C:\xampp5630\htdocs\ac_seprapp\tool\saveObject.php:78]

Regards,
Damien
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2
Attachments:
Last edit: 12 Sep 2018 13:22 by dnaton.

Please Connexion or Create an account to join the conversation.

More
13 Sep 2018 09:36 #2 by babynus

with ProjeQtor 7.1.4

Consider migration to V7.1.5

Modification in file\config\parameters.php

You should move this file out of web access (for security purpose)

Check that table "ac_seprapp.plgcustomlist" exists and that user has read/write access on it.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

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