• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Forum errors on post editing?

M

MercenaryForHire

Lifer
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
 
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.
 
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).
 
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
 
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).
Click to expand...

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,
 
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.
 
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).
Click to expand...
hope this gets fixed soon so i can change my prices 😉


 
You must log in or register to reply here.

TRENDING THREADS

Back
Top