Make WordPress Core

Opened 8 years ago

Last modified 8 years ago

#40487 new defect (bug)

GUID contains more than 255 characters

Reported by: martenbiesheuvel's profile martenbiesheuvel Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 4.7.3
Component: General Keywords:
Focuses: administration Cc:

Description

My website had a strange problem: it couldn't save page edit's anymore. After saving a page, it said: your page is successfully saved (some Dutch translation) but it wasn't. I described everything in this post: http://stackoverflow.com/questions/42099222/wordpress-cant-edit-some-pages-anymore

I found a solution: increase the length of the GUID column in the post table to 500 characters.

Change History (3)

#1 in reply to: ↑ description @martenbiesheuvel
8 years ago

Replying to martenbiesheuvel:

My website had a strange problem: it couldn't save page edit's anymore. After saving a page, it said: your page is successfully saved (some Dutch translation) but it wasn't. I described everything in this post: http://stackoverflow.com/questions/42099222/wordpress-cant-edit-some-pages-anymore

I found a solution: increase the length of the GUID column in the post table to 500 characters.

There was NOTHING in the debug log about this.

#2 @SergeyBiryukov
8 years ago

Hi @martenbiesheuvel, welcome to WordPress Trac!

For some strange reason, the content of the GUID is some text from the page itself! So, it looks like this:
strongWinterwerk%202016-2017/strongU/jij%20bent%20van%20harte%20welkom%20om%20één%20of%20meerdere%20activiteiten%20die%20in%20onze%20gemeente%20worden%20gehouden%20in%20de%20komende%20maanden%20te%20volgen.%20Hierbij%20ontvangt%20u%20de%20seizoenplanning%20en%20meer%20informatie%20over%20clubs%20en%20verenigingen%20
This GUID contains 317 characters. But, the database column can only store 255 characters! I changed it to 500 characters and my website works.

Does it still happen with all plugins disabled and a default theme (Twenty Seventeen) activated?

Normally, GUID is set as a permalink of the page, not the content, so I think this might be a plugin, theme, or some other custom code doing something weird.

Last edited 8 years ago by SergeyBiryukov (previous) (diff)

#3 @martenbiesheuvel
8 years ago

Hmm, I had some plugins installed (Yoast SEO and Advanced Custom Fields). It could be one of them indeed. But, I still expect something in the error log when saving into the database not works.. :)

Note: See TracTickets for help on using tickets.