| Author |
 Topic  |
|
|
StephenD
Senior Member
Australia
1044 Posts |
 Posted - 28 August 2004 : 07:15:25
|
I got my ISP to do the required changes but he reported the following error when tryimg to do the index for Forum_Reply:
'FORUM-REPLY' table
- Unable to create index 'IX_FORUM_REPLY'
ODBC error: CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 10. Most significant primary key is '2'
Every other table worked - Forum_Topics, Forum_A_Topics, Forum_A_Reply
Any ideas? |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 28 August 2004 : 21:58:09
|
Tried to do a search anyway and got the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Cannot use a CONTAINS or FREETEXT predicate on table 'FORUM_TOPICS' because it is not full-text indexed.
/search_mssqlft.asp, line 193
Does this mean the index was not created successfully fot this table?
|
 |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 30 August 2004 : 17:06:07
|
| Just bumping up to top... |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 30 August 2004 : 17:18:08
|
Looks like you have a error in your reply table that allowed a duplicate record with the same reply_id to be created. You'll have to find the duplicates and decided what to do with them. Run the SQL code below to find the offending records. What's either disturbing or good news, is that the first problem record is number 2. So, either it was an error early on in the installation and it's easy to clean up, or it's been happening since post number 2 and you'll find quite a few of them.
If the creating of the unique index was unsuccesful, then the table would not be able to be indexed, hence the second error.
select reply_id from forum_reply group by reply_id having (count(*) > 1)
|
KawiForums.com
 |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 30 August 2004 : 17:33:31
|
| I keep getting an 'invalid object name 'forum_reply' error in osql. I've got the db open with access at the moment. What am I looking for? Duplicate reply_ids? |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 30 August 2004 : 17:40:19
|
| I copied the entire reply_id column (480 rows only) into excel and ran a scan for duplicates macro which returned no results. |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 30 August 2004 : 19:08:04
|
| The error is saying that the reply_id column has a duplicate entry where reply_id=2. The SQl script that creates IX_FORUM_REPLY only indexes the reply_id column so the duplicate has to be there unless there is a problem with the SQL install itself, like maybe a corupted database. |
KawiForums.com
|
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 30 August 2004 : 21:00:35
|
| OK reply_id=2 does not exist. MY db is less than 5MB zipped. Is it worth sending to you to have a look at Gary please? |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 30 August 2004 : 21:49:39
|
| If you have a SQL backup file, then post it up somewhere and send me a link. If it's an Access dump or something, then that's not going to help. |
KawiForums.com
|
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 30 August 2004 : 23:01:33
|
| Its an SQL backup, but I won't be able to get hold of it till I get home tonight. I'll send you a link then. Thanks for your help. |
|
|
| |
Topic |
|
Topic Locked
