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

  New Posts New Posts RSS Feed - Gender Script Question
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Gender Script Question
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
iaforce View Drop Down
Newbie
Newbie


Joined: 21 December 2006
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iaforce Quote  Post ReplyReply Direct Link To This Post Topic: Gender Script Question
    Posted: 24 December 2006 at 12:01pm
Originally posted by Scotty32 Scotty32 wrote:

Gender Script
Mod version: V1.03
Mod Download: Website
Mod Author: Scotty32
Release Date: 13 May 2006

 
 
Great Mode..Only I'm using MySQL
any Gender mode for MySQL ??
Back to Top
Mikey View Drop Down
Senior Member
Senior Member

1979

Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mikey Quote  Post ReplyReply Direct Link To This Post Posted: 24 December 2006 at 1:49pm
Please do not post support questions in the mod index.

[Moved from index to new topic]
Handyman man?
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 24 December 2006 at 5:26pm
i think the only thing stopping you from using it on MySQL is the update script to add the field to the database, if you have access to the db, you can always add an Int field to the "tblAuthor" table and call the field "Gender_Mod"

also if your using 8.05, best to wait as it was only updated for 8.04 and changes to WebWizForum have been made to the same files.

the next version of this mod will have a MySQL update script with it
and it will be released when i have time to work on it - which will be sometime after christmas


Edited by Scotty32 - 24 December 2006 at 5:27pm
S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
iaforce View Drop Down
Newbie
Newbie


Joined: 21 December 2006
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iaforce Quote  Post ReplyReply Direct Link To This Post Posted: 25 December 2006 at 10:16am
Hello Scotty
Yep, I'm using ver 8.05
I also have access to the DB.
I created new filed  named "Gender_Mod" at Author table.
Data Type= INT ; Not Null ; Default= 0

it should work the same as MSSQL however when I try register or update user gender I keep getting an error.
I do not get an error if its in defaults ("private, 0)

Error Message :

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum/register.asp, line 856

line 856 :      .Fields("Gender_Mod") = intGender
 
When I open the database and change the value (to 1/2), I can see it on the profile.
however, I can not create or update from the forum itself . I keep getting the error.

If you can come with any idea or with a script for MySQL, you will make someone happy ... :)

Happy Holiday !!
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 28 December 2006 at 1:09pm
This mod has been updated to be compatible with the latest version of web wiz forums (Version 8.05).

am sorry i was unable to release a MySQL update file as i dont have a MySQL forum to test it on - i did create a file but i havent tested it. If anyone would like to be my Ginni pig send me a PM - once the update file is sorted i'll add it to the release.

and iaforce - your problem is to do with the SQL statement - use the latest file and it should work fine.
S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
iaforce View Drop Down
Newbie
Newbie


Joined: 21 December 2006
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iaforce Quote  Post ReplyReply Direct Link To This Post Posted: 28 December 2006 at 8:17pm
The problem was whitin the code itself
at page " forum_posts.asp "

Instade your  line :   '20 = tblAuthor.Gender

I have changed the line to   '20 = tblAuthor.Gender_Mod (don't know how I missed that)
 
everything works fine now
 
anyway, I'll check your update aswell.

Many thanks for the code  Thumbs%20Up


Edited by iaforce - 28 December 2006 at 8:18pm
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 29 December 2006 at 9:44am
the above line you mention i think i spotted in the upgrade.

but thats just a comment and bares no relivence to the page (in terms of coding) so it wouldnt course any problems
S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
Ali Bilgrami View Drop Down
Senior Member
Senior Member
Avatar

Joined: 14 April 2005
Location: Pakistan
Status: Offline
Points: 492 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Ali Bilgrami Quote  Post ReplyReply Direct Link To This Post Posted: 30 December 2006 at 11:51pm
I am facing the same problem i.e 

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum2/register.asp, line 883

Line 883 = .Fields("Gender_Mod") = intGender
 
I did update from the latest version of your mod as I too am using 8.05. Though I did not rewrite the file but only inserted the code of your mod. any ideas???
Lets!
Back to Top
 Post Reply Post Reply Page  12>

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.