• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Urgent Problem paying 5$ USD for full fix

FLE

FLE

Member
Joined
Oct 5, 2008
Messages
422
Reaction score
24
Location
Vancouver Canada
When i try to create a character i get this error,

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2147483647' for key 'PRIMARY'' in C:\xampp\htdocs\pot\OTS_Player.php:187 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(187): PDO->query('INSERT INTO`pla...') #1 C:\xampp\htdocs\accountmanagement.php(799): OTS_Player->save() #2 C:\xampp\htdocs\index.php(136): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 187



I am using 'Norix' Version of Gesior Acc for 0.3.4 beta , what i did is deleted all characters lvl 20- that have been inactive for over 20 days, this deleted my sample characters, and im not sure how to replace them, please help me this is very urgent :s

Thanks in advance!!

-Martin
 
Last edited:
Sort by date Sort by votes
Run these sql commands..
Rook
Code: 
INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, redskulltime, redskull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Rook Sample", 1, 1, 1, 0, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1);
Sorcerer
Code: 
INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, redskulltime, redskull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Sorcerer Sample", 1, 1, 1, 1, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1);
Druid
Code: 
INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, redskulltime, redskull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Druid Sample", 1, 1, 1, 2, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1);
Paladin
Code: 
INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, redskulltime, redskull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Paladin Sample", 1, 1, 1, 3, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1);
Knight
Code: 
INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, redskulltime, redskull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Knight Sample", 1, 1, 1, 4, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1);
 
Upvote 0 Downvote
Hey, I tried to run these sql queries, the first 1 i make works fine, the 2nd,3rd, and 4th say this "#1062 - Duplicate entry '2147483647' for key 'PRIMARY' "


Can someone please help me fix this, and thanks guys above! ill rep u both!


Still need help :s

thanks

- Martin
 
Upvote 0 Downvote
FLE, the samples is the sql commands that MG Zeke wrote.

And do what Saj wrote.. enter xampp/htdocs/config and open config.php, then change "install=no" to "install=yes". and just do all the steps again, because when you do the 3rd or 4th step then you will import the samples (can't remember which step it is of those 2)

If it will still not work to import the samples then you can try to change the version of your account website
 
Upvote 0 Downvote
flaxe, do i save the samples somewhere? so they import themselves on the 3rd or 4th step? last time i did it manually but since then the acc has updated and i belive its not possible to do so anymore.
 
Upvote 0 Downvote
You don't save them anywhere, they will just get imported when clicking on one of the steps (3rd or 4th). But download the newest website for your TFS Version and it will work. If you don't know what version of website that is best for you, then post your version of your TFS and I will link it for you.
 
Upvote 0 Downvote
Hey flaxe, I am currently using this version of the acc, and i get this error when it comes to step 4

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2147483647' for key 'PRIMARY'' in C:\xampp\htdocs\install.php:528 Stack trace: #0 C:\xampp\htdocs\install.php(528): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 528


Thanks again!
 
Upvote 0 Downvote
well thanks for your help mate, ill rep you

But im still in need of help, people cant make new accounts on my server.. the population is going down :(

please help - Thanks

- Martin
 
Upvote 0 Downvote
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine' in C:\xampp\htdocs\pot\OTS_Player.php:187 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(187): PDO->query('INSERT INTO `pl...') #1 C:\xampp\htdocs\accountmanagement.php(799): OTS_Player->save() #2 C:\xampp\htdocs\index.php(178): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 187

^ That is the error players are getting when they create a character.

I will pay 5 USD VIA Paypal, to the person who does this for me.
 
Upvote 0 Downvote
I figured it out.... The database is getting the same player id , for each new player made... In this case its "1062 Duplicate entry '2147483647' for key 'PRIMARY'' it is not getting the random number it should be on character creation

Can someone help me?

Thanks
 
Upvote 0 Downvote
Back
Top