Jump to content
MichaMichaMicha

Issue when creating pages with RepeaterField

Recommended Posts

I've stumbled upon a weird issue with repeaters.

I've created a repeaterfield with only a title field and assigned it to a template.

When I create the first page everything goes well, but then when I'm creating additional pages I'm getting this error:

ProcessPageAdd: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'for-page-23947-23799' for key 'name_parent_id'

I'm not getting redirected (probably because of the error, but the page does get created with the RepeaterField correctly).

The problem seems to exist in the file FieldtypeRepeater.module in the function 'getRepeaterPageParent'.

I've modified the file to see what actually happens and it looks like the function doesn't find the required page of saves the page correctly.

protected function getRepeaterPageParent(Page $page, Field $field) { 

		$repeaterParent = $this->getRepeaterParent($field);
		

		
		$parent = $repeaterParent->child('name=' . self::repeaterPageNamePrefix . $page->id . ', include=all'); 
		$this->message("L".__LINE__." | selectorresult: ".$parent->id);
		
		if($parent->id) return $parent; 


		$parent = new Page();
		$parent->template = $repeaterParent->template;

		$this->message("L".__LINE__." | template: ".$repeaterParent->template);
		$this->message("L".__LINE__." | parent: ".$repeaterParent->path);
		$parent->parent = $repeaterParent->id; 
		$parent->name = self::repeaterPageNamePrefix . $page->id;
		$parent->title = $page->name;
		$parent->addStatus(Page::statusSystem);

		// exit early if a field is in the process of being deleted
		// so that a repeater page parent doesn't get automatically re-created
		if($this->deletePageField === $field->parent_id){
			return $parent; 
		}

		$parent->save();
		
		$this->message("L".__LINE__." | looking for: ".self::repeaterPageNamePrefix . $page->id);
		$this->message("L".__LINE__." | current for: ".$parent->name);
		$this->message("L".__LINE__." | Created Repeater Page Parent: NAME={$parent->name} a " . $parent->path, Notice::debug); 

		return $parent; 
	}

See the attachment for the output. IMO the second time FieldtypeRepeater: L574 |  should output the previously created page...

Anyone has an idea what's going wrong? I'm on the latest master branch.

post-943-0-89910200-1403594816_thumb.png

Share this post


Link to post
Share on other sites

Finally got a workaround for this.

Simply added 

$this->pages->uncache($repeaterParent); 

after

https://github.com/ryancramerdesign/ProcessWire/blob/master/wire/modules/Fieldtype/FieldtypeRepeater/FieldtypeRepeater.module#L556

When debugging is on in config.php you see the message twice:

Session: Created Repeater Page Parent: /admin/repeaters/for-field-140/for-page-24397/

Not the prettiest solution but at least the client can add pages again.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By ICF Church
      Hi 👋
      Anyone else having this problem?
      Requirements:
      - Repeater (matrix & normal) with mutlilanguage fields (text, textarea…) 
      - Backend language set to something other than default (ie. German) 
      Reproduce:
      - Add a new repeater Item (ajax, I found no way to possible to disable it with matrix)

      (Notice how the default language tab is active instead of the backend language…)
      - Write something into the (default language) field
      - Try to save, if field is required, this will not work. If not required, then when reloading, the content will be inside the backend language field, instead of the default language field who was (presumably) active
      Analysis:
      When  loading  a new repeater element with ajax, the default langue tab is active, but the backend language inputfield is visible (with no visual indication). When writing into the field, it will populate the backend language. When manually clicking on the default language tab (which is already active), the field will switch to the actual default language field (which is [now] empty) (that can now be populated…)
      Also Notice, the labels of the elements to be added are in default language as well instead of the translated label (images instead of Bilder)…
      ProcessWire 3.0.148, Profields 0.0.5…
      Is it my system configuration, or does anyone else have the same issue? This is a screen recording of the problem:
      Issue: https://github.com/processwire/processwire-issues/issues/1179

      Screen Recording 2020-02-25 at 14.18.31.mov
    • By neonwired
      I have a front end form for creating new pages, repeater and repeater matrix field don't seem to save any data. I was considering handling the data manually but can't seem to get anything useful from the post data, are there any methods i can use?
    • By Pip
      Hi, Everyone! 
      I'm currently working on a page reference field and set it for multiple pages (AsmSelect) for the input. Is there a way for me to add an image field (aka Avatar) and the title of page in the radio button? 
      I used the field name enclosed in the { }. Didn't work. It appeared a text instead. 
      Thanks in advance and hope to hear from you soon!
    • By EyeDentify
      Hello dear PW gurus.

      I have stumbled over a strange error that i all of sudden got when trying to upload an image to a images field on a page.
      There where images allready stored in the field that i wanted to keep, but during the upload the error apear and after that all images are gone from the field and i can´t upload any, i just get the error every time.
      I am running ProcessWire 3.0.153 dev.
      Update:
      After looking in the assets folder i find the folder for the page and the image files seems to be there including the ones i tried to upload when the error occured.
      But they don´t show up in the images field in the page editor.
       
      The error reported:
       
      SQLSTATE[01000]: Warning: 1265 Data truncated for column 'ratio' at row 1 And here is a screenshot of the event:

      The TracyDebugger Error reporting:

      I hope you fine folks could point me in a direction.
      But it seems our old pal set_time_limit() is back.

      Regards, EyeDentify
×
×
  • Create New...