Forums / Install & configuration / Workflow errors

Workflow errors

Author Message

Eivind Marienborg

Wednesday 25 January 2006 7:45:32 am

On one of the sites I'm running, users can sign up, but have to get approved (using the collaboration-system) before actually being published, and thus able to log in.

Having runned this system for quite som time, I have discovered some mysterious behaviour from the system.

The objects appear in the collaboration-list. I enter the objects, and approve them for publishing. A cronjob-runned workflow runs the workflow.php script. But now it turns out that some objects doesn't get published.

Running the workflow-script manually with debug enabled, outputs this:

Running cronjobs/workflow.php
Checking for workflow processes

PHP Fatal error:  Call to a member function on a non-object in /data/www/html/vhost/dev.site.no/kernel/classes/workflowtypes/event/ezmultiplexer/ezmultiplexertype.php on line 214

Fatal error: eZ publish did not finish its request
The execution of eZ publish was abruptly ended, the debug output is present below.
Timing: ()
Script cronjobs/workflow.php starting

Warning: (PHP)
Undefined index:  no-cache-adviced in /data/www/html/vhost/dev.site.no/lib/ezi18n/classes/eztstranslator.php on line 64

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Error: (eZContentObject::fetch())
Object not found (29036)

Error: (Empty body memento in workflow.php)


Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Error: (eZContentObject::fetch())
Object not found (18092)

Error: (Empty body memento in workflow.php)


Error: (eZContentObject::fetch())
Object not found (27273)

Error: (Empty body memento in workflow.php)


Error: (eZContentObject::fetch())
Object not found (15700)

Error: (Empty body memento in workflow.php)


Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Error: (eZContentObject::fetch())
Object not found (16732)

Error: (Empty body memento in workflow.php)


Error: (eZContentObject::fetch())
Object not found (41355)

Error: (Empty body memento in workflow.php)


Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Warning: (PHP)
Use of undefined constant EZ_APPROVE_COLLABORATION_NOT_CREATED - assumed 'EZ_APPROVE_COLLABORATION_NOT_CREATED' in /data/www/html/vhost/dev.site.no/extension/points/eventtypes/event/ezuserapprove/ezuserapprovetype.php on line 257

Error: (eZContentObject::fetch())
Object not found (17058)

Error: (Empty body memento in workflow.php)


Error: (eZContentObject::fetch())
Object not found (32669)

Error: (Empty body memento in workflow.php)


Error: (eZContentObject::fetch())
Object not found (26878)

Error: (Empty body memento in workflow.php)


Error: (eZContentObject::fetch())
Object not found (26878)

Error: (Empty body memento in workflow.php)


PHP Notice:  Undefined variable:  relMemory in /data/www/html/vhost/dev.site.no/lib/ezutils/classes/ezdebug.php on line 1423
Script cronjobs/workflow.php starting 0.0000 sec
Total runtime: 3.4262 sec
Group ini_load:
Load cache: 0.0284 sec (0.8160%), 0.0041 avg sec (7)
Group Mysql Total:
Mysql_queries: 0.7483 sec (21.4680%), 0.0006 avg sec (1239)
Looping result: 0.0865 sec (2.4825%), 0.0001 avg sec (1097)
Group TS translator:
TS init: 0.0090 sec (0.2584%), 0.0045 avg sec (2)
TS cache load: 0.0034 sec (0.0976%), 0.0017 avg sec (2)
TS context load: 0.0016 sec (0.0468%), 0.0008 avg sec (2)

Total script time: 3.4855 sec

The objects remains "unpublished" when I access them in the collaboration view (by clicking them in the collaboration overview, and then the link to their object).

The strange thing is that this seems to happen to random objects.

I'm thinking this might be related to the errors that the workflow-script run into, but tracking down which objects it halts on gets complicated whith no experience with this part of the DB.

Could simply emptying all the collaboration tables be a possible sollution? Or is the data there used even after publishing?

I'm otherwise blank on this. Has anyone runned to this kind of thing before? Any ideas, anyone?

Thanks :)
- Eivind

Leif Arne Storset

Thursday 16 February 2006 8:22:12 am

I have similar problems. I have experienced your problem (random objects not getting published) but it disappeared after I tinkered for a while (I'm sorry to say I didn't record what I did). The problem that remains is that users that register show up directly in the content-object tree, bypassing approval.

I have isolated the bug to the case where ezapprove is set to section Users. If "all sections" is set, the approval process runs normally.

If I run the approval workflow it via the multiplexer, I get similar results: filtering by class or section makes the publishing process bypass approval, while deactivating filtering makes it work.

I get only two error messages running the workflow-cronjob script manually with debug:

Undefined index:  no-cache-adviced in /home/helsekom/public_html/lib/ezi18n/classes/eztstranslator.php on line 64

and

Warning(): User not found, returning anonymous

.

I suspect something within ezapprove breaks during filtering. I will continue to investigate this problem, but am grasping at straws.

I am unsure whether this problem is related to the one you, Marienborg, are experiencing. How do you filter in your workflow? I cannot answer your question about the collaboration table properly, but suspect that its contents are used for the "collaboration/view/summary" view under "My account".

Leif Arne Storset

Leif Arne Storset

Friday 24 February 2006 6:42:01 am

I've had to give up on this problem. :(

Leif Arne Storset

Stéphane Bullier

Wednesday 01 March 2006 7:30:49 am

You have to erase ; in php.ini on line ;extension=mysql.so in section Dynamic Extensions

Stéphane

Leif Arne Storset

Friday 03 March 2006 2:09:28 am

bobo diallo,

Thank you for your suggestion! However, I am a bit confused.

Firstly, when I check php.ini, I find no option extension=mysql.so.

Additionally, though I know little of PHP's internal workings, I would expect that MySQL wouldn't work at all if the MySQL extension wasn't loaded. Does mysql.so perhaps not control all of PHP's MySQL support, but rather a portion of it?

Leif Arne Storset

Kåre Køhler Høvik

Friday 03 March 2006 2:27:15 am

Hi

I think this behavior is related to this bug : http://ez.no/bugs/view/7898
I've got a temporary patch for it ( see attached file ), but please use it with care. The attached patch will not fix workflow processes which have already been started.

Kåre Høvik

eZ debug

Timing: Jan 18 2025 00:59:19
Script start
Timing: Jan 18 2025 00:59:19
Module start 'content'
Timing: Jan 18 2025 00:59:20
Module end 'content'
Timing: Jan 18 2025 00:59:20
Script end

Main resources:

Total runtime1.2768 sec
Peak memory usage4,096.0000 KB
Database Queries207

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0063 587.7031180.8438
Module start 'content' 0.00631.1256 768.5469685.6953
Module end 'content' 1.13200.1447 1,454.2422345.0703
Script end 1.2767  1,799.3125 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00400.3119210.0002
Check MTime0.00140.1082210.0001
Mysql Total
Database connection0.00080.065710.0008
Mysqli_queries1.182292.59222070.0057
Looping result0.00220.17562050.0000
Template Total1.238797.020.6193
Template load0.00220.168920.0011
Template processing1.236596.845920.6183
Template load and register function0.00010.007610.0001
states
state_id_array0.00110.083110.0011
state_identifier_array0.00180.141320.0009
Override
Cache load0.00190.1487450.0000
Sytem overhead
Fetch class attribute can translate value0.00130.104150.0003
Fetch class attribute name0.00100.0817100.0001
XML
Image XML parsing0.00550.429950.0011
class_abstraction
Instantiating content class attribute0.00000.0018120.0000
General
dbfile0.01391.0860440.0003
String conversion0.00000.000430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
6content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
6content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
11content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 30
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs