Error using Where query

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    11 years, 1 month ago

    What error, exactly? I get no error using that shortcode, it works for me.

    Thread Starter memtee

    (@memtee)

    11 years, 1 month ago

    When I use this shortcode:

    [gdoc key="https://docs.google.com/spreadsheets/d/1amMzEK1RxAFN5MxHh0OB-fj96-UuYfpAqbGRY2x4H14/edit?usp=sharing" class="no-datatables" query="SELECT B, L WHERE M = 'TAP'"]

    I get this error message:

    {"version":"0.6" 

status:"error" 

errors:[{"reason":"invalid_query" 

message:"INVALID_QUERY" 

detailed_message:"Invalid query: PARSE_ERROREncountered \u0022c2c\u0022 at line 1 

column 40.\nWas expecting one of:\n \u003cEOF\u003e \n \u0022group\u0022 ...\n \u0022pivot\u0022 ...\n \u0022order\u0022 ...\n \u0022skipping\u0022 ...\n \u0022limit\u0022 ...\n \u0022offset\u0022 ...\n \u0022label\u0022 ...\n \u0022format\u0022 ...\n \u0022options\u0022 ...\n \u0022and\u0022 ...\n \u0022or\u0022 ...\n "}]}

    The site is behind a firewall so I can’t send a link.

    Plugin Author Meitar

    (@meitar)

    11 years, 1 month ago

    That’s an error from Google. Sorry, but I can’t reproduce that error. You might want to try changing something about your site’s environment, since there’s no problems with a simpler set up.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error using Where query’ is closed to new replies.