Character Creation Issues

[JnM2469]

Ok here is what keeps hapening. After i create a new character i get this error:
...
22:56 D [Arcemu] Character Enum: Built in 0 ms.
Spell::cast 3127, Unit: 1
WORLD: Spell effect id = 22 (PARRY), damage = 6
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO characters VALUES (1, 1,'Randomname', 6,7,0,0,80,0,0,'0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,','54;1;400;95;1;400;124;1;1;136;1;400;162;1;400;375;1;1;414;1;1;415;1;1;43
3;1;1;573;1;1;', 4008636142,0,0,0,500000000,0,11,69,0,0,33554695,33554433,0,8,-2
917.58, -257.98, 52.99, 0, 1, 215, '2097152 0 0 0 0 0 0 0 0 0 0 0 ', 0, '', 1299
301003,0,-2917.58, -257.98, 52.99, 1, 215, 0, 0, 0, '0 0 0 ', 0, 0, 1, 0,0,0,0,
0, 0, 0, 0, 0, 0, 0, 0, 0,0,'0','0','0','81,107,198,203,204,227,331,403,522,669,
670,2382,2479,3050,3127,3365,6233,6246,6247,6477,6478,6603,7266,7267,7355,8386,9
077,9078,9116,9125,20549,20550,20551,20552,21651,21652,22027,22810,27763,','','2
1,64,500,500,46,4,0,0,47,6,-42000,-42000,54,6,-42000,-42000,59,16,0,0,67,25,3500
,3500,68,17,500,500,69,6,-42000,-42000,70,2,-10000,-10000,72,6,-42000,-42000,76,
17,3100,3100,81,17,4000,4000,83,4,2999,2999,86,4,2999,2999,87,2,-6500,-6500,92,2
,2000,2000,93,2,2000,2000,169,12,500,500,270,16,0,0,289,4,0,0,349,0,0,0,369,64,5
00,500,469,14,-42000,-42000,470,64,500,500,471,22,-42000,-42000,509,2,-42000,-42
000,510,16,0,0,529,0,200,200,530,17,3100,3100,549,4,2999,2999,550,4,2999,2999,55
1,4,2999,2999,569,4,0,0,570,4,0,0,571,4,0,0,574,4,0,0,576,2,-3500,-3500,577,64,5
00,500,589,6,-42000,-42000,609,0,0,0,729,16,0,0,730,2,-42000,-42000,749,0,0,0,80
9,16,0,0,889,16,0,0,890,6,-42000,-42000,891,14,-42000,-42000,892,24,0,0,909,16,0
,0,910,0,-42000,-42000,911,17,400,400,922,16,0,0,930,6,-42000,-42000,932,80,0,0,
933,16,0,0,934,80,0,0,935,16,0,0,936,28,0,0,941,16,-500,-500,942,16,0,0,946,0,-4
2000,-42000,947,16,0,0,948,8,0,0,949,24,0,0,952,0,0,0,967,16,0,0,970,0,-2500,-25
00,978,0,-42000,-42000,989,16,0,0,990,16,0,0,1005,4,3000,3000,1011,16,0,0,1012,1
6,0,0,1015,2,-42000,-42000,1031,16,0,0,1037,6,0,0,1038,16,0,0,1050,6,-42000,-420
00,1052,152,0,0,1064,16,0,0,1067,16,0,0,1068,6,-42000,-42000,1073,16,0,0,1077,16
,0,0,1082,2,-42000,-42000,1085,16,0,0,1090,16,0,0,1091,16,0,0,1094,6,-42000,-420
00,1098,16,0,0,1104,16,0,0,1105,16,0,0,1106,16,0,0,1117,12,0,0,1118,12,0,0,1119,
0,-42000,-42000,1124,16,0,0,1126,0,-42000,-42000,1136,4,0,0,1137,4,0,0,1154,4,0,
0,1155,4,0,0,1156,16,0,0,','6603,0,0,403,0,0,331,0,0,59547,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,4604,0,128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,20549,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,','0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,','','', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0,0,0,0,0,0,','','0,0,0,0,0,0,','',1
, 0, '0 0', '1','1', '')]
[Session] Received out of range packet with opcode 0x04FF
...
The character isnt in the creation screen and there seems to be no data of the character in the database. Can someone please tell me whats going on?

[stoneharry]

Go to uncompiled core folder -> Go into SQL folder -> Apply all SQL updates to the appropriate databases as required.

[JnM2469]

ok i did that now im getting a different error :/ :
...
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO playeritems VALUES(1,81,6096,0,0,0,1,0,0,0, 0, 0,0,-1,3,'','0','0
','0')]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO playeritems VALUES(1,79,56,0,0,0,1,0,0,0, 0, 0,35,-1,4,'','0','0'
,'0')]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO playeritems VALUES(1,80,1395,0,0,0,1,0,0,0, 0, 0,25,-1,6,'','0','
0','0')]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO playeritems VALUES(1,78,55,0,0,0,1,0,0,0, 0, 0,0,-1,7,'','0','0',
'0')]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO playeritems VALUES(1,77,35,0,0,0,1,0,0,0, 0, 0,25,-1,15,'','0','0
','0')]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO playeritems VALUES(1,82,6948,0,0,0,1,0,1,0, 0, 0,0,-1,23,'','0','
0','0')]
[Session] Received out of range packet with opcode 0x04FF
...
im still a noob at making servers sorry lol

[stoneharry]

Still haven't applied all the updates. Your database structure does not match the database structure the core is trying to use.

Make sure the character updates are applied to your character database.