Trying to list current users give JSON error

[windmillway]

Selecting Administration/Users gives the following pop-up error

DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

All themes. currently at svn 11086

[fisharebest (fisharebest)]

I don't see this.

There will (almost certainly) be a code error in the callback function that generates the table data.

To see the response, you need to fetch the callback fragment directly, using a URL such as

http://localhost/webtrees/admin_users.php?action=loadrows&sEcho=1&iColumns=14&sColumns=&iDisplayStart=0&iDisplayLength=10&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&sSearch_5=&bRegex_5=false&bSearchable_5=true&sSearch_6=&bRegex_6=false&bSearchable_6=true&sSearch_7=&bRegex_7=false&bSearchable_7=true&sSearch_8=&bRegex_8=false&bSearchable_8=true&sSearch_9=&bRegex_9=false&bSearchable_9=true&sSearch_10=&bRegex_10=false&bSearchable_10=true&sSearch_11=&bRegex_11=false&bSearchable_11=true&sSearch_12=&bRegex_12=false&bSearchable_12=true&sSearch_13=&bRegex_13=false&bSearchable_13=true&iSortingCols=1&iSortCol_0=2&sSortDir_0=asc&bSortable_0=false&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&bSortable_5=false&bSortable_6=true&bSortable_7=true&bSortable_8=true&bSortable_9=true&bSortable_10=true&bSortable_11=true&bSortable_12=true&bSortable_13=false&_=1299577911207

[windmillway (windmillway)]

Greg

OK I have done that and get this downloaded report

{"sEcho":1,"iTotalRecords":"2","iTotalDisplayRecords":"2","aaData":[["","2","<span class=\"editable\" id=\"user-user_name-2\">guest<\/span>\n<script type=\"text\/javascript\">\n\/\/<![CDATA[\njQuery(\"#user-user_name-2\").editable(\"http:\/\/localhost\/webtrees_svn\/save.php\", {submit:\"&nbsp;&nbsp;OK&nbsp;&nbsp;\", style:\"inherit\", placeholder: \"click to edit\"})\n\/\/]]>\n<\/script>\n","<span class=\"editable\" id=\"user-real_name-2\">A Family Member<\/span>\n<script type=\"text\/javascript\">\n\/\/<![CDATA[\njQuery(\"#user-real_name-2\").editable(\"http:\/\/localhost\/webtrees_svn\/save.php\", {submit:\"&nbsp;&nbsp;OK&nbsp;&nbsp;\", style:\"inherit\", placeholder: \"click to edit\"})\n\/\/]]>\n<\/script>\n","<span class=\"editable\" id=\"user-email-2\"><\/span>\n<script type=\"text\/javascript\">\n\/\/<![CDATA[\njQuery(\"#user-email-2\").editable(\"http:\/\/localhost\/webtrees_svn\/save.php\", {submit:\"&nbsp;&nbsp;OK&nbsp;&nbsp;\", style:\"inherit\", placeholder: \"click to edit\"})\n\/\/]]>\n<\/script>\n","<div class=\"icon-email\" onclick=\"return message('guest');\"><\/div>","<span class=\"editable\" id=\"user_setting-2-language\"><\/span>\n<script type=\"text\/javascript\">\n\/\/<![CDATA[\njQuery(\"#user_setting-2-language\").editable(\"http:\/\/localhost\/webtrees_svn\/save.php\", {type:\"select\", data:{\"de\":\"Deutsch\",\"en_GB\":\"British English\",\"fr\":\"fran\\u00e7ais\",\"nl\":\"Nederlands\",\"he\":\"\\u05e2\\u05d1\\u05e8\\u05d9\\u05ea\",\"zh_CN\":\"\\u4e2d\\u6587\",\"selected\":null}, submit:\"&nbsp;&nbsp;OK&nbsp;&nbsp;\", style:\"inherit\", placeholder: \"click to edit\", callback:function(value, settings) {jQuery(this).html(settings.data[value]);} })\n\/\/]]>\n<\/script>\n",null,"<span class=\"red\"><span class=\"date\">1 January 1970<\/span><span class=\"date\"> - 01:00:00<\/span><\/span>",null,"Never","<span class=\"editable\" id=\"user_setting-2-verified-\">no<\/span>\n<script type=\"text\/javascript\">\n\/\/<![CDATA[\njQuery(\"#user_setting-2-verified-\").editable(\"http:\/\/localhost\/webtrees_svn\/save.php\", {type:\"select\", data:{\"1\":\"yes\",\"0\":\"no\",\"selected\":0}, submit:\"&nbsp;&nbsp;OK&nbsp;&nbsp;\", style:\"inherit\", placeholder: \"click to edit\", callback:function(value, settings) {jQuery(this).html(settings.data[value]);} })\n\/\/]]>\n<\/script>\n","<span class=\"editable\" id=\"user_setting-2-verified_by_admin-\">no<\/span>\n<script type=\"text\/javascript\">\n\/\/<![CDATA[\njQuery(\"#user_setting-2-verified_by_admin-\").editable(\"http:\/\/localhost\/webtrees_svn\/save.php\", {type:\"select\", data:{\"1\":\"yes\",\"0\":\"no\",\"selected\":0}, submit:\"&nbsp;&nbsp;OK&nbsp;&nbsp;\", style:\"inherit\", placeholder: \"click to edit\", callback:function(value, settings) {jQuery(this).html(settings.data[value]);} })\n\/\/]]>\n<\/script>\n","<div class=\"icon-delete\" onclick=\"if (confirm('Permanently delete &quot;guest&quot;?')) { document.location='admin_users.php?action=deleteuser&username=guest'; }\"><\/div>"],["","1","<span class=\"editable\" id=\"user-user_name-1\">windmillway<\/span>\n<script type=\"text\/javascript\">\n\/\/<![CDATA[\...

[fisharebest (fisharebest)]

That looks OK to me. Often, you'll get a PHP error here.

Try passing that value through json_decode()

e.g.

var_dump(json_decode('....'));

[fisharebest (fisharebest)]

I can see this error in my live not, but not my dev site.......

[windmillway (windmillway)]

Thanks Greg,

I'll be back in a couple of hours or so.
Shrove Tuesday, and Mum likes her pancakes (SWMBO)

Talk to you later

Brian

[wooc (wooc)]

I can confirm on my test site this error.

[wooc (wooc)]

In my bug console I see:
Inline script compilation
Syntax error at line 1 while loading:
{"sEcho":1,"iTotalRecords":"
--------^
expected ';', got ':'

[fisharebest (fisharebest)]

Can somebody check this with the previous version of jQuery / jQuery-UI ?

We upgraded recently, and I can see some JS errors that could be related....

[windmillway (windmillway)]

Thanks Greg.
I just rolled back svn 11070 and 11072 on my local copy, and the problem has gone.
I now can see my users again.

I guess Veit needs to sort this on the server?

Brian

[windmillway (windmillway)]

Or I can do the reversion if you like?

Brian

[fisharebest (fisharebest)]

No - we don't want to revert. We need to update our code to work with the updated library.

I think I saw where the problem is, but might not have time for a couple of days.

[windmillway (windmillway)]

OK

[Rob Peters (makitso)]

Just updated to the 3/15 snapshot build and this JSON error popped up. Is there a fix available yet?

[kiwi (kiwi3685-deactivatedaccount)]

Changed the priority of this. It seems to happen in many browsers. I found it using FF. It totally prevents any management of users, so a very critical issue.

[fisharebest (fisharebest)]

I have raised this with the datatables developer.

http://datatables.net/forums/comments.php?DiscussionID=4538

[fisharebest (fisharebest)]

The problem is a conflict with the jquery.ajaxQueue.js plugin.

I'm not sure why we're using it. I know that jQuery 1.5 has rewritten the ajax handling, so perhaps this is no longer necessary.

[fisharebest (fisharebest)]

This problem seems to be known already:

http://plugins.jquery.com/content/ajaxqueue-json-calls-not-working-jquery-151

We are using ajaxQueue to solve the following problem:

Autocomplete makes many requests in rapid succession. If you type ABCD, it will send requests for A, AB, ABC and ABCD. However, on slow networks, these may be retrieved out of sequence, e.g A, AB, ABCD, ABC.

I have not been able to reproduce the problem - it is described as "intermittent" or "theoretical".

I shall remove this plugin. I've read that queueing features are now built in to jQuery. It is hopeful/possible that a later version of jquery.autocomplete will use this automatically.

[fisharebest (fisharebest)]

svn11205

[ToyGuy (toyguy)]

Great detective work, Greg. TNX

[windmillway (windmillway)]

That's wonderful Greg. Well done

Brian

[fisharebest (fisharebest)]

Fix released in webtrees 1.1.2

[Gixmo (gixmo)]

I get the same error message in 1.2.5:

DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

When opening : adminstration - users