Server Log Translation Help

[chipbennett]

Can anyone translate the following, and help me determine where I'm having problems?

Id User Host db Command Time State Info
38644 [username] localhost [database] Query
7 Opening tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38646 [username] localhost [database] Query
5 Opening tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38647 [username] localhost [database] Query
1 Opening tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38648 [username] localhost [database] Sleep
2 NULL
38649 [username] localhost [database] Sleep
4 NULL
38650 [username] localhost [database] Query
5 closing tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38652 [username] localhost [database] Query
3 closing tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38653 [username] localhost [database] Query
4 Opening tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38654 [username] localhost [database] Query
1 Opening tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38656 [username] localhost [database] Query
18 closing tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38657 [username] localhost [database] Query
3 Opening tables SELECT * , IF (DATE_ADD(link_updated, INTERVAL
120 MINUTE) >= NOW(), 1,0) as recently_updated FRO
38658 [username] localhost [database] Sleep
2 NULL

Whatever the error is, my host has disabled PHP for my site because of it.

*pissed at my host*

Thanks in advance!

[Otto]

Somewhere, you're calling wp_list_bookmarks with show_updated = true (1, whatever).

[chipbennett]

Somewhere, you're calling wp_list_bookmarks with show_updated = true (1, whatever).

Awesome; thanks!

That, I can track down.

So, to help me learn: how did you get that error out of what's in the server log?

EDIT:

Is it the "DATE_ADD(link_updated" that gives it away?

Is there anything else that could cause it? I'm looking at my bookmarks widget in functions.php, and I don't even reference "show_updated" in the function call. (I actually have two such widgets, and verified both.)

I've checked every file in my theme...

[chipbennett]

I think I may have found it: the Series plugin.

The Series plugin includes a widget that displays a list of posts in a series (custom taxonomy). That widget includes an "orderby" parameter, that has an "modified" option. (orderby -> updated) and a "date" option (orderby -> date).

Could this be what is making the database query above?

[chipbennett]

Any thoughts?

I've combed through every file in my theme, and have browsed darn-near every plugin. I can't find any calls to wp_list_bookmarks with the show_updated parameter declared to 'true'.

Of course, until my web host re-enables PHP on my site, I can't do any troubleshooting.