View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Issue at project creation | table planningelement missing - ProjeQtOr
 
 

Issue at project creation | table planningelement missing

More
10 Jan 2022 15:21 - 10 Jan 2022 15:39 #1 by Edlonar
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:\wampserver\www\Joomla\projeqtor\model\persistence\SqlElement.php:2834]
2022-01-10 15:14:51.172 ***** ERROR ***** [V9.4.1] #1 SqlElement->getSqlElementsFromCriteria called at [C:\wampserver\www\Joomla\projeqtor\view\main.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:\wampserver\www\Joomla\projeqtor\model\persistence\SqlElement.php:3077]
2022-01-10 15:14:53.630 ***** ERROR ***** [V9.4.1] #1 SqlElement->countGroupedSqlElementsFromCriteria called at [C:\wampserver\www\Joomla\projeqtor\view\today.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:\wampserver\www\Joomla\projeqtor\model\persistence\SqlElement.php:2834]
2022-01-10 15:14:53.702 ***** ERROR ***** [V9.4.1] #1 SqlElement->getSqlElementsFromCriteria called at [C:\wampserver\www\Joomla\projeqtor\model\UserMain.php:884]
2022-01-10 15:14:53.703 ***** ERROR ***** [V9.4.1] #2 UserMain->getHierarchicalViewOfVisibleProjects called at [C:\wampserver\www\Joomla\projeqtor\view\today.php:184]
2022-01-10 15:14:53.704 ***** ERROR ***** [V9.4.1] #3 showProjects called at [C:\wampserver\www\Joomla\projeqtor\view\today.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:\wampserver\www\Joomla\projeqtor\tool\jsonQuery.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:\wampserver\www\Joomla\projeqtor\model\persistence\SqlElement.php:3975]
2022-01-10 15:15:26.827 ***** ERROR ***** [V9.4.1] #1 SqlElement->getFormatList called at [C:\wampserver\www\Joomla\projeqtor\model\persistence\SqlElement.php:3517]
2022-01-10 15:15:26.828 ***** ERROR ***** [V9.4.1] #2 SqlElement->getDataType called at [C:\wampserver\www\Joomla\projeqtor\model\persistence\SqlElement.php:3522]
2022-01-10 15:15:26.829 ***** ERROR ***** [V9.4.1] #3 SqlElement->getDataType called at [C:\wampserver\www\Joomla\projeqtor\view\objectDetail.php:1532]
2022-01-10 15:15:26.830 ***** ERROR ***** [V9.4.1] #4 drawTableFromObject called at [C:\wampserver\www\Joomla\projeqtor\view\objectDetail.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:\wampserver\www\Joomla\projeqtor\model\ProjectPlanningElementMain.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.
Last edit: 10 Jan 2022 15:39 by Edlonar. Reason: English translation

Please Log in or Create an account to join the conversation.

More
10 Jan 2022 15:30 #2 by babynus
PLEASE RESPECT FORUM RULES

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
10 Jan 2022 15:42 #3 by Edlonar
English translation done.
Sorry.

best regards

Please Log in or Create an account to join the conversation.

More
10 Jan 2022 15:57 #4 by babynus
Check your DB.
Does table "planningelement" exist ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
10 Jan 2022 16:05 #5 by Edlonar
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).
 

Please Log in or Create an account to join the conversation.

More
10 Jan 2022 16:22 #6 by babynus
So you have an issue on your DB.
Possibly access rights on some tables does not allow DB user to access this table.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.056 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.