search

MyCaert / Issues-Enhancements

Issues and Enhancements
2 stars 0 forks source link

Editing MY Community titles #373

Closed mnichols13 closed 1 year ago

mnichols13 commented 1 year ago

When editing MY Community titles on the ADMIN page, this error comes up - please fix

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near ','.

/admin/StateAdmins/PostEdited.asp, line 138

mnichols13 commented 1 year ago

@Blake

Could you take a look at this in the next few days?

bguerrettaz commented 1 year ago

I've looked into this quite a bit this afternoon and the only thing I can see may be the issue is when the change is submitted, the session variables are empty. @Brian Peterlin @.***> - are there multiple app pools for MyCaert?

On Thu, Feb 23, 2023 at 7:45 AM mnichols13 @.***> wrote:

Could you take a look at this in the next few days?

— Reply to this email directly, view it on GitHub https://github.com/MyCaert/Issues-Enhancements/issues/373#issuecomment-1441914887, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLOP477SGBPN4TBG2E3WB3WY5ZZ7ANCNFSM6AAAAAAU2V54YU . You are receiving this because you are subscribed to this thread.Message ID: @.***>

bguerrettaz commented 1 year ago

only one pool

i can reboot, maybe that will clean it up

On Thu, Feb 23, 2023 at 6:31 PM Blake Guerrettaz @.***> wrote:

I've looked into this quite a bit this afternoon and the only thing I can see may be the issue is when the change is submitted, the session variables are empty. @Brian Peterlin @.***> - are there multiple app pools for MyCaert?

On Thu, Feb 23, 2023 at 7:45 AM mnichols13 @.***> wrote:

Could you take a look at this in the next few days?

— Reply to this email directly, view it on GitHub https://github.com/MyCaert/Issues-Enhancements/issues/373#issuecomment-1441914887, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLOP477SGBPN4TBG2E3WB3WY5ZZ7ANCNFSM6AAAAAAU2V54YU . You are receiving this because you are subscribed to this thread.Message ID: @.***>

-- Brian Peterlin @.*** Cell# 309 310 4551

bguerrettaz commented 1 year ago

Ok, thanks. Please let me know once you've done that.

On Fri, Feb 24, 2023 at 6:04 AM Brian Peterlin @.***> wrote:

only one pool

i can reboot, maybe that will clean it up

On Thu, Feb 23, 2023 at 6:31 PM Blake Guerrettaz @.***> wrote:

I've looked into this quite a bit this afternoon and the only thing I can see may be the issue is when the change is submitted, the session variables are empty. @Brian Peterlin @.***> - are there multiple app pools for MyCaert?

On Thu, Feb 23, 2023 at 7:45 AM mnichols13 @.***> wrote:

Could you take a look at this in the next few days?

— Reply to this email directly, view it on GitHub https://github.com/MyCaert/Issues-Enhancements/issues/373#issuecomment-1441914887, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLOP477SGBPN4TBG2E3WB3WY5ZZ7ANCNFSM6AAAAAAU2V54YU . You are receiving this because you are subscribed to this thread.Message ID: @.***>

-- Brian Peterlin @.*** Cell# 309 310 4551

BrianPeterlin commented 1 year ago

@mnichols13 , can you send me what is being put into the title? I wonder if there is a special character causing it to fail

bguerrettaz commented 1 year ago

Its not, I tested many of the different items. It's an issue with the session variables getting set for the SQL update statement. I worked on it quite a bit yesterday and couldn't get the session to stick.

On Fri, Feb 24, 2023 at 10:13 AM BrianPeterlin @.***> wrote:

@mnichols13 https://github.com/mnichols13 , can you send me what is being put into the title? I wonder if there is a special character causing it to fail

— Reply to this email directly, view it on GitHub https://github.com/MyCaert/Issues-Enhancements/issues/373#issuecomment-1444058912, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLOP4ZKU3D5K4ZGNCXJPCLWZDT4HANCNFSM6AAAAAAU2V54YU . You are receiving this because you commented.Message ID: @.***>

BrianPeterlin commented 1 year ago

i have rebooted the server

bguerrettaz commented 1 year ago

Unfortunately, the reboot didn't resolve it. I researched the issue and it is sometimes an issue across the type of calling between the pages that were used.

I had to convert everything to cookies and that solved the problem.

Can you please test and confirm the functionality? Apologies that this took a while but it wasn't a common or easy problem to solve.

Thanks, Blake

On Fri, Feb 24, 2023 at 9:43 PM BrianPeterlin @.***> wrote:

i have rebooted the server

— Reply to this email directly, view it on GitHub https://github.com/MyCaert/Issues-Enhancements/issues/373#issuecomment-1444990707, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLOP426OLQHQGWWXHO3BR3WZGEWJANCNFSM6AAAAAAU2V54YU . You are receiving this because you commented.Message ID: @.***>

mnichols13 commented 1 year ago

This is working, but only if I log out after every submission. Here is the error message that I get now, which is very frustrating and time consuming.

INSERT INTO tblMyCommPostFiles( CatId,DisplayName, Status,CommPostId) Values(5,'','Approved',1804)Select CommPostFileId, DisplayName, RIGHT(DisplayName,(LEN(DisplayName)-CHARINDEX('.',DisplayName)))AS ext From tblMyCommPostFiles Where displayname = '' and CommPostId = 1804 Microsoft VBScript runtime error '800a0035'

File not found

/admin/StateAdmins/PostEdited.asp, line 209

bguerrettaz commented 1 year ago

Ok, I believe I have it all working correctly now. Can you please test and confirm?

Blake

On Tue, Feb 28, 2023 at 1:56 PM mnichols13 @.***> wrote:

This is working, but only if I log out after every submission. Here is the error message that I get now:

INSERT INTO tblMyCommPostFiles( CatId,DisplayName, Status,CommPostId) Values(5,'','Approved',1804)Select CommPostFileId, DisplayName, RIGHT(DisplayName,(LEN(DisplayName)-CHARINDEX('.',DisplayName)))AS ext From tblMyCommPostFiles Where displayname = '' and CommPostId = 1804 Microsoft VBScript runtime error '800a0035'

File not found

/admin/StateAdmins/PostEdited.asp, line 209

— Reply to this email directly, view it on GitHub https://github.com/MyCaert/Issues-Enhancements/issues/373#issuecomment-1448900945, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLOP46U2EGM6OUWBWMBMKLWZZQ6JANCNFSM6AAAAAAU2V54YU . You are receiving this because you commented.Message ID: @.***>

mnichols13 commented 1 year ago

Excellent!! Thank you!! Works fine now.