Thread

Hey all,

We’re having an issue with a client that is running IE 8 on v2.1.0 Build 20101020. When she tries to pull up the Search Terms Log she gets the following error:

“Datatables warning: Added data does not match known number of columns”

Anyone else having this issue? Thanks!

DHD Chicago,

Welcome to the forums 😊

Can you confirm if this happens in other browsers?

v2.1.0 Build 20101020

Build 20101020 is actually version 2.1.1
Did you get this detail from teh cp footer or the ExpressionEngine Info Accessory. The cp footer ones are the details we need?

Was this a fresh install of EE2 or did you recently do a version update?

If you did are you sure you followed the version update docs as opposed to the build update docs.
You would have had to run an update wizard in your browser

Do a full backup of your database and try repairing your tables to see if issue persists

Hi John,

Thanks for getting back to us. My mistake, it is actually 2.1.1 and build 20101020. For some reason the Expression Engine Info tab says 2.1.0 and I just copied and pasted, but the CP footer is correct.

The client is using IE 8, the issues does not appear to happen in any other browsers including versions 6 / 7 of IE. This was an update from 1.x. I am pretty sure that we did a version update with the wizard. 

This is the first time a client of ours has tried to use the search logs so we didn’t notice the issue on any of our other installs.

I noticed another thread with similar issues. Do you know if this went anywhere?

http://ellislab.com/forums/viewthread/167396/

Thanks much!

John,

A few more details. I did a database repair and the issue still persisted. It actually throws up an alert box that gets duplicated for every row in the table. The user has to click ok x amount of times before it closes. It locks up the whole browser otherwise.

Tested again in IE 7. Slightly different issue. In 7 we don’t get the alert box, but after the table gets displayed it clears from the screen and in the first column we get an “invalid results” error. Firefox Chrome and Safari seem to be fine.

Thanks again.

Can you please try to upload a fresh set of EE files? Make sure you include all theme files etc. as well.

Just tested it on a clean install on a different dev server. Same issue. It happens on the CP log view page as well.

Screenshot attached. Any help greatly appreciated.

This is only happening with IE8, correct? Looks like a possible UA issue to me.

Yes. IE 7 and 8. It’s worse in 8 though because it throws up an alert box for every row. In 7 it doesn’t, just lists invalid results in the first column. We’ve tested it on a number of machines and we can recreate it pretty easily. Can the devs take a look? Normally I wouldn’t mind because it’s just logs, but this particular client wants the reports. Thanks again.

Hi DHD Chicago,

I tracked down the issue and this will be fixed in the next release. To fix it now, open system/expressionengine/controllers/cp/tools_logs.php and add

$col_defs = rtrim($col_defs, ', ');

around line 845, just before

if ($final_check == TRUE)

Let me know if that works for you.

Thanks Brandon! That was it. Appreciate you jumping on it so quick and hopefully this helps some others.

Glad that works! Thanks and don’t hesitate with additional questions.