View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - TEST 3.1.2 : projectorria.workperiod' doesn't exist For query. - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

3 décembre (16h-17h30)

9 janvier 2025 (10h30-12h)

4 février 2025 (16h-17h30)

6 mars 2025 (10h30-12h)

 
 

Planifiez avec ProjeQtOr

19 et 20 novembre (14h-17h30)

21 et 22 janvier 2025 (9h-12h30)

18 et 19 mars 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

26 et 27 novembre (14h-17h30)

28 et 29 janvier (9h-12h30)

25 et 26 mars (9h-12h30)

 

 

 

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

More
04 Fév 2013 10:28 #1 by spiderjn
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]

Please Connexion or Create an account to join the conversation.

More
04 Fév 2013 14:59 - 04 Fév 2013 14:59 #2 by babynus
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.

Babynus
Administrator of ProjeQtOr web site
Last edit: 04 Fév 2013 14:59 by babynus.

Please Connexion or Create an account to join the conversation.

More
04 Fév 2013 17:24 #3 by spiderjn
ok it's work now
many thanks

Please Connexion or Create an account to join the conversation.

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