API2 "The column cnt already exists"

Razuna v2 Legacy Self-Hosted
1

Dear support,

Something had changed but I don’t know what and why.

This is how I use the search API : http://xxxxxxxxx/razuna/global/api2/search.cfc?method=searchassets&api_key=xxxxxxxxx&searchfor=test

1 : I do a search request with API -> It works
2 : I do the SAME request -> It doesn’t works
This is the error message : {“message”:“The column cnt already exists”,“errorcode”:"",“detail”:""}

3 : I click on the button “Flush database cache”
4 : I do a search request with API -> It works
5 : I do the SAME request -> It doesn’t works

Razuna 1.7.1

2

Hi,

Sorry, I have no idea whatsoever when you write “I do the SAME request”. Same API call or what?

3

Nitae,

I said that when I call many times successively the search API, the first request is OK, and all next request are KO.

1 - I do http://xxxxxxxxx/razuna/global/api2/search.cfc?method=searchassets&api_key=xxxxxxxxx&searchfor=pictos

Response OK :
{“COLUMNS”:[“id”,“filename”,“folder_id”,“folder_name”,“extension”,“video_image”,“filename_org”,“kind”,“extension_thumb”,“path_to_asset”,“cloud_url”,“cloud_url_org”,“size”,“size_num”,“width”,“height”,“isalias”,“description”,“keywords”,“dateadd”,“datechange”,“expiry_date_actual”,“local_url_org”,“local_url_thumb”,“colid”,“colorspace”,“xdpi”,“ydpi”,“unit”,“md5hash”,“filename_forsort”,“cnt”,“responsecode”,“totalassetscount”,“calledwith”],“DATA”:[[“B24F814F36934882BA779415B9470CD5”,“pictos.pdf”,“5FF93EEBFEE54F399AC07A460579B2A7”,“My Folder”,“pdf”,“dummy”,“pictos.pdf”,“doc”,“pdf”,“5FF93EEBFEE54F399AC07A460579B2A7/doc/B24F814F36934882BA779415B9470CD5”,“”,“”,“62302”,62302,0,0,“0”,“”,“”,“November, 2 2015 15:45:27”,“November, 2 2015 15:45:27”,“”,“http://ima-dam.j2s.net//razuna/assets/6/5FF93EEBFEE54F399AC07A460579B2A7/doc/B24F814F36934882BA779415B9470CD5/pictos.pdf",“0”,“”,“”,“”,“”,“”,“3D220F382D9B40BDB3D5535A968EFBE5”,“pictos.pdf”,1,0,1,"pictos”]]}

2 - I do http://xxxxxxxxx/razuna/global/api2/search.cfc?method=searchassets&api_key=xxxxxxxxx&searchfor=pictos

Response : {“message”:“The column cnt already exists”,“errorcode”:“”,“detail”:“”}