JSON error message while searching for password entries

[GoogleCodeExporter]

Hi Nils,

as I posted in my other Issue-Report I managed to get my KeePass-File imported 
bit by bit. 

A colleague of mine ran into an error while searching for a password entry 
(attached file).

1. Import a lot of password entries
2. Search for a specific entry (maybe with a not that specific search phrase)

What version of the product are you using?
2.1

On what operating system? With what Browser (IEx, FFx, ...)
Windows 7 x64 and Windows XP. IE8 + IE9, Chrome (most recent), Firefox (most 
recent)

Christoph

Original issue reported on code.google.com by Marker...@gmail.com on 21 Jan 2012 at 1:40

Attachments:

• [Teampass 2.jpg](https://storage.googleapis.com/google-code-attachments/cpassman/issue-246/comment-0/Teampass 2.jpg)

[GoogleCodeExporter]

Hello,

Can you try to clean your cache table.
Go in Settings page, select tab called "specific actions" and click "Reload 
Cache table "

Please tell me if ok

Original comment by nils.cpa...@gmail.com on 24 Jan 2012 at 8:34

• Changed state: Accepted

[GoogleCodeExporter]

Hello Nils,

thanks for your feedback. I'll try as soon as possible. You will have a 
feedback by friday.

Christoph

Original comment by Marker...@gmail.com on 24 Jan 2012 at 9:23

[GoogleCodeExporter]

Hi Nils,

I tried reloading the cache table but I still get the same error message.

Christoph

Original comment by Marker...@gmail.com on 27 Jan 2012 at 9:03

[GoogleCodeExporter]

hum ... okay so this error occurs when you try to search a specific item?

Not when opening the page, true?

Original comment by nils.cpa...@gmail.com on 28 Jan 2012 at 7:34

[GoogleCodeExporter]

Yes, when I try to search for a specific item.

Original comment by Marker...@gmail.com on 28 Jan 2012 at 7:43

[GoogleCodeExporter]

I have the same issue after an upgrade to 2.0RC4. on 2.0beta1 it worked.

mysql> describe cpassman_cache;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id            | int(12)      | NO   |     | NULL    |       |
| label         | varchar(50)  | NO   |     | NULL    |       |
| description   | text         | NO   |     | NULL    |       |
| tags          | text         | NO   |     | NULL    |       |
| id_tree       | int(12)      | NO   |     | NULL    |       |
| perso         | tinyint(1)   | NO   |     | NULL    |       |
| restricted_to | varchar(200) | NO   |     | NULL    |       |
| login         | varchar(200) | NO   |     | NULL    |       |
| folder        | varchar(300) | NO   |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

Does it look legit to you?

Original comment by paul.goe...@googlemail.com on 7 Feb 2012 at 4:55

[GoogleCodeExporter]

Do you think an update to TeamPass 2.1 will fix the issue?

Original comment by paul.goe...@googlemail.com on 9 Feb 2012 at 8:05

[GoogleCodeExporter]

Hi Nils,

I just updated to TeamPass 2.1, but the error still exists (as expected). Do 
you any idea what I could try next?

Paul

Original comment by paul.goe...@googlemail.com on 15 Feb 2012 at 10:34

[GoogleCodeExporter]

Hi,
Well I don't understand because I can't reproduce it.
But sure this seems to be a bug ... and needs to be solved.

Can you do some tests for me?
Open file /sources/find.queries.php
At the end of the file,  you'll see the construction of the JSON returned 
string.
For COL1, please only keep 
$sOutput_item .= '"test",';
Then relaunch your query.
Check if still the message. If yes, we've found at least were the string is 
broken.
If not, restore original code and modify the next column.

This way we will identify the origin of the problem,  it will be easier to 
investigate after

Original comment by nils.lau...@gmail.com on 15 Feb 2012 at 7:40

[GoogleCodeExporter]

I think I found the issue (at least for me). With Firbug I looked at the return 
code:

["<img src=\"includes/images/key__arrow.png\" 
onClick=\"javascript:window.location.href = 
'index.php?page=items&group=63&id=81';\" style=\"cursor:pointer;\" /><img 
src=\"includes/images/key_copy.png\" onClick=\"javascript:copy_item(81);\" 
style=\"cursor:pointer;\" />","some label ","ostehr stuff","description with 
unwanted line break
","","Path >> to >> entry"]

So in my case in the return there was an unwanted line brake in the description 
field.

I don't see this line break in the db, so the only solution I found was opening 
the item in TeamPass and save it again (with no changes)

Hope that helps.

Paul

Original comment by paul.goe...@googlemail.com on 17 Feb 2012 at 9:14

[GoogleCodeExporter]

Ok good information ... I've got to sanitize this case ;-)

Original comment by nils.cpa...@gmail.com on 17 Feb 2012 at 5:45

[GoogleCodeExporter]

Do you have news about this issue? We still have this behaviour with 2.1.5
Do you need more debug?

Thanks

Original comment by michele....@gmail.com on 30 Mar 2013 at 11:21