Web Wiz Forums - Any suggestions for this DB-issue?

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