Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Ver 7.9
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Ver 7.9

 Post Reply Post Reply Page  <123>
Author
Fiber View Drop Down
Newbie
Newbie
Avatar

Joined: 12 June 2002
Location: Spain
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Fiber Quote  Post ReplyReply Direct Link To This Post 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 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. :-)
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Fiber View Drop Down
Newbie
Newbie
Avatar

Joined: 12 June 2002
Location: Spain
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Fiber Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Fiber View Drop Down
Newbie
Newbie
Avatar

Joined: 12 June 2002
Location: Spain
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Fiber Quote  Post ReplyReply Direct Link To This Post 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 :-)
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Fiber View Drop Down
Newbie
Newbie
Avatar

Joined: 12 June 2002
Location: Spain
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Fiber Quote  Post ReplyReply Direct Link To This Post 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...)
Back to Top
Fiber View Drop Down
Newbie
Newbie
Avatar

Joined: 12 June 2002
Location: Spain
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Fiber Quote  Post ReplyReply Direct Link To This Post 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...
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  <123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.