| Author |
 Topic  |
|
|
teaznutz
Starting Member
Belgium
28 Posts |
 Posted - 03 October 2005 : 04:23:03
|
I need help. 
When i want to move a topic with one or more replies, then i get the following errormessage.
"Microsoft OLE DB Provider for SQL Server error '80040e2f'
UPDATE statement conflicted with TABLE REFERENCE constraint 'PORTAL_REPLY_FK01'. The conflict occurred in database 'Databasename', table 'PORTAL_REPLY'.
/post_info.asp, line 961
I can move a topic without replies, but as soon as somebody gives an answer, then i can't do it anymore!
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 03 October 2005 : 05:41:57
|
| Teaznuts ; which mods have you installed ? The table 'PORTAL_REPLY_FK01' is not a default Snitz table. |
portfolio - linkshrinker - oxle - twitter |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 03 October 2005 : 06:24:34
|
Sounds like your suspect table is PORTAL_REPLY, the constraint is actually PORTAL_REPLY_FK01
You need to look at line 961. You are probably executing an strSQL. to help diagnose, put this line just before line 961 :
Response.Write strSQL |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
teaznutz
Starting Member
Belgium
28 Posts |
Posted - 03 October 2005 : 08:02:24
|
quote:
Originally posted by laser
Sounds like your suspect table is PORTAL_REPLY, the constraint is actually PORTAL_REPLY_FK01
You need to look at line 961. You are probably executing an strSQL. to help diagnose, put this line just before line 961 :
Response.Write strSQL
This is the exact errormessage:
"UPDATE PORTAL_TOPICS SET T_MESSAGE = the question that a forummember had.
, T_SUBJECT = 'window', CAT_ID = 2, FORUM_ID = 3, T_NEWS = 0 , T_SIG = 1 , T_MAIL = 0 WHERE TOPIC_ID = 12354
Microsoft OLE DB Provider for SQL Server error '80040e2f'
UPDATE statement conflicted with TABLE REFERENCE constraint 'PORTAL_REPLY_FK01'. The conflict occurred in database 'NLtdiclub', table 'PORTAL_REPLY'.
/post_info.asp, line 961
Line 961 is;
my_Conn.Execute(strSql)
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 03 October 2005 : 09:26:17
|
"the question that a forummember had" ... did that contain some special characters ? Like a ? or a ' or a " or a / etc...
If you have anything like that, remove them and try again. |
|
|
|
teaznutz
Starting Member
Belgium
28 Posts |
Posted - 04 October 2005 : 04:18:50
|
quote:
Originally posted by laser
"the question that a forummember had" ... did that contain some special characters ? Like a ? or a ' or a " or a / etc...
If you have anything like that, remove them and try again.
i did some test.
When i type two messages and i want to remove them, i get this errormessage
UPDATE PORTAL_TOPICS SET T_MESSAGE = 'fkhjvfjhvdfjvkhcjkpaHJV', T_SUBJECT = 'Test', CAT_ID = 4, FORUM_ID = 24, T_NEWS = 0 , T_SIG = 1 , T_MAIL = 0 WHERE TOPIC_ID = 12385
Microsoft OLE DB Provider for SQL Server error '80040e2f'
UPDATE statement conflicted with TABLE REFERENCE constraint 'PORTAL_REPLY_FK01'. The conflict occurred in database 'NLdatabase', table 'PORTAL_REPLY'.
/post_info.asp, line 961
I think it has something to do with the "'PORTAL_REPLY_FK01'" but i'm not sure what the problem is! |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 October 2005 : 04:25:08
|
teaznutz,
Did you create your SQL database using the forums setup scripts or did you upsize an access DB ?
I ask because Snitz does not have any foreign key constraints, the error you are getting would indicate that you have, you will need to remove them. |
|
|
|
teaznutz
Starting Member
Belgium
28 Posts |
Posted - 04 October 2005 : 06:20:50
|
quote:
Originally posted by HuwR
teaznutz,
Did you create your SQL database using the forums setup scripts or did you upsize an access DB ?
I ask because Snitz does not have any foreign key constraints, the error you are getting would indicate that you have, you will need to remove them.
I thought it wasn't an "updated" access database.
So it's an original SQL database.
I can move a topic from one place to another, as long there are no replies in them! Kinda strange |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 October 2005 : 08:37:14
|
| well you need to remove ALL foriegn key constraints from your Database, it should not have any. |
|
|
|
teaznutz
Starting Member
Belgium
28 Posts |
Posted - 04 October 2005 : 10:10:36
|
quote:
Originally posted by HuwR
well you need to remove ALL foriegn key constraints from your Database, it should not have any.
I'm sorry but i don't know what you mean.  |
|
|
|
teaznutz
Starting Member
Belgium
28 Posts |
Posted - 06 October 2005 : 05:30:41
|
| Anyone?? |
|
|
|
teaznutz
Starting Member
Belgium
28 Posts |
Posted - 10 October 2005 : 08:07:02
|
| Nobody? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 10 October 2005 : 11:54:47
|
If you've got Access, you can view the relationships. I think there are other tools out there, though I don't know of any off the top of my head.
..now that I think about it, in a pinch you could always see if there is a trial version of access available for download and use it for this problem. Then look into either access or another program for future reference. |
Edited by - AnonJr on 10 October 2005 11:56:03 |
|
|
| |
Topic |
|
Topic Locked
