Error Kngith

[Nashalito]

Hello!

When i try fix a knight character i get this error:

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1866 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(961): OTS_Player->getSkill(2) #1 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1866

I get the character but it lends me to this text when i press submit

How can i take it off?

 

[Nashalito]

BUump

 

[Cykotitan]

Perform this SQL query in phpMyAdmin:

INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1;), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1;), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1;), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1;), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1;), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1;), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1;), 6, 10, 0);

 

[Nashalito]

Error

Fel

SQL-fråga: Dokumentation

INSERT INTO `player_skills`
VALUES (
(

SELECT `id`
FROM `players`
WHERE `name` = 'Knight Sample'
LIMIT 1 ;

MySQL sa: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

[Nashalito]

Buuumpp

 

[Cykotitan]

It was because of the semicolons (;) in the subquery.

INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 6, 10, 0);

 

[Nashalito]

Wrrooong :/:/

Fel

SQL-fråga: Dokumentation

INSERT INTO `player_skills`
VALUES (
(

SELECT `id`
FROM `players`
WHERE `name` = 'Knight Sample'
LIMIT 1
), 0, 10, 0
);

MySQL sa: Dokumentation
#1062 - Duplicate entry '6-0' for key 'player_id_2'

 

[Cykotitan]

INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 2, 10, 0);

 

[Nashalito]

One more time error

INSERT INTO `player_skills`
VALUES (
(

SELECT `id`
FROM `players`
WHERE `name` = 'Knight Sample'
LIMIT 1 ;

MySQL sa: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

[Cykotitan]

Ffs same error again, k edited.

 

[Nashalito]

Thanks bro =) Its done =) addd rep

1 rad(er) infogade. ( Frågan tog 0.0312 sek )
INSERT INTO `player_skills`
VALUES (
(

SELECT `id`
FROM `players`
WHERE `name` = 'Knight Sample'
LIMIT 1
), 2, 10, 0
);

 

[Cykotitan]

But what error do you get now when creating Knight character?

 

[Nashalito]

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1866 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(962): OTS_Player->getSkill(3) #1 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1866

 

[Cykotitan]

INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample' LIMIT 1), 6, 10, 0);

 

[Nashalito]

Thats done =)=) ty bro =)