Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - I’m having a slight prob...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

I’m having a slight prob...

 Post Reply Post Reply
Author
Necronom View Drop Down
Groupie
Groupie


Joined: 19 October 2001
Location: United States
Status: Offline
Points: 116
Post Options Post Options   Thanks (0) Thanks(0)   Quote Necronom Quote  Post ReplyReply Direct Link To This Post Topic: I’m having a slight prob...
    Posted: 22 April 2003 at 10:07pm

1. Here's the error i get when trying to delete a memeber:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/delete_member.asp, line 138

2. Yes I'm one of the retards thats trying to upgrade from beta 3 to RC1 (you can flame if you wish...it's your life your wasting)

3. The line it's erroring out at is this (including SQL line so you know whats going on):

    strSQL = "DELETE FROM " & strDbTable & "Permissions WHERE (Author_ID ="  & lngMemberID & ")"
   
    'Write to database
138 ->  adoCon.Execute(strSQL)

4. When I looked in the Permissions table there's nothing in there. I don't run groups so is that y? Is this a bug or was something not created during user reg because I upgraded?

Thanks for any help that you provide!!

. necronom .

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: 23 April 2003 at 1:26am

In RC1 there is a new field in the permissions table called Author_ID that holds an integer value, with the default value being 0

Make sure you have added this new field in this table.

Back to Top
Necronom View Drop Down
Groupie
Groupie


Joined: 19 October 2001
Location: United States
Status: Offline
Points: 116
Post Options Post Options   Thanks (0) Thanks(0)   Quote Necronom Quote  Post ReplyReply Direct Link To This Post Posted: 23 April 2003 at 2:15pm

Thanks much!!

. necronom .

Back to Top
 Post Reply Post Reply

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.