Forum Discussion

db_ad's avatar
db_ad
Guide
10 years ago
Solved

Liql unknown error

Given this: https://community.lithium.com/t5/Community-API-v2/Message-resource/ta-p/113091​ SELECT * FROM messages WHERE depth = 0 AND conversation.solved = true That's an example query from the d...
  • db_ad's avatar
    db_ad
    10 years ago

    It was a bug from the API which is being solved

db_ad's avatar
db_ad
Guide
10 years ago

That doesn't work also, getting similar error.

 

Other queries, for example "SELECT id, topics.count(*), messages.count(*), views FROM boards where id in ('123,124') ORDER BY messages.count(*) DESC" do work, there's data available

 

{
"status": "error",
"message": "invalid query syntax for SELECT * FROM messages WHERE conversation.solved",
"data": {
"type": "error_data",
"code": 603,
"developer_message": "",
"more_info": ""
},
"metadata": {}
}

VarunGrazitti's avatar
VarunGrazitti
Boss
10 years ago
db_ad - Run this command to see if your instance is working fine, else contact Li support.

SELECT * FROM messages
  • db_ad's avatar
    db_ad
    Guide
    10 years ago
    SELECT * FROM messages (using valid access token)


    {
    "status": "error",
    "message": "An unexpected error occurred.",
    "data": {
    "type": "error_data",
    "code": 301,
    "developer_message": "",
    "more_info": ""
    },
    "metadata": {}
    }?