Forums / Install & configuration / Problem with drafts in ez3.8

Problem with drafts in ez3.8

Author Message

Erlend Halvorsen

Monday 08 May 2006 11:38:17 am

Hi!

After I installed ez 3.8 I get an access denied screen when trying to access an object that someone else is currently editing. The screen says something to the effect of "You either don't have the permissions needed to view this object, or the object does not exist".

Any ideas?

-Erlend

As a side note, is the problems and solutions related to stale drafts (outlined in this post http://walhalla.wordpress.com/?s=drafts&searchbutton=go%21 by Borgermans) fixed/implemented in 3.8?

Paul Borgermans

Monday 08 May 2006 12:52:51 pm

Hi Erlend,

We'll take a look at this, as it is probably related to the stale drafts feature. Is the other user really still logged in? In our patch a stale draft is ignored if the user is no longer logged in (or expired). In the 3.8 implementation, there is a delay introduced ... which puzzles me for the reasoning behind it.

Stay tuned

--paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Erlend Halvorsen

Monday 08 May 2006 1:22:00 pm

Yes, the user is still loged in.

Just to clarify, the screen i get says this:

The requested page could not be displayed. (1)

The system is unable to display the requested page because of security issues.

Possible reasons:

* Your account does not have the proper privileges to access the requested page.
* The requested page does not exist. Try changing the URL.

And the debug output looks as follows:

Notice: eZMySQLDB::query(0.000 ms) query number per page:0 May 08 2006 16:19:53

SET NAMES 'latin1'

Notice: eZMySQLDB::query(1 rows, 0.819 ms) query number per page:1 May 08 2006 16:19:53

SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='efeb391bdf718d19d19db9158462b620'

Notice: eZMySQLDB::query(0 rows, 0.225 ms) query number per page:2 May 08 2006 16:19:53

SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'

Notice: eZMySQLDB::query(0 rows, 0.205 ms) query number per page:3 May 08 2006 16:19:53

SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'

Notice: eZMySQLDB::query(0 rows, 0.197 ms) query number per page:4 May 08 2006 16:19:53

SELECT destination_url, forward_to_id
FROM ezurlalias
WHERE source_md5 = '222521b17f380e12c9e914e97bc68980' AND
is_wildcard = 0
ORDER BY forward_to_id ASC, is_internal ASC
LIMIT 0, 1

Timing: May 08 2006 16:19:53

Module start 'content'

Notice: eZMySQLDB::query(1 rows, 0.252 ms) query number per page:5 May 08 2006 16:19:53

SELECT ezcontentobject.*
FROM
ezcontentobject
WHERE
ezcontentobject.id='73'

Notice: eZMySQLDB::query(2 rows, 0.167 ms) query number per page:6 May 08 2006 16:19:53

SELECT id, name, locale, disabled
FROM ezcontent_language
ORDER BY name ASC

Notice: eZMySQLDB::query(1 rows, 0.310 ms) query number per page:7 May 08 2006 16:19:53

SELECT id, version, name, identifier, contentobject_name, creator_id, modifier_id,
created, remote_id, modified, is_container, always_available
FROM ezcontentclass
WHERE id='1' AND version='0'
ORDER BY version ASC
LIMIT 0, 2

Notice: eZMySQLDB::query(0 rows, 0.191 ms) query number per page:8 May 08 2006 16:19:53

SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version
WHERE contentobject_id='73' AND status='5' AND creator_id='14'
ORDER BY version ASC

Notice: eZMySQLDB::query(1 rows, 1.770 ms) query number per page:9 May 08 2006 16:19:53

SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version
WHERE contentobject_id='73' AND status IN ( '0', '5' ) AND initial_language_id='2'
ORDER BY version ASC

Error: error/view.php May 08 2006 16:19:53

Error ocurred using URI: /content/edit/73/f/eng-GB

Warning: PHP May 08 2006 16:19:53

array_keys(): The first argument should be an array in /home/rosmersh/public_html/kernel/error/view.php on line 150

Warning: PHP May 08 2006 16:19:53

Invalid argument supplied for foreach() in /home/rosmersh/public_html/kernel/error/view.php on line 150

Warning: PHP May 08 2006 16:19:53

Cannot use a scalar value as an array in /home/rosmersh/public_html/kernel/error/view.php on line 153

Warning: PHP May 08 2006 16:19:53

Invalid argument supplied for foreach() in /home/rosmersh/public_html/kernel/error/view.php on line 153

Warning: Insufficient permissions May 08 2006 16:19:53

Function required:
Policies that didn't match:

Timing: May 08 2006 16:19:53

Module end 'error'

Notice: eZMySQLDB::query(1 rows, 0.512 ms) query number per page:10 May 08 2006 16:19:53

SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name,
ezcontentclass.identifier as class_identifier
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id IN ( 2 ) AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 0

and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)

Notice: eZMySQLDB::query(0 rows, 0.261 ms) query number per page:10 May 08 2006 16:19:53

SELECT id, session_id, productcollection_id, order_id
FROM ezbasket
WHERE session_id='efeb391bdf718d19d19db9158462b620'

Notice: eZMySQLDB::query(1 rows, 0.254 ms) query number per page:11 May 08 2006 16:19:54

SELECT ezcontentobject.*
FROM
ezcontentobject
WHERE
ezcontentobject.id='14'

Notice: eZMySQLDB::query(1 rows, 0.404 ms) query number per page:12 May 08 2006 16:19:54

SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=14 AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id

Notice: eZMySQLDB::query(0 rows, 0.293 ms) query number per page:13 May 08 2006 16:19:54

SELECT id, productcollection_id, contentobject_id, item_count, price, is_vat_inc, vat_value,
discount, name
FROM ezproductcollection_item
WHERE productcollection_id='0'

Notice: eZMySQLDB::query(0 rows, 0.283 ms) query number per page:14 May 08 2006 16:19:54

SELECT id, user_id, node_id, name
FROM ezcontentbrowsebookmark
WHERE user_id='14'
ORDER BY id DESC

Timing: May 08 2006 16:19:54

End

Paul Borgermans

Monday 08 May 2006 2:04:24 pm

Thanks for the debug output, it will help to pinpoint the issue. In any case, the basic message is right: editing should not be possible. The message could be a bit "prettier"

--paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Erlend Halvorsen

Monday 08 May 2006 2:17:05 pm

> Thanks for the debug output, it will help to pinpoint the issue. In any
> case, the basic message is right: editing should not be possible. The
> message could be a bit "prettier"

ah.. because earlier you could create your own draft, you just had to click through a warning. Im thinking maybe everything is in order then. I can access the object now, don't know if my client actually discarded his draft, or if ez is just ignoring his draft now.

-Erlend

liu spider

Monday 08 May 2006 2:26:02 pm

I can confirm I encountered the exact same issue with ez3.8

http://liucougar.scim-im.org
SCIM Input Method Platform
http://scim.sf.net
SJSD Online Editor
http://sf.net/projects/sjsd