Forum errors on post editing?

[MercenaryForHire]

I'm getting all sorts of errors at random when I try to edit posts. Sometimes it happens, sometimes it doesn't.

Did I find an "undocumented feature"?

- M4H

 

[Jason Clark]

We're aware.

 

[Jason Clark]

Should be fixed.

 

[Lord Evermore]

Isn't.

 

[Jason Clark]

Can you post some recreation steps because this is isolated to a very tiny amount of users.

How are you posting, etc. Does it happen each and every time etc... is there any pattern..... more info please.

 

[Colt45]

i got a database error a while back when editing a post.

 

[Lord Evermore]

Click a thread (so far only the one I created in Private Topics because I haven't done anything else yet today), click Edit. Get error.

Forum Error
An error has occurred. If you wish to notify the administrator please click here.

To go back to the main forum page please click here.

ERROR INFORMATION:
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@P2and'.

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:112).

 

[Jason Clark]

Ok so its only in private threads? try editing your post here see if it happens

 

[Colt45]

yeah, the one evermore got is the same as the one i got, also editing a post in private topics.

edit: I just got the same error again, editing this post

 

[Codewiz]

Originally posted by: Lord Evermore
Click a thread (so far only the one I created in Private Topics because I haven't done anything else yet today), click Edit. Get error. Forum Error An error has occurred. If you wish to notify the administrator please click here. To go back to the main forum page please click here. ERROR INFORMATION: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@P2and'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:112).

I get the same error message. It is random and can happen in any thread that I have posted in. I just click edit and that happens. If I hit refresh it sometimes works and sometimes doesn't. Eventually if I hit refresh enough times it will work,

 

[Lord Evermore]

Yep, happened here too, on the second attempt.

Also, when I hit the back button after the first successful edit, I got an error in Mozilla that the file messageview.cfm?catid=42&threadid=1019512 could not be found. Refreshing brought it up fine.

 

[Drakkon]

got a message too when trying to edit my thread in fs/ft...once when i clicked on edit...but i was able to get to the edit page but when i pressed the edit message button i get this:

Forum Error
An error has occurred. If you wish to notify the administrator please click here.
To go back to the main forum page please click here.

ERROR INFORMATION:
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@P2and'.

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:112).

hope this gets fixed soon so i can change my prices

 

[Jason Clark]

K pretty sure its nailed it was a rogue server.

 

[Drakkon]

yay works for me now!