Developer forum

Forum » Integration » Simple Delete statement in SQL Firehose causes error

Simple Delete statement in SQL Firehose causes error

Brian Zawistowski
Reply

If I try and run the following query in SQL firehose:

DELETE FROM AccessUser where accessuserid = 3781

I get the error:  

The following exception message was returned by the server: Incorrect syntax near ')'.

This site was recently upgraded to version 9.9.1.  I also tried this on a different test site that we upgraded to 9.9.2 with the same result.

Can anyone help with this?


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

Hi Brian

I cannot reproduce that locally. Do you have a link to the solution? And have you done a clear cache of the browser after update to latest?

Thanks, Nicolai

 
Brian Zawistowski
Reply

Hi Nicolai,

 

You can test using this link:  https://99sfo5.mydwsite3.com/Admin/Default

I cleared my browser cache, recycled the app pool on the site, and tried from different browsers with the same result.  I should also note that sometimes I just get the spinning "working" icon when executing the delete query and it never completes or returns an error but I can't reliably reproduce that behavior.

Thanks,

Brian 

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

Well, I can execute it on that solution. see dump.

Capture.JPG
 
Brian Zawistowski
Reply

Sorry, try this query:

DELETE FROM accessuser where accessuserid = 130

Userid 3781 was from the other site

 
Mafalda Correa Dynamicweb Employee
Mafalda Correa
Reply

Bump.

I have the same issue, sometimes I get the same error Brian reported, other times I get an infinite loading screen and a console error 

https://www.screencast.com/t/so5CrzZn

 
Brian Zawistowski
Reply

I am still experiencing the issue on two sites.  This query:

DELETE FROM accessuser where accessuserid = 130

On this site:  https://99sfo5.mydwsite3.com/Admin/Default

gives either the above error or the infinite loading screen

 

You must be logged in to post in the forum