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.
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 fileconfigparameters.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:xampp5630htdocsac_seprapptooljsonQuery.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:xampp5630htdocsac_seprappmodelpersistenceSqlElement.php:3453]
2018-09-12 13:20:24.774 ** ERROR ** [V7.2.2] #1 SqlElement->getFormatList called at [C:xampp5630htdocsac_seprappmodelpersistenceSqlElement.php:3011]
2018-09-12 13:20:24.779 ** ERROR ** [V7.2.2] #2 SqlElement->getDataType called at [C:xampp5630htdocsac_seprappviewobjectDetail.php:1265]
2018-09-12 13:20:24.788 ** ERROR ** [V7.2.2] #3 drawTableFromObject called at [C:xampp5630htdocsac_seprappviewobjectDetail.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:xampp5630htdocsac_seprappmodelpersistenceSqlElement.php:1193]
2018-09-12 13:20:28.658 ** ERROR ** [V7.2.2] #1 SqlElement->insertSqlElement called at [C:xampp5630htdocsac_seprappmodelpersistenceSqlElement.php:992]
2018-09-12 13:20:28.663 ** ERROR ** [V7.2.2] #2 SqlElement->saveSqlElement called at [C:xampp5630htdocsac_seprappmodelpersistenceSqlElement.php:655]
2018-09-12 13:20:28.670 ** ERROR ** [V7.2.2] #3 SqlElement->save called at [C:xampp5630htdocsac_seprapptoolsaveObject.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
with ProjeQtor 7.1.4
Consider migration to V7.1.5
Modification in fileconfigparameters.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.
