#10632 - 02/16/06 07:53 PM
Player Registration problems
|
larou
Corn Flakes
Registered: 02/16/06
Posts: 60
Loc: Saskatchewan Canada
|
Offline
|
|
I just installed DK I have a problem. I can log in and play with my admin account but when anyone trys to register they get this message
Incorrect integer value: '' for column 'id' at row 1
I am also getting this message when I try to send something in the babble box
Out of range value adjusted for column 'id' at row 1
Can anyone help me out give me an idea of whats wrong & how to fix it.
Please & thank you
Larou
Edited by larou (02/16/06 08:20 PM)
|
|
Top
|
|
|
|
#10634 - 02/17/06 12:11 AM
Re: Player Registration problems
[Re: Jamin]
|
larou
Corn Flakes
Registered: 02/16/06
Posts: 60
Loc: Saskatchewan Canada
|
|
Offline
|
|
Ya im running MySQL 5 you guessed it right ill have to try to down grade a bit lol. & Try that out.
Im having some fun with the script I hope to get it running so my friends may have some fun.
_________________________
I know nothing!
Im learning PHP and in the process I am Becoming a God of my own world! Lord Antarius Kingdom Of Vandrall !Dragon Knights! Swords Of Destiny
|
|
Top
|
|
|
|
#10635 - 02/17/06 04:54 PM
Re: Player Registration problems
[Re: pker]
|
larou
Corn Flakes
Registered: 02/16/06
Posts: 60
Loc: Saskatchewan Canada
|
|
Offline
|
|
Thanks Jamin for the help I downgraded MySQL from 5 to 4 and it works good now havent had the game online 24 hours and I 3 players plus myself allready.
I have it setup on a temporary server right now untill I get it all figured out and runing smooth if anyone would like to check it out its at http://70.64.206.110/dk
I have added a few of the mods so far.
Thanks again for the help Jamin, it's much appretiated.
Larou Admin @
!Larou's Place! - Of Online Value & Interest. http://members.shaw.ca/larou
_________________________
I know nothing!
Im learning PHP and in the process I am Becoming a God of my own world! Lord Antarius Kingdom Of Vandrall !Dragon Knights! Swords Of Destiny
|
|
Top
|
|
|
|
#10637 - 02/18/06 02:59 AM
Re: Player Registration problems
[Re: VonGrugen]
|
larou
Corn Flakes
Registered: 02/16/06
Posts: 60
Loc: Saskatchewan Canada
|
|
Offline
|
|
oops sorry about that I must have rushed it the address is http://70.64.206.110/games/dk
_________________________
I know nothing!
Im learning PHP and in the process I am Becoming a God of my own world! Lord Antarius Kingdom Of Vandrall !Dragon Knights! Swords Of Destiny
|
|
Top
|
|
|
|
#10638 - 02/18/06 09:04 PM
Re: Player Registration problems
[Re: pker]
|
xanderman
Corn Flakes
Registered: 12/06/05
Posts: 79
Loc: Australia
|
|
Offline
|
|
i had the same problem when i set up mysql5 on my machine. if its your own server, comment out sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
in my.ini; then you should be able to use mysql5 with no worries.
|
|
Top
|
|
|
|
#14723 - 05/03/07 02:28 AM
Re: Player Registration problems
[Re: xanderman]
|
nxadmon
Malt-o-Meal
Registered: 05/03/07
Posts: 1
|
|
Offline
|
|
same problem running DK on win iis, im also hosting a few other web sites so i changed the code in users.php on line 63 to:
$query = doquery("INSERT INTO `dk_users` set id=NULL ,regdate=NOW(),verify='$verifycode',username='$username',password='$password',email='$email1',charname='$charname',charclass='$charclass',difficulty='$difficulty'", "users") or die(mysql_error());
First day to php so if my code looks a littles hacked up, chill out and go easy on me
|
|
Top
|
|
|
|
|
