Forum

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.

TEST 3.1.2 : projec...
 
Notifications
Clear all

TEST 3.1.2 : projectorria.workperiod' doesn't exist For query.

3 Posts
2 Users
0 Reactions
5,414 Views
(@spiderjn)
Posts: 35
Active Member
Topic starter
 
[#946]

Hi Babynus

i've found this error, just after install new version, i this it's a problem with name of table 'workperiod' // 'workPeriod'

thank's a lot for your job

Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projectorria.workperiod' doesn't exist For query : desc workperiod Strack trace : #0 Sql->query called at [/var/www/projectorria/model/persistence/SqlElement.php:1771] #1 SqlElement->getFormatList called at [/var/www/projectorria/model/persistence/SqlElement.php:1573] #2 SqlElement->getDataType called at [/var/www/projectorria/model/persistence/SqlElement.php:1119] #3 SqlElement->getSqlElementsFromCriteria called at [/var/www/projectorria/model/persistence/SqlElement.php:1285] #4 SqlElement->getSingleSqlElementFromCriteria called at [/var/www/projectorria/model/ImputationLine.php:321] #5 ImputationLine->drawLines called at [/var/www/projectorria/view/imputationList.php:182] #6 include called at [/var/www/projectorria/view/imputationMain.php:11]Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projectorria.workperiod' doesn't exist For query : select * from workperiod where workperiod.periodRange='week' and workperiod.periodValue='201306' and workperiod.idResource='3' Strack trace : #0 Sql->query called at [/var/www/projectorria/model/persistence/SqlElement.php:1152] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projectorria/model/persistence/SqlElement.php:1285] #2 SqlElement->getSingleSqlElementFromCriteria called at [/var/www/projectorria/model/ImputationLine.php:321] #3 ImputationLine->drawLines called at [/var/www/projectorria/view/imputationList.php:182] #4 include called at [/var/www/projectorria/view/imputationMain.php:11]

 
Posted : 04 Feb 2013 12H28
(@babynus)
Posts: 14952
Member Admin
 

You're right.
This issue does not appear on Windows (not case sensitive) but appears on Linux.

Request to fix this is :

RENAME TABLE `workPeriod` TO `workperiod`;

Will be deployed in v3.1.3 asap.


 
Posted : 04 Feb 2013 16H59
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

ok it's work now
many thanks


 
Posted : 04 Feb 2013 19H24
Share:

Scroll to Top