Forums / Developer / WorkFlow admin "My pending Items" is empty..

WorkFlow admin "My pending Items" is empty..

Author Message

Akhilesh Singh

Thursday 11 March 2010 4:27:23 am

Hi
I have created an workflow for first time.
My work flow is like this:
1. Editor Makes some edits in folder class object publishes it.(it should not published to user site now)
2. Administrator approves it and now the content should be published to user site.
When i create an folder class object in my site and publish it with Editor login it is stored in "My pending Items"
My issue is that when i check with admin login there is nothing in "My pending Items".
can any one help me in this please.
If u need more info of how i have created this workflow to get better idea about the issue please feel free to ask me more details..
Thank you,
Akhilesh

Robin Muilwijk

Thursday 11 March 2010 5:14:50 am

Hi Akhilesh,

Do you have the cronjobs configured? One of those cron tasks processes the workflows.

Regards Robin

Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.

LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

Akhilesh Singh

Friday 12 March 2010 2:00:26 am

Hi Robin,
Thank you for replying ...

I don't have much idea about configuring cronjobs.
I have referred a document for setting up an work flow steps involved in this are:
In Standard workflow, created New workflow "Approve" with Event/Multiplexer choice from the select form.
for Classes, in order to run the workflow, I selected folder values.
Administrator users in the Users without workflow IDs.
And then created another workflow naming "approving system" by selecting Event/Approve from the select form.
All sections value for the Affected sections
All versions Affected versionsAdministrator users group for Groups who Approve Content and Excluded user groups area.
Saved my new workflow.
I have re-edit the "Approve" workflow and select the "approving system" workflow as the Workflow to run.
And then in Triggers tab
For the content module of the publish before function, I have choosen the workflow "Approve".
This is all what i have done by referring an document.
but I don't thing i have configured cronjobs for this as it was not mentioned in document or i didn't get, can you please guide me how to configure cronjobs for this. we have setup this site on WINDOWS XP SYSTEM
or is there any issue in the steps which i have followed to create Workflow .....

Really sorry for long reply but i am creating workflow for first time and i really need this so please guide me..
Thank you in advance..
Akhilesh

Robin Muilwijk

Friday 12 March 2010 11:05:49 am

Hi Akhilesh,

I suggest you read the following pages first; http://ez.no/doc/ez_publish/technical_manual/4_x/features/cronjobs.

There are ways of doing the same on a Windows server. If you can not find any docs on that let me know.

Regards Robin

Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.

LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

Akhilesh Singh

Thursday 18 March 2010 12:08:38 am

Hi Robin,
Sorry for late replying, because I was trying it from last 2-3 days but not succeed.
I have tried this command

php runcronjobs.php -d -s plain_site group_of_tasks;

in windows DOS.
I got below output:

Using siteaccess plain_site for cronjobError initializing script: database error: .

#################################### DEBUG ####################################
Warning: (eZMySQLiDB)MySQLi extension was not found, the DB handler will not be initialized.

Total script time: 4.3799 sec

but further I won't get anything.can you plz elaborate more regarding this
Thank You,
Akhilesh

Robin Muilwijk

Saturday 20 March 2010 12:08:57 pm

Hi Akhilesh,

What if you simply run

php runcronjobs.php

Do you get any errors then?

Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.

LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

Akhilesh Singh

Monday 22 March 2010 2:03:38 am

Hello Robin,
I have executed the command as you said,

php runcronjobs.php

but it comes with below error,

Error initializing script: database error: .

Please suggest,
Thank You,
Akhilesh

Robin Muilwijk

Monday 22 March 2010 12:02:43 pm

Hi,

Check out http://share.ez.no/forums/general/help-cron-job-db-error. The exact same problem is described, and fixed. Can you let me know here if that topic helps in fixing your problem also?

Regards Robin

Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.

LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

Akhilesh Singh

Tuesday 23 March 2010 4:29:44 am

Hello Robin,

I have gone through the document which you have suggested, it is very helpful to me.

I followed the given steps from that documents as below,
1. Command:

php runcronjobs.php

Output:

Error initializing script: database error: No database handler was found for 'ezmysqli'.

2. I have cross-checked with

Command:

php --version

Output:

PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies

3. Then I checked,

Command:

php -m

the output comes with the list of activated modules in php.

But as per document I don't get mysql & mysqli modules in this output, can you please give me idea how to activate module in php. then also I went further.

4. Command:

php runcronjobs.php -d

Output:

Error initializing script: database error: No database handler was found for 'ezmysqli'.

#################################### DEBUG #################################### 
Error: (eZINI)
Undefined variable: 'DebugAccess' in group 'SiteAccessSettings' in site.ini

Error: (eZINI)
Undefined variable: 'ExtensionDirectory' in group 'ExtensionSettings' in site.ini

Error: (eZINI)
Undefined variable: 'ActiveAccessExtensions' in group 'ExtensionSettings' in site.ini

Warning: (PHP: E_WARNING) 
array_merge(): Argument #2 is not an array in S:\lib\ezutils\classes\ezextension.php on line 80

Warning: (PHP: E_WARNING)
array_unique(): The argument should be an array in S:\lib\ezutils\classes\ezextension.php on line 87

Warning: (PHP: E_WARNING)
Invalid argument supplied for foreach() in S:\lib\ezutils\classes\ezextension.php on line 102

Error: (eZINI)
Undefined variable: 'UseSlaveServer' in group 'DatabaseSettings' in site.ini

Error: (eZINI)
Undefined variable: 'UseBuiltinEncoding' in group 'DatabaseSettings' in site.ini

Error: (eZExtension::getHandlerClass)
Unable to find variable ImplementationAlias in section DatabaseSettings in file site.ini

Error: (eZINI)
Undefined variable: 'DebugTransactions' in group 'DatabaseSettings' in site.ini

Error: (eZINI)
Undefined variable: 'QueryAnalysisOutput' in group 'DatabaseSettings' in site.ini

Error: (eZDB::instance)
Database implementation not supported: ezmysqli

Total script time: 4.4112 sec

I didn't get what they said regarding "safe mode / open_base_dir".

how to enabled/disabled "safe mode / open_base_dir".
Please me take me out from this, I really stuck here..

Thank You,
Akhilesh

Robin Muilwijk

Tuesday 23 March 2010 12:24:52 pm

Hi,

If you have this installed on a local machine, find the php.ini file. Then do a search for safe mode, edit this when it is set to on and make sure it is set to off instead.

Also search for extension=php_mysql.dll and extension=php_mysqli.dll, make sure those lines are not commented out.

Once you have made the alterations, restart your webserver and see if it works.

-- Robin

Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.

LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

Akhilesh Singh

Tuesday 23 March 2010 11:25:39 pm

Hello Robin,

In my php.ini files the required extensions are already uncommented.
and is same in the case of "safe mode / open_basedir" it is already disabled.

just look at this

extension=php_mysql.dll
extension=php_mysqli.dll
safe_mode = Off
;open_basedir =

So what to do then ........

Thank You,
Akhilesh

Robin Muilwijk

Friday 26 March 2010 12:11:38 pm

I'm out of ideas, anyone else on this?

-- Robin

Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.

LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

Akhilesh Singh

Sunday 28 March 2010 9:55:16 pm

Thanx Robin for your time and help .........

can any one else help me on this plzzz..?

Thank you
Akhilesh