Unable to delete ones forum posting: Swingers Discussion 34236

SwingLifeStyle Swingers Personal Ads. | SwingLifeStyle Swingers Clubs

Busy Swingers Forum

Everything you always wanted to know about swingers.

TOPIC: Unable to delete ones forum posting

Created by: willyt Original Starting post for this thread:
If an error is made when posting in the forums, there used to be a working process by clicking on "Del Post" and it would delete the posting the user that posted it just did. But now there is an error. Error Diagnostic Information ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition. SQL = "insert into deletedthreads select * from articles with (NOLOCK) where articleid=16423" Data Source = "FORUMS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (48:7) to (48:55) in the template file E:\websites\swinglifestyle . c o m\ww2\forums\admin\deletearticle.cfm. Date/Time: 05/19/04 19:27:21 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: xxx.xxx.xxx.xxx (the ip addr of the user with error) Query String: articleid=16423&approved=1&oldurl=

Created by: willyt
Original Starting post for this thread:

If an error is made when posting in the forums, there used to be a working process by clicking on "Del Post" and it would delete the posting the user  that posted it just did. But now there is an error.

Error Diagnostic Information
ODBC Error Code = 21S01 (Insert value list does not match column list)

[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition.

SQL = "insert into deletedthreads select * from articles with (NOLOCK) where articleid=16423"

Data Source = "FORUMS"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (48:7) to (48:55) in the template file E:\websites\swinglifestyle . c o m\ww2\forums\admin\deletearticle.cfm.

Date/Time: 05/19/04 19:27:21
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address: xxx.xxx.xxx.xxx  (the ip addr of the user with error)
Query String: articleid=16423&approved=1&oldurl=

GoTo Page: 1 ... More

1 to 2 of 2

User Details are only visible to members.	We're looking into that error today.
Beverly Hills CA			Username hidden (12083 post)

User Details are only visible to members.	If an error is made when posting in the forums, there used to be a working process by clicking on "Del Post" and it would delete the posting the user that posted it just did. But now there is an error. Error Diagnostic Information ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition. SQL = "insert into deletedthreads select * from articles with (NOLOCK) where articleid=16423" Data Source = "FORUMS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (48:7) to (48:55) in the template file E:\websites\swinglifestyle . c o m\ww2\forums\admin\deletearticle.cfm. Date/Time: 05/19/04 19:27:21 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: xxx.xxx.xxx.xxx (the ip addr of the user with error) Query String: articleid=16423&approved=1&oldurl=
Scottsdale AZ			Username hidden (126 post)

GoTo Page: 1 ... More

1 to 2 of 2

TOPIC: Unable to delete ones forum posting

		HELP
FORUMS: Suggestions: Website: Unable to delete ones forum posting