Error message on sorting columns

118 views
Skip to first unread message

Henning Kessler

unread,
Sep 14, 2015, 6:04:04 AM9/14/15
to munkireport
Hello,

I guess since I changed to the WIP branch I have an issue when I try to change the sorting order of the table columns. I get the following error message:

DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

How can I solve this issue?

Regards

Henning
Bildschirmfoto 2015-09-14 um 11.53.55.png

A.E. van Bochoven

unread,
Sep 14, 2015, 6:23:06 AM9/14/15
to munki...@googlegroups.com
You probably have an entry in your database that is causing troubles.

What version are you running?

-Arjen


--
You received this message because you are subscribed to the Google Groups "munkireport" group.
To unsubscribe from this group and stop receiving emails from it, send an email to munkireport...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<Bildschirmfoto 2015-09-14 um 11.53.55.png>

Henning Kessler

unread,
Sep 14, 2015, 6:42:00 AM9/14/15
to munkireport
Hi Arjen

Webinterface says: 2.6.0.1444

Henning

A.E. van Bochoven

unread,
Sep 14, 2015, 6:47:42 AM9/14/15
to munki...@googlegroups.com
You should be able to see what’s causing the error if you open developer tools and look at the resources panel:

Henning Kessler

unread,
Sep 14, 2015, 7:10:19 AM9/14/15
to munkireport
I just had a look at the resource panel and the contents of the index.php. It was looking quite okay but then I realized that there were two machines with missing Buildnumbers. After deleting those entries the error didn't appear again.

henning

A.E. van Bochoven

unread,
Sep 14, 2015, 7:12:42 AM9/14/15
to munki...@googlegroups.com
On 14 Sep 2015, at 13:10, Henning Kessler <he.ke...@googlemail.com> wrote:

I just had a look at the resource panel and the contents of the index.php. It was looking quite okay but then I realized that there were two machines with missing Buildnumbers. After deleting those entries the error didn't appear again.

You should scroll through all entries (or use the dropdown to view all) to make sure your problem is resolved.

-Arjen

technica...@electricart.com.au

unread,
Oct 12, 2015, 10:41:58 PM10/12/15
to munkireport
Hi there,

I am also receiving this error.


DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

I was originally upgrading from a previous version, and thought this was the reason, so I wiped the munkireport-php installation completely and started from scratch.

I pulled the latest from git, created the config.php, downloaded the .plist file and installed on a client.

Now every time I try to list clients, I get the DataTables warning error.

Any idea how I can fix this? Seems strange that I would get this error from a clean install. The database is completely new...

kind regards,
Tristan.

technica...@electricart.com.au

unread,
Oct 12, 2015, 10:46:17 PM10/12/15
to munkireport
Just to elaborate, I can't see any clients listed. Please see attached images.
Screen Shot 2015-10-13 at 1.44.47 pm.png
Screen Shot 2015-10-13 at 1.44.55 pm.png

technica...@electricart.com.au

unread,
Oct 12, 2015, 11:17:14 PM10/12/15
to munkireport
I found this when viewing the contents of index.php which doesn't seem right, but not sure if it's causing the issue;

        <thead>
          <tr>
            <th data-i18n="listing.computername" data-colname='machine.computer_name'>Name</th>
            <th data-i18n="serial" data-colname='reportdata.serial_number'>Serial</th>
            <th data-i18n="listing.username" data-colname='reportdata.long_username'>Username</th>
      <th data-colname='machine.os_version'>OS</th>
            <th data-i18n="buildversion" data-colname='machine.buildversion'>Type</th>
      <th data-colname='machine.machine_name'>Type</th>
            <th data-colname='warranty.status'>Warranty status</th>
            <th data-colname='reportdata.uptime'>Uptime</th>
            <th data-colname='reportdata.timestamp'>Check-in</th>
            <th data-colname='munkireport.manifestname'>Manifest</th>
          </tr>
        </thead>


Where I've highlighted 'Type' above, shouldn't it be 'Build Version'? Is this possibly causing the issue? Or is that completely unrelated?

I tried looking at the resource panel in Safari when looking at the page, but I'm not really sure what I should be looking for unfortunately.

Any help with this would be greatly appreciated!

kind regards,
Tristan.

A.E. van Bochoven

unread,
Oct 13, 2015, 12:22:08 PM10/13/15
to munki...@googlegroups.com
I am also receiving this error.

DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

I was originally upgrading from a previous version, and thought this was the reason, so I wiped the munkireport-php installation completely and started from scratch.

What do you mean by 'wiped the munkireport-php installation completely'. Did you also remove the database and what database are you using?


I pulled the latest from git,

What version? 2.5.3?

created the config.php

So what's in config.php?

downloaded the .plist file and installed on a client.

Installing the plist is deprecated and will be removed. Please install manually or use the pkg installer:


Now every time I try to list clients, I get the DataTables warning error.

Any idea how I can fix this? Seems strange that I would get this error from a clean install. The database is completely new...

You can check what is causing the datatables error by looking at the Page Resources in the Safari Developer menu. Check under XHR's what is in index.php

-Arjen


kind regards,
Tristan.

On Monday, 14 September 2015 21:12:42 UTC+10, Arjen van Bochoven wrote:

On 14 Sep 2015, at 13:10, Henning Kessler <he.ke...@googlemail.com> wrote:

I just had a look at the resource panel and the contents of the index.php. It was looking quite okay but then I realized that there were two machines with missing Buildnumbers. After deleting those entries the error didn't appear again.

You should scroll through all entries (or use the dropdown to view all) to make sure your problem is resolved.

-Arjen

technica...@electricart.com.au

unread,
Oct 13, 2015, 8:41:14 PM10/13/15
to munkireport
Hi,

Thanks so much for the quick reply.


On Wednesday, 14 October 2015 03:22:08 UTC+11, Arjen van Bochoven wrote:
I am also receiving this error.

DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

I was originally upgrading from a previous version, and thought this was the reason, so I wiped the munkireport-php installation completely and started from scratch.

What do you mean by 'wiped the munkireport-php installation completely'. Did you also remove the database and what database are you using?

Yes I removed the database and all files. I'm using the default database SQLite.

rm -Rf /local_path_of_munkireport-php
 


I pulled the latest from git,

What version? 2.5.3?


sudo git clone https://github.com/munkireport/munkireport-php /local_path_of_munkireport-php

 
From memory I ended up with 2.6.1? I sorry I can't tell you the exact version as I downgraded back to 2.5.3 (which works great with a few exceptions)
created the config.php

So what's in config.php?

cp /local_path_of_munkireport-php/config_default.php /local_path_of_munkireport-php/config.php


Added the line required for the admin user

$auth_config['someadminuser'] = 'somesecretpassword';

Set the timezone

$conf['timezone'] = 'Australia/Sydney';

Set the IP range

$conf['ip_ranges']['SurryHills'] = array('192.168.1.','192.168.2.','192.168.3.');

Set the temperature unit

//$conf['temperature_unit'] = 'C';

All other settings as per the default config.php

 

downloaded the .plist file and installed on a client.

Installing the plist is deprecated and will be removed. Please install manually or use the pkg installer:



Ok can do.

I did test first on a single client with;

sudo /bin/bash -c "$(curl -s http://example.com/index.php?/install)"
 
And had still had the error.

Now every time I try to list clients, I get the DataTables warning error.

Any idea how I can fix this? Seems strange that I would get this error from a clean install. The database is completely new...

You can check what is causing the datatables error by looking at the Page Resources in the Safari Developer menu. Check under XHR's what is in index.php


XHRs don't appear to be listed under Resources for index.php?


kind regards,
Tristan.
Screen Shot 2015-10-14 at 11.38.15 am.png

A.E. van Bochoven

unread,
Oct 14, 2015, 1:22:42 AM10/14/15
to munki...@googlegroups.com
--
You received this message because you are subscribed to the Google Groups "munkireport" group.
To unsubscribe from this group and stop receiving emails from it, send an email to munkireport...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<Screen Shot 2015-10-14 at 11.38.15 am.png>

bryan...@gmail.com

unread,
Oct 14, 2015, 12:35:06 PM10/14/15
to munkireport
Do you mean the nopkg plist via Munki is going away? That uses this method?

<string>#!/bin/bash 
/bin/bash -c "$(curl -s --max-time 10 http://c145-md-mun-001.omahaps.ops.org/index.php?/install)"</string>


That would be unfortunate if it were to go away. Our school system runs one munki server per school and so each school runs munki report. Having to import 70+ packages into munki would be tedious.

The nopkg scripts though are super easy to deal with though.


Not the end of the world if i have to change things, but the above method is very efficient

Bryan

Mike Solin

unread,
Oct 14, 2015, 12:47:39 PM10/14/15
to munki...@googlegroups.com
You could use the AutoPkg recipe with each school, so you don’t have to import the pkgs yourself.

Another alternative would be having every school machine check into a single MunkiReport installation, then using the new machine groups feature to separate out the different schools.  You don’t need to create business units to use machine groups.

A.E. van Bochoven

unread,
Oct 14, 2015, 2:14:54 PM10/14/15
to munki...@googlegroups.com
On 14 Oct 2015, at 18:35, bryan...@gmail.com wrote:

Do you mean the nopkg plist via Munki is going away? That uses this method?

<string>#!/bin/bash 
/bin/bash -c "$(curl -s --max-time 10 http://c145-md-mun-001.omahaps.ops.org/index.php?/install)"</string>

Not really, only the creation of the plist via munkireport (http://c145-md-mun-001.omahaps.ops.org/index.php?/install/plist). 

I want to discourage people to use this method for installing munkireport. Off course, you can still use this method, by creating your own nopkg pkginfo file with the above script.

That would be unfortunate if it were to go away. Our school system runs one munki server per school and so each school runs munki report. Having to import 70+ packages into munki would be tedious.

I think you can automate creating those using the munkireport autopkg recipe.

The nopkg scripts though are super easy to deal with though.


Not the end of the world if i have to change things, but the above method is very efficient

One of the reasons to use the pkg installer is that you can upgrade munkireport while keeping the clients on an older client version. Using pkgs you have greater control over what client gets what client version.

-Arjen


Bryan



On Tuesday, October 13, 2015 at 11:22:08 AM UTC-5, Arjen van Bochoven wrote:

Installing the plist is deprecated and will be removed. Please install manually or use the pkg installer:



Reply all
Reply to author
Forward
0 new messages