Razuna -delete asset API-at local installation


#1

Error message: {“message”:“General SQL Error”,“errorcode”:“errorCode.sqlError”,“detail”:"Database reported: Syntax error in SQL statement "DELETE FROM RAZ1_IMAGES\r\n\t\t\tWHERE IMG_ID = ?\r\n\t\t\tAND HOST_ID = ?\r\n\t\t\tORDER[*] BY IMG_ID “; SQL statement:\nDELETE FROM raz1_images\r\n\t\t\tWHERE img_id = ?\r\n\t\t\tAND host_id = ?\r\n\t\t\tORDER BY img_id [42000-191]”}

What does it mean. Please help


#2

This is a SQL error. What action are you doing?


#3

We are getting this sql error in Asset remove Api:-

http://host:8080/razuna/global/api2/asset.cfc?method=remove&api_key=XXXXXXXXXXXXXXXXXX&assetid=782A80412F7F442099DAFCDEEAFC5115&__BDQUERYFORMAT=column

How we can solve this problem.


#4

I see. You might run an older version of Razuna as this bug is already fixed. You can get some fixes directly from our Git repository.


#5

We are already using Api2 version and Razuna- razuna_tomcat_1_9_5 version


#6

I’m talking about the latest Razuna version :slight_smile:


#7

Hi,Thanks for your response.
I have some queries regarding this.

1.Do you mean that i should take new version from master branch or development branch.
2. Should we take search server code for new version too , what version of search server should be consider for latest razuna from dev/master code?


#8
  1. Development
  2. Master

#9

yes we have tried. we have taken searchserver and razuna both from master branch,but there was some configuration or dependencies issues so that we were not able to run initial setup itself.
Please confirm where we need to make necessary changes in configuration.


#10

Apologies, but this is as far as free support goes on here. We are an open source company and depend on paying support subscription to keep Razuna and the company running.

Please visit our support subscription page at http://razuna.org/support/subscriptions to learn more.