Fix Log Display Screen

[joshbetz]

The Syndication Logs screen is a little broken. It looks like we use the same query on every page and filter in PHP. This creates a couple problems

• We only get the most recent logs. On an active site, the related logs can scroll out of range before you even get a chance to look.
• You can't get all the, for example, errors on a single page. There's always the same number of pages, and we just filter out other messages. You can end up with page 1 being empty, page 2 having 1 error entry, etc.

SELECT post_id, meta_value
FROM wp_postmeta
WHERE meta_key = 'syn_log'
GROUP BY post_id
ORDER BY meta_id DESC
LIMIT 0, 100

[joshbetz]

We also limit the number of logs that we store, so we should increase or remove that limit.

[GaryJones]

Moving to 3.0.0 milestone.

This issue requires significant architectural changes to the logging system. The current implementation stores logs as serialized arrays in post_meta and performs filtering/pagination in PHP rather than SQL. Fixing this properly would likely require:

1. A dedicated database table for logs with proper indexing
2. SQL-level filtering and pagination
3. Changes to how logs are written and retrieved

This is beyond the scope of 2.2.0 but should be addressed in the 3.0.0 refactoring work.