Support » Plugin: CloudSearch » Syntax error in query: field (site_id) does not exist

  • Hi,

    Getting the above error when attempting to Connect. Not sure if the connection problem is related to the latest patch for domains, but plug-in will not connect. AWS Cloudsearch is running fine. So, pretty certain the error is in the plugin.

    Thanks,
    -Roger

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Andrea Landonio

    (@lando1982)

    Hi Roger,
    it seems to a missing field in the AWS Cloudsearch index. Can you check in the “Indexing Options” of your CS domain if the “site_id” field exists? If not exists, go to the “Manage” page of the plugin and try to do again a “Create/update index” by clicking the button..

    Let me know,
    Bye

    dpgiott

    (@dpgiott)

    Hello Andrea,
    I seem to be having the same issue.
    Syntax error in query: field (site_id) does not exist
    When I click on Create/update index button in the manage tab I just get a blank gray word press page.
    I feel it is not connecting. Spoke to aws support and we tested several things it could be something to do with the configuration of your plugin. Any suggestions would really like to try it out looks awesome
    Thank you
    David

    Plugin Author Andrea Landonio

    (@lando1982)

    Hi David,
    in the “Manage” page under “Index status” what do you see? Running?

    dpgiott

    (@dpgiott)

    Hello Andrea,
    It says Error Loading for all sections in red and current operation says nothing but a ” – ” but it is keep trying to load but nothing. I two am using divi theme
    David

    Plugin Author Andrea Landonio

    (@lando1982)

    Hi David,

    in the “Settings page” are filled the fields:

    • AWS Access key ID
    • AWS Secret access key
    • AWS Region
    • Search endpoint
    • Domain name

    or, have you used the “wp-config.php” constants? Also, are you able to look if in your application error log there are some errors? It should be useful 😀

    dpgiott

    (@dpgiott)

    Hello Andrea,
    Thank you for getting back to me. Yes I have all the fields entered in settings.
    When I turn on debug in wp-config.php here what I see on the page

    e: field_name in /var/www/html/wp-content/plugins/cloud-search/cloud-search-utils.php on line 128

    Fatal error: Uncaught Error: Class ‘SimpleXMLElement’ not found in /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Http/Message/Response.php:886 Stack trace: #0 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Service/Command/LocationVisitor/Response/XmlVisitor.php(17): Guzzle\Http\Message\Response->xml() #1 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Aws/Common/Command/XmlResponseLocationVisitor.php(21): Guzzle\Service\Command\LocationVisitor\Response\XmlVisitor->before(Object(Aws\Common\Command\QueryCommand), Array) #2 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Service/Command/OperationResponseParser.php(134): Aws\Common\Command\XmlResponseLocationVisitor->before(Object(Aws\Common\Command\QueryCommand), Array) #3 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Service/Command/OperationResponseParser.php(86): Guzzle\Service\Command\OperationResponseParser->visitResult(Object(Guzzle\Service\Description\Param in /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Http/Message/Response.php on line 886

    Plugin Author Andrea Landonio

    (@lando1982)

    Ok David, I’ve found an error in the code, could you try to download again the plugin? You see no version changes but download it anyway.. 😉
    Let me know..

    dpgiott

    (@dpgiott)

    I delete the plugin and downloaded the updated one from the wordpress but still getting the same errors. I don’t think it is connecting. When I click on the create/update index under management here is the error I am seeing

    Fatal error: Uncaught Error: Class ‘SimpleXMLElement’ not found in /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Http/Message/Response.php:886 Stack trace: #0 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Service/Command/LocationVisitor/Response/XmlVisitor.php(17): Guzzle\Http\Message\Response->xml() #1 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Aws/Common/Command/XmlResponseLocationVisitor.php(21): Guzzle\Service\Command\LocationVisitor\Response\XmlVisitor->before(Object(Aws\Common\Command\QueryCommand), Array) #2 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Service/Command/OperationResponseParser.php(134): Aws\Common\Command\XmlResponseLocationVisitor->before(Object(Aws\Common\Command\QueryCommand), Array) #3 /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Service/Command/OperationResponseParser.php(86): Guzzle\Service\Command\OperationResponseParser->visitResult(Object(Guzzle\Service\Description\Param in /var/www/html/wp-content/plugins/amazon-web-services/vendor/aws/Guzzle/Http/Message/Response.php on line 886

    Plugin Author Andrea Landonio

    (@lando1982)

    Hi David,
    let’s go deeper… which version of PHP are you using? And, are you already on a production system or in an environment reachable for me? If it’s not a problem you could give me some access..
    Another help… could you send me some screenshot of your problem at landonio.andrea@gmail.com? As many as you want..
    Let me know..
    Bye
    😉

    dpgiott

    (@dpgiott)

    Hello Andrea,
    Thank you for getting back to me. I think you are on to something special with this aws compatible cloud search plugin. Hope I can get it to work. I am using latest php7 version. This is on a test instance not production. Let me see what screen shots I can send you to your email. Will send shortly.
    David

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Syntax error in query: field (site_id) does not exist’ is closed to new replies.