4

After playing with structure, the navigation tree was broken.

enter image description here

Unforchently we don't have a DB backup. Any advice how to fix it?

Thx!

2

Most probable that some entries were deleted from the system, but still they still in structure exp_structure table.

One-step solution:

DELETE FROM exp_structure WHERE entry_id not IN ( Select entry_id from exp_channel_titles )

Two-step solution (if u want to validate results):

  1. Find missed records:

    SELECT GROUP_CONCAT(entry_id) as entry_ids FROM exp_structure WHERE entry_id NOT IN (Select entry_id from exp_channel_titles)

  2. Delete missed records, using results of the first query in next query (instead of XXXXXXXX)

    DELETE FROM exp_structure WHERE entry_id IN ( XXXXXXXX )

2

This is from duplicate ordering values. Run our debug mode: http://buildwithstructure.com/documentation/debug_mode_for_page_data/

  • Thanks, Travis! Max solution helps me this time, but next time I will try to activate debug mode. – NTd Nov 3 '15 at 17:41
  • RTFM. Always. Sorry - I missed this debug option. Next I will also use debug mode:) – Max Lazar Nov 3 '15 at 17:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.