Print Page | Close Window

Any suggestions for this DB-issue?

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=2334
Printed Date: 31 March 2026 at 11:59am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Any suggestions for this DB-issue?
Posted By: Chris
Subject: Any suggestions for this DB-issue?
Date Posted: 30 April 2003 at 3:51pm

I am upgrading from version beta 3 to final 7.

This is the error I get after manually updating the Access 2000 database, field by field, table by table - following the instructions in Version_History.txt: 

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/w7/forum_topics.asp, line 341

Line 340-341 reads:

'Query the database
rsForum.Open strSQL, adoCon

The forum seems to work fine otherwise in the final. Does anyone have a clue as to what may cause this particular error?

Chris




Replies:
Posted By: Bunce
Date Posted: 30 April 2003 at 7:09pm

Output the strSQL string to the screen to see exactly what is being sent to the database.

response.write strSQL
response.end

Then post that string here for us to have a squiz at.

Cheers,
Andrew



-------------
There have been many, many posts made throughout the world...
This was one of them.


Posted By: genmud
Date Posted: 30 April 2003 at 8:51pm

You have to set the default value to "0" -- I think that is what I did to fix my install



Posted By: WebWiz-Bruce
Date Posted: 01 May 2003 at 2:17am
By manually updating the database things can go wrong as the auto-number fields may mean that posts, topics, members, etc. no-longer match up giving database errors.

-------------
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: Chris
Date Posted: 01 May 2003 at 5:18am

Found the error:

According to the file Version_History.txt there should be a new field in tblForum - Moved_ID - integer datatype. However, that field is actually supposed to be in tblTopic. I went into the db and changed this, now the forum seems to work.

Chris




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net