Forum

Error with plugin S...
 
Notifications
Clear all

Error with plugin ScreenCustomization

2 Posts
2 Users
0 Reactions
2,889 Views
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 
[#5416]

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

 
Posted : 12 Sep 2018 14H17
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 13 Sep 2018 11H36
Share:

Scroll to Top