Developer forum

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

Simple Delete statement in SQL Firehose causes error

E-mail notifications
Dynamicweb Employee
Brian Zawistowski
Reply
Posted on 06/10/2020 15:23:18

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
Posted on 06/10/2020 15:35:22
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

 
Dynamicweb Employee
Brian Zawistowski
Posted on 06/10/2020 15:54:18
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
Posted on 06/10/2020 17:01:38
Reply

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

Capture.JPG
 
Dynamicweb Employee
Brian Zawistowski
Posted on 06/10/2020 17:09:19
Reply

Sorry, try this query:

DELETE FROM accessuser where accessuserid = 130

Userid 3781 was from the other site

 
Mafalda Correa
Mafalda Correa
Posted on 15/10/2020 16:29:40
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

 
Dynamicweb Employee
Brian Zawistowski
Posted on 15/10/2020 16:35:37
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

 
Martin Grønbekk Moen
Martin Grønbekk Moen
Posted on 09/11/2020 22:47:01
Reply

Bump! I experience this too.
Have DW 9.9.1.

 
Martin Grønbekk Moen
Martin Grønbekk Moen
Posted on 10/11/2020 16:25:48
Reply

This has been acknowledged as a bug today:

The bug number is: 85781

A bugfix has been planned in version: . Releasedate:

For further information about bugs and releases please follow the link:

http://doc.dynamicweb.com/releases-and-downloads/releases

 

You must be logged in to post in the forum