WordPress.org

Make WordPress Core

Opened 8 years ago

Closed 6 years ago

#2859 closed defect (bug) (worksforme)

Databasequeries of a static page using permalinks

Reported by: skydrak Owned by: markjaquith
Milestone: Priority: normal
Severity: normal Version: 2.0.3
Component: Optimization Keywords: queries page
Focuses: Cc:

Description

If I browse a static page by a permalink Wordpress the page and all before posted static pages were queryed.

If I browse the page by the ID (?page_id=) Wordpress only query the specified page and not the static pages who were posted before.

I've logged the queries: http://pastebin.com/727414

Change History (4)

comment:1 markjaquith8 years ago

  • Component changed from Administration to Optimization
  • Owner changed from anonymous to markjaquith
  • Status changed from new to assigned
  • Version set to 2.0.3

If this is happening on every page load, that's because you've enabled WP's file system object cache, but something is wrong with the file permissions, so it can't write the data to the cache. It's normal for this to happen once, to populate the cache.

Still, this method of finding the correct subpage won't scale well, so it should probably change. Maybe we just need to write the fullpath info to the page, or store it in post meta. There has to be a better way that querying (whether from the cache or from the DB) every post and looping through them looking for the right one.

comment:2 skydrak8 years ago

Have approved the permissions of the folder "cache" but it doesn't take effect of the queries. But now Wordpress has permissions to write into cache, it was a SAFEMOD Restriction problem.

comment:3 Nazgul7 years ago

  • Milestone set to 2.4 (future)

comment:4 pishmishy6 years ago

  • Milestone 2.5 deleted
  • Resolution set to worksforme
  • Status changed from assigned to closed

Not entirely sure what this ticket is about but it's not seen much discussion so presuming it now works for the reporter and closing.

Note: See TracTickets for help on using tickets.