Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Access Database Migration Tool
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Access Database Migration Tool
 Post Reply Post Reply Page  <123>
Author
  Topic Search Topic Search  Topic Options Topic Options
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 12:09am
Originally posted by xeerex xeerex wrote:

Correct my Fernan but <Null> means nothing in the field right? If so, then theSmoker needs to look for fields that have nothing in the default value and enter whatever.

Here's a suggestion. Take a look at the v7.01 tables/fields and duplicate that in your v7b3 database if the revision history is not helping you. I haven't tried it, but I bet you could do some import/export from the v7b3 database to the v7.01 database to move the data. It'd take a little work but I bet it could happen.

 

xeerex..

i have tried your suggestion and i still can not figure this out!
i am a newbie and all this is "strange" to me!

i might as well give up on it, because no one can explain this in simple terms/words

thanks for your input
Back to Top
Zamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 27 February 2003
Location: Netherlands
Status: Offline
Points: 95 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Zamal Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 3:57am

If you take a look at the version history you'll see the following database changes between 7.0 beta 3 and 7.01. My advice is to check the ones in red to see if you've done them correctly

1. tblGuestName - new table to hold the names of guest posters if guest posting is enabled
2. tblAuthor - added the following fields
 Real_name - text datatype 40 char
 Avatar_title - text datatype 50 char
3. tblGroup - new table - Custom_stars - text datatype 80 chars
4. wwfSpThreadDetails - changed strored procedure in SQL server version
5. tblPoll - new field - Author_ID - interger datatype
6. tblConfiguaration - added the following tables
 Upload_avatar - true/false datatype
 Upload_avatar_path - text datatype 50 char
 Upload_avatar_types - text datatype 50 char
 Upload_avatar_size - interger datatype
 Reg_closed  - true/false datatype
7. tblForum new field - Moved_ID - interger datatype - default value 0
8. stored procedure tblTopicDetialsAll changed
9. stored procedure tblTopicDetialsInTheLastXX changed
1. tblPermissions - Author_ID field added, datatype interger - default value 0
2. wwfspForumPermisions - stored procedure changed to also grab individual user permissions for forums
3. wwfspMederators - new stored procedure to get the moderators for forums
Back to Top
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2003 at 3:28am
Originally posted by Zamal Zamal wrote:

If you take a look at the version history you'll see the following database changes between 7.0 beta 3 and 7.01. My advice is to check the ones in red to see if you've done them correctly

1. tblGuestName - new table to hold the names of guest posters if guest posting is enabled
2. tblAuthor - added the following fields
 Real_name - text datatype 40 char
 Avatar_title - text datatype 50 char
3. tblGroup - new table - Custom_stars - text datatype 80 chars
4. wwfSpThreadDetails - changed strored procedure in SQL server version
5. tblPoll - new field - Author_ID - interger datatype
6. tblConfiguaration - added the following tables
 Upload_avatar - true/false datatype
 Upload_avatar_path - text datatype 50 char
 Upload_avatar_types - text datatype 50 char
 Upload_avatar_size - interger datatype
 Reg_closed  - true/false datatype
7. tblForum new field - Moved_ID - interger datatype - default value 0
8. stored procedure tblTopicDetialsAll changed
9. stored procedure tblTopicDetialsInTheLastXX changed
1. tblPermissions - Author_ID field added, datatype interger - default value 0
2. wwfspForumPermisions - stored procedure changed to also grab individual user permissions for forums
3. wwfspMederators - new stored procedure to get the moderators for forums

zamal or others..

i follow the above and checked it over, making sure it was spell and put in correctly!
it is all there, but i am getting this error 

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/forum_topics.asp

any help on this is grealtly appreciative

(this is getting very  frustrated to me and to others..ehh?)

 



Edited by theSmoker
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: 22 May 2003 at 3:41am

You need to make sure the new fields in the database has been set for the correct datatype and default value.

Fields like moved_ID should contain a value in every field, if you didn't give it a default value when creating this field you will have to go through the database and enter 0 in every record.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2003 at 9:11pm
Originally posted by -boRg- -boRg- wrote:

You need to make sure the new fields in the database has been set for the correct datatype and default value.

Fields like moved_ID should contain a value in every field, if you didn't give it a default value when creating this field you will have to go through the database and enter 0 in every record.

borg (or anyone that wants to help)..

remember i am a newbie to all this and please be patient as well as others that want to help me!

the moved_id has a default value of 0 and i am still getting this error 

what is the default value for the new fields?

do i put a 0 as the default value in every field or what?

thanks

 



Edited by theSmoker
Back to Top
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post Posted: 23 May 2003 at 11:37am

i guess that i am asking tooo much!! 

thanks to all that helped me!!

 



Edited by theSmoker
Back to Top
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post Posted: 24 May 2003 at 10:31pm

ok folks here is my problem...maybe

i am inserting tables as fields!

how do you make a table?

for example:
tblGroup - new table - Custom_stars - text datatype 80 chars

remember..i am a newbie and simple instructions..please! 

thanks


 
Back to Top
Zamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 27 February 2003
Location: Netherlands
Status: Offline
Points: 95 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Zamal Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2003 at 3:48am
The easiest way to insert the new table in your 7 beta 3 database would be by opening both your database and the default 7.01 database in Acces (I'm assuming that's what you use). Select the new tables in the 7.01 database and copy / paste them to your own database.
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.