JSON Error about teampass HOT 19 CLOSED

Can you try to clean up the cache table.
Go in Settings page, select "specific actions" tab and click on link "clean cache table".

Please tell me if ok

from teampass.

I cleared out the cache table and restarted my browser session. This had no effect on the issue.

from teampass.

Can you get the JSON returned string? (using for example firebug in order to identify where the string is broken).

I can get reproducing that issue.

from teampass.

Params:
_ 1328126265981
bRegex false
bRegex_0 falseParams:
_ 1328126265981
bRegex false
bRegex_0 false
bRegex_1 false
bRegex_2 false
bRegex_3 false
bRegex_4 false
bRegex_5 false
bSearchable_0 true
bSearchable_1 true
bSearchable_2 true
bSearchable_3 true
bSearchable_4 true
bSearchable_5 true
bSortable_0 true
bSortable_1 true
bSortable_2 true
bSortable_3 true
bSortable_4 true
bSortable_5 true
iColumns 6
iDisplayLength 10
iDisplayStart 0
iSortCol_0 1
iSortingCols 1
sColumns
sEcho 6
sSearch te
sSearch_0
sSearch_1
sSearch_2
sSearch_3
sSearch_4
sSearch_5
sSortDir_0 asc

Headers:
ResponseHeaders
Date Wed, 01 Feb 2012 19:57:22 GMT
X-Powered-By PHP/5.3.9
Connection close
Content-Length 3670
Pragma no-cache
Server Apache/2.2.3 (CentOS)
Content-Type text/html; charset=utf-8
Cache-Control no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Expires Thu, 19 Nov 1981 08:52:00 GMT
RequestHeaders
Accept application/json, text/javascript, /; q=0.01
X-Requested-With XMLHttpRequest

Response:
{"sEcho": 6, "iTotalRecords": 508, "iTotalDisplayRecords": 61, "aaData": [ ["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=36&id=268';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(268);" style="cursor:pointer;" />","BBH Content FTP","","User: ftp pass: a45%Q4Deo%`","","Linux » Prod"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=36&id=251';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(251);" style="cursor:pointer;" />","feedercontent.amsnl.webair.com","root","","","Linux » Prod"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=41&id=5';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(5);" style="cursor:pointer;" />","media-fw.amsnl.webair.com","ea","
Firewall in Amster
","","Network » Firewalls"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=41&id=40';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(40);" style="cursor:pointer;" />","mediaset2-fw.amsnl.webair.com","set2admin","
Firewall in Amster
","","Network » Firewalls"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=55&id=176';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(176);" style="cursor:pointer;" />","Computer's worth","[email protected]","","","Vendors"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=46&id=239';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(239);" style="cursor:pointer;" />","epiccenter","jim.ma","epiccenter","","Phones"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=46&id=19';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(19);" style="cursor:pointer;" />","Epiclite Diagnostics password","","","","Phones"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=46&id=13';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(13);" style="cursor:pointer;" />","Epiclite login for Real Time Monitoring (ACD3 / AC","jim.ma","","","Phones"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=46&id=36';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(36);" style="cursor:pointer;" />","EpicLite Serice Account ","svc_epiclite","","","Phones"],["<img src="includes/images/key__arrow.png" onClick="javascript:window.location.href = 'index.php?page=items&group=33&id=163';" style="cursor:pointer;" /><img src="includes/images/key_copy.png" onClick="javascript:copy_item(163);" style="cursor:pointer;" />","Epiclite VNC","","","","Windows » Servers"]] }

from teampass.

Very strange ... the special characters are not encoded as they should.

For example, single quotes should be sent back as &#39 ;

Can you please confirm that? If yes then some thing is wrong with browser encoding or something like that.

from teampass.

I checked in the response header on the same search query posted above. I can confirm that they are being sent back correctly with &#39

So far I've been able to recreate the error in both recent versions of Google Chrome and Mozilla Firefox.

from teampass.

Hum do you think you can manage me an access to your TP ?

I really didn't manage to reproduce.

from teampass.

With the security policies we have in place I don't think that is going to fly with my management. However if there was a way for me to quickly sanitize the password information in a DB dump perhaps that would be sufficient?

from teampass.

How sad ... but I understand.

No this is not a solution because sanitizing the db will certainly make the bug disappearing.
I'm pretty sure that this is due to a certain string you have in your DB ... that's why I can't reproduce.

Can you go on GoogleCode TeamPass page. Someone has the same behavior, I've asked the guy to do some tests. Please do the same and maybe we'll found the string on which it get broken

from teampass.

Okay. I had submitted a similar problem on the google project page in the past when using version 1.82 of cpassman.

One closed issue that you resolved in the past was marked under:

http://code.google.com/p/cpassman/issues/detail?id=58&can=1&q=ganthore&colspec=ID%20Type%20Status%20Priority%20Milestone%20Reporter%20Owner%20Summary

I'll check over the google project and see if I can dig up the issue you are referring to. Thanks.

from teampass.

I had an similiar issue, it was caused by the string "#plus#" in description, in the db it was stored like \"#plus#\". I edited that record, deleted the backslashes in the description and saved. Now it works fine and in the db it is stored like this: "#plus#"

from teampass.

@mmolnar: thank you for information ;-)

from teampass.

@mmolnar: I'm going to check over my DB and see if there is something similar in the records. Thanks for the info. I'll post my findings later.

from teampass.

To make things more clear, i edited that record in teampass and there I deleted the backslashes and saved.
In our old version of cpassman quotation marks were saved escaped with three backslashes, but the new Teampass saves them as the html symbol code & quot; and the update script is not changing the descriptions.
The backslashes in DB are causing the JSON error.

from teampass.

Found another JSON error in search, this time it was caused by two backslashes in database, in login string. After edit there was only one backslash left.

from teampass.

I'll check over my db records for anything related to what you found mmolnar.

from teampass.

My problem seems to be different and very hard to diagnose.

A majority of our item records have large amounts of black white space in them... This is interesting...

Example:

*************************** 1. row ***************************
id: 180
label: Testdb.test.bbhmedia.net test6_app
description:
MySQL (test6_app) user

     pw: removed password for obvious reasons
    url:

Notice the white space in the description? This is the case for hundreds of our records and this error seems to go away whenever I remove the blank space from a DB record.

I still get the error under some other odd circumstances and I'll report more as I run into them.

This bug still stands as of version 2.1.7

from teampass.

Yesterday I ran a series of TRIM commands on all the records in the items table. I specified in my TRIM command to remove both leading and trailing blank space on the url, description and label fields.

I cleared out the table caches as the admin user and this resolved all of my JSON errors.

I hope this information helps anyone who had this similar problem.

from teampass.

I have same error in 2.1.18 only google chrome, if I execute a IE or firefox doesnt occur.
I field of description in google chrome appear tag div and this occur the have problem.

from teampass.