Forum

Issue at project cr...
 
Notifications
Retirer tout

Issue at project creation | table planningelement missing

8 Posts
2 Utilisateurs
0 Reactions
3,324 Vu
(@edlonar)
Posts: 5
Active Member
Début du sujet
 
[#8011]

Hi
I have an issue when I want to create a new project (I have this problem with version 9.3.5 and 9.4.1). It seems that the planningelement table is missing.

Please find bellow the log:

2022-01-10 15:14:51.138 ** ERROR ** [V9.4.1] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 La table 'projeqtor.planningelement' n'existe pas
2022-01-10 15:14:51.163 ** ERROR ** [V9.4.1] For query : select * from planningelement where idProject in (0) and idProject not in (0) and refType= 'Project' and idle=0 order by wbsSortable asc
2022-01-10 15:14:51.164 ** ERROR ** [V9.4.1] Strack trace :
2022-01-10 15:14:51.171 ** ERROR ** [V9.4.1] #0 Sql->query called at [C:wampserverwwwJoomlaprojeqtormodelpersistenceSqlElement.php:2834]
2022-01-10 15:14:51.172 ** ERROR ** [V9.4.1] #1 SqlElement->getSqlElementsFromCriteria called at [C:wampserverwwwJoomlaprojeqtorviewmain.php:2259]
2022-01-10 15:14:53.624 ** ERROR ** [V9.4.1] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 La table 'projeqtor.delivery' n'existe pas
2022-01-10 15:14:53.626 ** ERROR ** [V9.4.1] For query : select idproject, done, idle, count(*) as cpt from delivery where idProject in (0) group by idproject, done, idle
2022-01-10 15:14:53.627 ** ERROR ** [V9.4.1] Strack trace :
2022-01-10 15:14:53.629 ** ERROR ** [V9.4.1] #0 Sql->query called at [C:wampserverwwwJoomlaprojeqtormodelpersistenceSqlElement.php:3077]
2022-01-10 15:14:53.630 ** ERROR ** [V9.4.1] #1 SqlElement->countGroupedSqlElementsFromCriteria called at [C:wampserverwwwJoomlaprojeqtorviewtoday.php:68]
2022-01-10 15:14:53.696 ** ERROR ** [V9.4.1] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 La table 'projeqtor.planningelement' n'existe pas
2022-01-10 15:14:53.698 ** ERROR ** [V9.4.1] For query : select * from planningelement where refType='Project' and refId in (0) and idle=0 order by wbsSortable
2022-01-10 15:14:53.699 ** ERROR ** [V9.4.1] Strack trace :
2022-01-10 15:14:53.701 ** ERROR ** [V9.4.1] #0 Sql->query called at [C:wampserverwwwJoomlaprojeqtormodelpersistenceSqlElement.php:2834]
2022-01-10 15:14:53.702 ** ERROR ** [V9.4.1] #1 SqlElement->getSqlElementsFromCriteria called at [C:wampserverwwwJoomlaprojeqtormodelUserMain.php:884]
2022-01-10 15:14:53.703 ** ERROR ** [V9.4.1] #2 UserMain->getHierarchicalViewOfVisibleProjects called at [C:wampserverwwwJoomlaprojeqtorviewtoday.php:184]
2022-01-10 15:14:53.704 ** ERROR ** [V9.4.1] #3 showProjects called at [C:wampserverwwwJoomlaprojeqtorviewtoday.php:1143]
2022-01-10 15:15:22.925 ** ERROR ** [V9.4.1] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 La table 'projeqtor.planningelement' n'existe pas
2022-01-10 15:15:22.927 ** ERROR ** [V9.4.1] For query : select project.id as id, projectplanningelement.wbsSortable as wbsSortable, project.name as name, T1.name as nameProjectType, project.color as color, convert(concat(COALESCE(T2.sortOrder,''),'#split#',T2.name,'#split#',COALESCE(T2.color,'')) using utf8) as colorNameStatus, projectplanningelement.progress as progress, projectplanningelement.plannedEndDate as plannedEndDate,project.idProject as idproject from project left join planningelement as projectplanningelement on (projectplanningelement.refId=project.id and projectplanningelement.refType='Project') left join type as T1 on project.idProjectType = T1.id left join status as T2 on project.idStatus = T2.id where project.idle=0 and ( ((project.id not in (0) or project.id is null ) and (project.id not in (0) or project.id is null or (project.idResource=1) ) and (project.id not in (0) or project.id is null or (project.idUser='1') )) or project.codeType='TMP' ) order by projectplanningelement.wbsSortable , project.sortOrder
2022-01-10 15:15:22.928 ** ERROR ** [V9.4.1] Strack trace :
2022-01-10 15:15:22.929 ** ERROR ** [V9.4.1] #0 Sql->query called at [C:wampserverwwwJoomlaprojeqtortooljsonQuery.php:753]
2022-01-10 15:15:26.821 ** ERROR ** [V9.4.1] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 La table 'projeqtor.planningelement' n'existe pas
2022-01-10 15:15:26.823 ** ERROR ** [V9.4.1] For query : desc planningelement
2022-01-10 15:15:26.824 ** ERROR ** [V9.4.1] Strack trace :
2022-01-10 15:15:26.825 ** ERROR ** [V9.4.1] #0 Sql->query called at [C:wampserverwwwJoomlaprojeqtormodelpersistenceSqlElement.php:3975]
2022-01-10 15:15:26.827 ** ERROR ** [V9.4.1] #1 SqlElement->getFormatList called at [C:wampserverwwwJoomlaprojeqtormodelpersistenceSqlElement.php:3517]
2022-01-10 15:15:26.828 ** ERROR ** [V9.4.1] #2 SqlElement->getDataType called at [C:wampserverwwwJoomlaprojeqtormodelpersistenceSqlElement.php:3522]
2022-01-10 15:15:26.829 ** ERROR ** [V9.4.1] #3 SqlElement->getDataType called at [C:wampserverwwwJoomlaprojeqtorviewobjectDetail.php:1532]
2022-01-10 15:15:26.830 ** ERROR ** [V9.4.1] #4 drawTableFromObject called at [C:wampserverwwwJoomlaprojeqtorviewobjectDetail.php:354]
2022-01-10 15:15:31.689 ** ERROR ** [V9.4.1] ERROR **
2022-01-10 15:15:31.691
** ERROR ** [V9.4.1] on file 'C:wampserverwwwJoomlaprojeqtormodelProjectPlanningElementMain.php' at line (286)
2022-01-10 15:15:31.692
** ERROR ***** [V9.4.1] cause = A non-numeric value encountered

Many thanks for your help.


 
Posté : 10/01/2022 5:21 pm
(@babynus)
Posts: 14952
Membre Admin
 

PLEASE RESPECT FORUM RULES


 
Posté : 10/01/2022 5:30 pm
(@edlonar)
Posts: 5
Active Member
Début du sujet
 

English translation done.
Sorry.

best regards


 
Posté : 10/01/2022 5:42 pm
(@babynus)
Posts: 14952
Membre Admin
 

Check your DB.
Does table "planningelement" exist ?


 
Posté : 10/01/2022 5:57 pm
(@edlonar)
Posts: 5
Active Member
Début du sujet
 

Planningelement is in the table list but when I click on it (phpMydamin), I have this erreor : "#1146 - 'projeqtor.planningelement' doesn't exist."

Regards

(Apache 2.4.33 | PHP 7.2.4 | MySQL 5.7.21).
 


 
Posté : 10/01/2022 6:05 pm
(@babynus)
Posts: 14952
Membre Admin
 

So you have an issue on your DB.
Possibly access rights on some tables does not allow DB user to access this table.


 
Posté : 10/01/2022 6:22 pm
(@edlonar)
Posts: 5
Active Member
Début du sujet
 

When I want to list table (and I saw the table in the list but I can't open it), I was connected with the root account with ALL PRIVILEGES GRANTED.

Is there a specific script to rebuilt or check the database conformirty ?

Regards


 
Posté : 10/01/2022 6:25 pm
(@babynus)
Posts: 14952
Membre Admin
 

Hi,
We have a script to check projeqtor data consistency, but not technical integrity of DB.
Have a look at MySql manual. PhpMyAdmin may give hints.


 
Posté : 13/01/2022 12:36 pm
Share:
Retour en haut