On an upgraded system now running the latest (MT4.01) everything seems to work right except the publish site option. On any of the blogs in the installation running a full publish gives the following error when publishing Index Only.

Non-numerics in limit/offset clause (20 , 0) at lib/MT/ObjectDriver/SQL.pm line 262.

I added the EntriesPerRebuild to the mt-config.cgi just in case but it has no effect. I'm off to start deleting index templates to see if one in particular causes problems...

Problem solved

Originally I thought this was an issue with AJAXRatings, because the only template that wouldn't rebuilt had this line:

<MTAjaxRatingEntries sort_by="average" show_n="20 "hot="1">

I looked a little closer and noticed the show_n line had an extra space after the 20. Removing the space fixed the error. This extra space problem affects MTEntries as well. For example:

<MTEntries lastn="20 ">

Will produce the same SQL ObjectDriver error.

Yuk. Did you submit this as a bug? Seems like it'd be something that could probably be avoided in most cases with some minor sanitizing of the attribute values.

I just sent it. It does seem rather odd that an obvious non-numeric would get passed that far down the stack.