[HELP]Cant make acc for server RowID NULLED help Please:3

01/11/2012 16:18 aragonik#1
Hey guys, Mwell ive deleted everything after my server got fcked up.. >_>
and mwell i used [Dev Realease]Shaiya EP5 DB , attached it all succesfully except the Gamedata. Theres only GameData log files inside of this release.. So i used some Ep4 one D:

I tried to create an acount but the RowID keeps NULLED, and i get an error

PIC ->:[Only registered and activated users can see links. Click Here To Register...]


Please anyone help.. :(
01/11/2012 16:30 JohnHeatz#2
Why don't you try to create the account by using the INSERT query? Just to see if you keep getting the error, because one time I had this issue, and by doing it manually, I stopped getting it and actually since then I do everything by writting the query manually
01/11/2012 16:36 aragonik#3
Could you tell me wich query to use? :/ im kinda ''new'' mwell maybe not new.. but i dont know query sources that good in sql. i also have another question could i add you on skype? i have to talk about something in private and i dont like PM conversations. And posting it on your Profile Board might be a risk, so i really want to hold the things i have to talk about with you private.
01/11/2012 16:36 Phantomangel042#4
Quote:
Originally Posted by abrasive View Post
I set the UserUID column as the primary key, and set it to Identity (auto increment). After that I deleted the RowID column because it is not needed when there is already a primary key in the table, nor is it referenced in any stored procedures.

Alternatively you could allow nulls in RowID, or give RowID a default value, if you didn't want to delete RowID.

You are not allowed to set multiple columns in the same table as Identity.
From this beautiful thread: [Only registered and activated users can see links. Click Here To Register...]

So, if it's giving you troubles and you can't set it to allow nulls... just get rid of it! (After making UserID the primary, of course- see abrasive's thread for details)
01/11/2012 16:39 aragonik#5
Thanks i'll check that out for sure! I allready tried letting it accept nulls. But it still sayd that blabla.. collum doesnt allow nulls

EDITAllow nulls property cannot be set on Column RowID because it is an identity Column

ROWID Data type is int right?

#Edit2 : Epic avatar Phantom XD
01/11/2012 17:11 Phantomangel042#6
Read the post by abrasive that I linked to, page 1. Towards the bottom there's a detailed explanation of how to make UserUID the Primary Key, then set its Identity to yes (which make it auto-increment). After that, delete RowID entirely, it's not necessary. Forget about the nulls. xD

And ty, I <3 my boxcat. ^____^

PS- I used the same files as you, the ones with the gamedata.mdf missing. Later in the thread, Tyler (RebeccaBlack) put together another package of the Ep5 database files, PS_Gamedata included. Here's the link (Tyler's post is about halfway down the page): [Only registered and activated users can see links. Click Here To Register...] Might save you from some issues down the line with DB compatibility, idk.

PPS- If you do use that Gamedata that Tyler posted, be *sure* to rename it to "PS_Gamedata" in the database list after you've attached it in SQL. If it stays Gamedata as it (without the PS_), the services won't connect right and you'll get the dreaded "pause error". Just daying.
01/11/2012 17:25 aragonik#7
I did this tuturial.. But it doesnt change anything only thing that it does changes is that i can write on RowID, But now i cant write on UserUID, and im still getting the same error.

Why the fk cant this shit just fckin work.. ffs
And thx for the Tyler re-realse lol :) it indeed might spare me some errors Ty! <3


#edit I also found out that Right click table>Script table as >INSERT>SQL query :p but i stil dunno what to type there :3
because it gives me
Quote:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '1'.
at
Quote:
([UserUID]1
,[UserID]admin
01/11/2012 19:56 [DEV]xXDASHXx#8
Quote:
Originally Posted by aragonik View Post
I did this tuturial.. But it doesnt change anything only thing that it does changes is that i can write on RowID, But now i cant write on UserUID, and im still getting the same error.

Why the fk cant this shit just fckin work.. ffs
And thx for the Tyler re-realse lol :) it indeed might spare me some errors Ty! <3


#edit I also found out that Right click table>Script table as >INSERT>SQL query :p but i stil dunno what to type there :3
because it gives me at
ok this is an exact snip from tylers email verification regestration php so all creadts to tyler on this tho with a small amount of sql quary knowledge and a persistant mind it is veary easy to creat exactly the same result on your own..
Code:
INSERT INTO PS_UserData.dbo.Users_Master (UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,UserIp)VALUES ('{username}','{password}',GETDATE(),0,0,0,0,0,GETDATE(),'N',0,'{user_ip}')
this is used with UserUID tabel set at auto incruments and Row table deleated as it is just a usles row in the table
01/11/2012 19:56 aragonik#9
ehm so where do i have to place this? :/ sorry if i sound like a total noob x.x
01/11/2012 20:07 [DEV]xXDASHXx#10
this is just the snip for the addeing accounts to usermaster table so it would have to be ran as a new quary inside your sql... change all the values names userid password and so on all but the getdate sections should be edited to what you want inserted in your table
01/11/2012 20:20 aragonik#11
ffs .. :(

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '11'.

Could u make a pre set up query? with admin and admin123 as pass? please >.<
01/11/2012 20:30 [DEV]xXDASHXx#12
have to go afk work calls when i return i will creat your quary for those cridentials so if its not resolved by then i will post back in here with a quary for you

Quote:
Originally Posted by [DEV]xXDASHXx View Post
have to go afk work calls when i return i will creat your quary for those cridentials so if its not resolved by then i will post back in here with a quary for you
had a sec wateing on my ride so here you go it works via my database as i doubel checked by runing the quary in it
Code:
INSERT INTO PS_UserData.dbo.Users_Master 
(UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,UserIp)
VALUES ('admin','admin123',GETDATE(),0,0,0,0,0,GETDATE(),'N',0,'127.0.0.1')
01/11/2012 20:39 aragonik#13
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'UserUID', table 'PS_UserData.dbo.Users_Master'; column does not allow nulls. INSERT fails.


and what about Admin permissions? (255) (16)
01/11/2012 20:43 [DEV]xXDASHXx#14
value null is due to your not setup for auto incremented useruid to make admin ability just count from left to right in the first part (befor values how many tell you get to the needed filds and then count in the values filed and change to what you wish... admin is the first 0 admin level is the sec 0 status is fourth 0 change all 3 0s to requierd needed values for admin account srry no time to explain in much detail hope this helps but first thing forshure is set useruid to auto incriments
01/11/2012 21:16 aragonik#15
Sorry but im a real noob.. Q.Q why cant this stupid dbo.Users_Masters function work? for real is there no way to fix this?XD