error on recalculate project

ekolossov
Topic Author
Offline
Platinum Member

31 Jul 2013 16:57 #1 by ekolossov

error on recalculate project was created by ekolossov

Please see attachment

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

babynus
Offline
Administrator
Moderator

31 Jul 2013 17:49 #2 by babynus

Replied by babynus on topic error on recalculate project

It seems clear : Out of Memory.

Maybe you tried to plan too many activities in one step.
=> try planning project by project or allocate more memory to PHP server.

Babynus
Administrator of ProjeQtOr web site

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

ekolossov
Topic Author
Offline
Platinum Member

01 Aug 2013 13:32 - 01 Aug 2013 13:59 #3 by ekolossov

Replied by ekolossov on topic error on recalculate project

more memory allocation not help at all.
some more errors from log:
2013-08-01 11:17:10 ***** ERROR ***** Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
2013-08-01 11:17:10 ***** ERROR ***** For query : select * from dependency where successorId in (0,)
2013-08-01 11:17:10 ***** ERROR ***** Strack trace :
2013-08-01 11:17:10 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projectorria/model/persistence/SqlElement.php:1268]
2013-08-01 11:17:10 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/localhost/htdocs/projectorria/model/PlanningElement.php:854]
2013-08-01 11:17:10 ***** ERROR ***** #2 PlanningElement->initializeFullList called at [/var/www/localhost/htdocs/projectorria/model/PlannedWork.php:135]
2013-08-01 11:17:10 ***** ERROR ***** #3 PlannedWork->plan called at [/var/www/localhost/htdocs/projectorria/tool/plan.php:18]
2013-08-01 11:17:16 ***** ERROR ***** Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
2013-08-01 11:17:16 ***** ERROR ***** For query : select * from dependency where successorId in (0,)
2013-08-01 11:17:16 ***** ERROR ***** Strack trace :
2013-08-01 11:17:16 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projectorria/model/persistence/SqlElement.php:1268]
2013-08-01 11:17:16 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/localhost/htdocs/projectorria/model/PlanningElement.php:854]
2013-08-01 11:17:16 ***** ERROR ***** #2 PlanningElement->initializeFullList called at [/var/www/localhost/htdocs/projectorria/model/PlannedWork.php:135]
2013-08-01 11:17:16 ***** ERROR ***** #3 PlannedWork->plan called at [/var/www/localhost/htdocs/projectorria/tool/plan.php:18]

and additional screenshot

Last edit: 01 Aug 2013 13:59 by ekolossov. Reason: additional information

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

babynus
Offline
Administrator
Moderator

01 Aug 2013 14:18 #4 by babynus

Replied by babynus on topic error on recalculate project

Hi,

Strange issue.
It seems you are planning no activity...

1) can you check table planningelement : check that idProject is never 0, and that refType and refId are always set (not null)

2) can you try this patch :
in /model/PlanningElement.php, replace line 851 with :

$crit='successorId in (0' . (($idList and count($idList)>0)?',' . implode(',',$idList):'') . ')';

Babynus
Administrator of ProjeQtOr web site

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

ekolossov
Topic Author
Offline
Platinum Member

01 Aug 2013 14:37 #5 by ekolossov

Replied by ekolossov on topic error on recalculate project

Looking like we found an issue and fixed it. we have moved group of tasks from one project to another and this have caused the problem

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

babynus
Offline
Administrator
Moderator

01 Aug 2013 14:59 #6 by babynus

Replied by babynus on topic error on recalculate project

Sorry, I don't understand your message.

Did the action to move the tasks "create" or "fix" the issue ?

Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion

Time to create page: 0.045 seconds

error on recalculate project

Attachments:

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

error on recalculate project

Attachments:

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Login Form