Share » Forums » Install & configuration » Forum & approve workflow problem

Forum & approve workflow problem

Forum & approve workflow problem

Friday 12 January 2007 11:17:19 am - 8 replies

Modified on Friday 12 January 2007 11:18:01 am by Vjeran Vlahovic

Author Message

Ɓukasz Serwatka

Monday 15 January 2007 12:06:12 am

There might be some database inconsistency. Did you compare data for approved and returned posts in database? Database base is good start point also do some debugging around line 611 kernel/classes/workflowtypes/event/ezapprove/ezapprovetype.php.

If still no luck then I suggests contact support[at]ez.no

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Kristof Coomans

Monday 22 January 2007 2:18:53 am

Hi Vjeran

Have you been able to solve the problem?

Cheers

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Vjeran Vlahovic

Friday 26 January 2007 6:10:23 pm

Hi Kristof & Lukasz,
thanks for your replies. I (kinda) solved this problem, with the help of Konrad, polish eZ superhero :)

Workflow.php execution was failing because the ezcollab_item.data_int2 pointed to non-existent object version (it contained value 1, but for that object [forum topic] only version 2 and 3 existed). ezcontentobject.current_version of that object also contained 1. So I changed data_int2 to 3, run the workflow.php again and it worked :)

I still don't know what caused this inconsistency :(

http://www.netgen.hr/eng

Dario Betti

Wednesday 21 November 2007 2:04:00 am

Hi, I've got the same problem, but unfortunately I don't understand the solution of Vjeran:

- where is "ezcollab_item.data_int2"?
- how can I change it?

Thanks a lot in advance!
Dario

Vjeran Vlahovic

Wednesday 21 November 2007 9:55:34 am

Hi Dario,
data_int2 is an attribute of ezcollab_item table in eZ publish database. There are several tools you can use to connect to a database and alter data, for instance phpMyAdmin, which is probably allready installed on your web server.

Good luck!
Vjeran

http://www.netgen.hr/eng

Dario Betti

Wednesday 21 November 2007 3:31:47 pm

Hi Vjeran,

thanks a lot for your quick answer.

Tomorrow I'll try to inspect and if necessary change the data_int2 value!

Dario Betti

Tuesday 27 November 2007 12:31:17 am

Hi Vjeran,

my "ezcollab_item" table is made of 519 rows... how I could understand which rows have wrong version number? Do I have to compare with "ezcontentobjectcurrent_version" table? But you said in ezforum this last table reports too wrong data?

Or I could delete all rows in the ezcollab_item table?

Thanks a lot in advance,
Dario

Dario Betti

Friday 30 November 2007 7:40:25 am

Finally I solved my issue deleting all the rows in the following tables:

- ezapprove_items
- ezcollab_item
- ezworkflow_process

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu