Ver 7.9
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14665
Printed Date: 13 April 2026 at 1:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Ver 7.9
Posted By: markmied
Subject: Ver 7.9
Date Posted: 12 April 2005 at 7:50pm
|
I convert from older version 6.X couple of weeks ago - no problem.
Now I get this:
Microsoft JET Database Engine error '80040e21'
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
/forum/post_message.asp, line 756
***********
(duplicate values in the index???) I get this error when trying to create a new posting. No changes were made to the forum and I have no idea why it started acting up. Funny thing is that sometimes it will work and sometimes not.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 13 April 2005 at 7:07am
|
Sounds like your access database is corrupted. Download the database, open it in Access, and use the 'compact and repair tool' found in the 'Tools' menu of MS Access. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: markmied
Date Posted: 13 April 2005 at 6:28pm
| Thank you, that was the problem. |
Posted By: Fiber
Date Posted: 09 May 2005 at 4:43am
|
It has happened the same to me... I'm downloading it now, i hope it also works...
Just one question, the repair tool in the admin section, it's only for small problems ??? (i suposse, because i executed it and the problem continued...)
|
Posted By: WebWiz-Bruce
Date Posted: 09 May 2005 at 4:56am
|
This topic was for the 6.x version which doesn't have the compact and repair toll built into the admin section. I guess as you have it built in you must be using a 7.5 + version. The version from the admin area should work much the same as when you download and run it from Access, but it's worth giving it ago anyway. If your forum has more than a handful of users I try to get people to use the MS SQL Server version, as Access often becomes corrupted, and often can not be recovered. If you must use the Access version I would make daily backups just for this reason. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Fiber
Date Posted: 09 May 2005 at 6:10am
|
:-(
After repairing the database via the administration section, downloading the file and repairing it in access and even deleting a lot of threats and repairing again, i get the same error message....
Arghhh!!!!
The thing is that i see the threat created, but no messages in it... I see the old messages, but the news, no...
I could not get the MS SQL Server version because i don't have license... :-(
Anyway, i think it's not a problem of the database... 352 topics, 4860 posts and 2001 members... 316 private messages.
I have just make members maintenance... 1500 now. :-)
The error message is :
Microsoft JET Database Engine error '80040e21' The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. /forum/post_message.asp, line 756 PLEASE, HELP !!!! :-) |
Posted By: WebWiz-Bruce
Date Posted: 09 May 2005 at 6:27am
|
48,000 posts and 1,500 members is allot for Access to cope with when it
comes forum systems as they put so much pressure on the database. I
usually recomend people move across to MS SQL Server at around 8,000
posts max. Access was built as a desktop application and simply can not cope with heavy use, like for a web sites forum. It could be that the database is busted beyond repair. Have a look at www.webwiz.net we can give you hosting with MS SQL Server support for as little as $6.95 per month. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Fiber
Date Posted: 09 May 2005 at 6:43am
|
But it's not 48000 but 4.800 !!! (now reduced to 2396)... users has also reduced to 1.400...
It's very weird because with version 6.0 there was no problem (i update the last week)... Maybe there's a problem with the database converter... :-(
I hope not !!! :-)
I just tried to add a message to a topic already created and i got this message :
Error de Microsoft VBScript en tiempo de ejecución error '800a000d' No coinciden los tipos: 'strFromEmailName.FromName' /forum/functions/functions_send_mail.asp, line 251
After this mesage, i got the usual one :-(
 my forums... |
Posted By: Fiber
Date Posted: 12 May 2005 at 10:43am
|
After installing Service Pack 3, the last jet database engine, the latest MDAC.... Deleting half the messages (the older ones), and half the users.... I think it's a problem with the program that passes the 6.0 database to 7.0 format... The program gets a bit messed up with the database indexes, i suposse... :-(
The message i'm getting is the same as before...
Microsoft JET Database Engine error '80040e21'
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. /forum/post_message.asp, line 756 The url that "crashes" is http://www.devir.es/forum/post_message.asp?PN=1 - http://www.devir.es/forum/post_message.asp?PN=1 maybe, there's a problem with that page ? :-? (PN=1 what means ?)
Sadly, I suposse that i would revert to 6.0 again because lossing all the previous message is not something i want to make... (also the users, of course)...
Please, help me if possible. :-)
|
Posted By: WebWiz-Bruce
Date Posted: 12 May 2005 at 10:52am
|
The tool was amde by the 3rd party. But one thing you need to do is makde sure that you compact and repair both database before and after you migrate the posts from the 6.x database to the 7.x database. This should fix any idex issues that access may have. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Fiber
Date Posted: 12 May 2005 at 11:07am
|
Yeah, i know...
I have compacted and repaired the database a lot of times... And no way... :-( I'm going to compact now the much smaller database to see if there's any good news... I would keep you informed.
Thanks a lot for the help.
|
Posted By: Fiber
Date Posted: 12 May 2005 at 12:28pm
|
IT WORKS !!!... Now is writing the messages ok... But, there's another problem... I get continously this message after writing any message) (the message is wrote, though)...
Error de Microsoft VBScript en tiempo de ejecución error '800a000d' No coinciden los tipos: 'strFromEmailName.FromName' /forum/functions/functions_send_mail.asp, line 251 I'm sending you a ham for all the help you are giving me, BoRG :-) |
Posted By: WebWiz-Bruce
Date Posted: 12 May 2005 at 1:20pm
|
Could be corrupted file, try reuploading the files again. If that fails, could you translate the error message to english so I can work out whats wrong. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Fiber
Date Posted: 13 May 2005 at 4:12am
|
I have uploaded the files again, and nothing... :-(
The translation...
Error de Microsoft VBScript en tiempo de ejecución error '800a000d'
No coinciden los tipos: 'strFromEmailName.FromName'
/forum/functions/functions_send_mail.asp, line 251
VBScript Microsoft execution error '800a000d'
Type mismatch: 'strFromEmailNam.FromName'
/forum/functions/functions_send_mail.asp, line 251
I don't know why puts the message in spanish if the hosting windows is in english... :-?
I have checked the administrator profile (added an e-mail, etc...) and it's the same... Also i have written with another forum account, and the same error... The message is written in the thread, but it's not very polite that this message is show in the internet explorer (or mozilla, or whatever...)
|
Posted By: Fiber
Date Posted: 13 May 2005 at 6:04am
|
I have debugged the problem and it seems that is a problem with the ASPEmail code lines....
It seems that there is a timeout when he tries to send the messages to the people "subscribed" to that forum... Maybe, too much people subscribed to get the new messages from the forum...
There's a way to see how many people receives the messages wrote in a forum ??? If i don't need to download the database it would be beter, but if needed.
Now i'm disabling the forum e-mail features, at least for now...
Oh, i have also tested the CDOSYS system but it happens more or less the same... Maybe i could install JMail...
|
Posted By: dpyers
Date Posted: 13 May 2005 at 11:02am
|
Does your host have a limit on the number of emails that can be sent at one time? ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: Fiber
Date Posted: 13 May 2005 at 11:46am
|
Yeah, maybe that's the problem... I use a relay smtp server that maybe have some kind of limit (or maybe is very saturated)... I would try to use another one with user autenthication...
I would tell you something.
|