create account!

02/29/2012 21:08 xRAZOR [BR]#1

when I try to use the command that javier passed this one ......

Quote:

1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
2. Go To Tools -> SQL Query Analyzer (Login With Your "sa" Password)
Use account;
Go
Insert Into [TBL_USER] Values ('091014102755323, 'teste', 'teste', 'teste@teste', 'tester', 'teste')
Insert Into [USER_PROFILE] Values ('09101410275533','ID','Password','091014102755323 ','1','0','Y','01/01/2006 00:00:00',nul

Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

Anyone know where is wrong?

02/29/2012 21:35 Ultimo ☼#2

Hope this help:

Code:

Use account;
Go
Insert Into [TBL_USER] Values ('09101410275532', '[COLOR="Red"]YOUR ID[/COLOR]', '[COLOR="red"]YOUR PASSW[/COLOR]', ' [COLOR="red"]YOUR E-Mail[/COLOR]', '[COLOR="red"]Secret Answer[/COLOR]', '[COLOR="red"]Secret Question[/COLOR]')
Insert Into [USER_PROFILE] Values ('09101410275532','[COLOR="red"]YOUR ID[/COLOR]','[COLOR="red"]YOUR HASHED Password[/COLOR]','801011000000','1','0','Y','01/01/2012 00:00:00',null,null,null,'000')

02/29/2012 22:01 xRAZOR [BR]#3

thanks I will test if it works thank you come XD

EDIT!!!!
did not work use a clean DB gave this error here ;/

Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

03/01/2012 13:18 Ultimo ☼#4

Try this:

Code:

Use account;
Go
Insert Into [TBL_USER] Values ('09101410275510', 'Razor', '12345x', ' [Only registered and activated users can see links. Click Here To Register...]', 'rofl', 'lmao')
Insert Into [USER_PROFILE] Values ('09101410275510','Razor','143e5423f0efc15dd2050c8bed1297ab','801011000000','1','0','Y','01/01/2012 00:00:00',null,null,null,'000')

Account info are: ID: Razor Passw:12345x

03/01/2012 18:22 imissblood#5

If you can't do it like that try this way. I made some SS.

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

To general the pw use this. [Only registered and activated users can see links. Click Here To Register...]

03/01/2012 22:28 Element~#6

i think that is best if you use register.php :P

03/02/2012 05:40 freeskier4lif3#7

lol... Does no one here read error messages?

Quote:

Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

This means that your table probably has a different number of fields than described. For example, if you're using OSDS janvier's script adds a field to USER_PROFILE.

to solve this, right click on dbo.USER_PROFILE and select "design" either take a screen shot or list what all your fields are. Then I can see what the actual issue with your script is. (TBL_USER is useless and only a security risk, you should just delete that from your database)

example of what you'll see when you click design. (this is on sql 2008 so yours may look a bit different)
[Only registered and activated users can see links. Click Here To Register...]

03/02/2012 05:41 freeskier4lif3#8

*double post: delete please.