ExpressionEngine icon indicating copy to clipboard operation
ExpressionEngine copied to clipboard

Entry revisions appear under wrong username

Open silenz88 opened this issue 4 years ago • 6 comments

EE 5.3.2 upgraded from 2.11.9.

I'm experiencing a weird issue with entry revisions. Namely that seemingly random entry revisions (of entries created after the update) show the screen name of the first super-admin (member_id 1) as author, although that account is definitvely never used to log-in and/or edit entries.

I stumbled upon this due to another issue, that seems to be related to revisions resulting in a PHP-error that happens somethimes when you save an entry:

screenshot

silenz88 avatar Jan 07 '21 17:01 silenz88

Those entry-revisions under the false member_id actually don't contain entry-data but comment data.

silenz88 avatar May 23 '23 08:05 silenz88

Do comment data give any clue of when / how those revisions were created?

intoeetive avatar May 23 '23 10:05 intoeetive

The entry dates correspond with the time of the comment postings.

How? No idea.

a:15:{s:3:"ACT";s:1:"1";s:3:"RET";s:152:"0EFFpNCM4elTiBj5x9IbO721Cj7ec/7VP2lKB+OWZJA98FpoZcK58MX4dtObkinGPv5E58VOzvBg/c0i+ekRTFhf+n7o3yHYX5qWxp2X2kzVal/xrKIVyJy2xf4ihMgc4sEq8/lSAO34pJfNnwg12Q==";s:3:"URI";s:16:"foo/comments/bar";s:3:"PRV";s:0:"";s:8:"entry_id";s:4:"6520";s:9:"parent_id";s:1:"0";s:7:"site_id";s:1:"1";s:7:"comment";s:11:"Lorem ipsum";s:4:"name";s:8:"John Doe";s:5:"email";s:12:"[email protected]";s:3:"url";s:7:"http://";s:7:"captcha";s:5:"for37";s:9:"save_info";s:3:"yes";s:10:"disclaimer";s:2:"on";s:8:"location";s:0:"";}

silenz88 avatar May 23 '23 18:05 silenz88

Can you check your exp_actions DB table and tell me what is method for action_id 1? If it's submit_entry then the revision probably corresponds to entry being created in Channel Form - however the data seem to belong to comment form... Is there a chance you have a somewhat broken template somewhere, where comment form is inside channel form, or vice versa?

intoeetive avatar May 25 '23 13:05 intoeetive

action_id 1 is 'insert_new_comment'

Template structure is a pretty basic single-entry blog page:

{exp:channel:entries} ... {/exp:channel:entries}
{exp:comment:entries} ... {/exp:comment:entries}
{exp:comment:form} ... {/exp:comment:form}
{exp:channel:entries} ... {/exp:channel:entries}

Nothing is nested or otherwise fancy. No channel form.

For now I deleted all revisions containing s:3:"ACT";s:1:"1"; from the database. I will check back next week whether new comments will have created new pseudo-revisions.

silenz88 avatar May 25 '23 21:05 silenz88

@silenz88 did you ever see this issue happen again?

intoeetive avatar Dec 04 '23 15:12 intoeetive