creating a character, problem on quickbar (fatal error)

[lilkel]

hi i have a problema when i creating charachter...my char server says "[FATAL ERROR]: could not execute query: Field 'quickbar' doesn't have a default value... thx for helping...

[lmame]

Hi

Please don't ask the questions in a guide and use the support for this
(thread moved).

Now this question has already been asked:
viewtopic.php?f=22&t=787&p=7223&hilit=quickbar#p7223

It seems the quickbar default value is missing, ask Lolkereltje on how he did, perhaps he'll help you

[Lolkereltje]

Oki,

You probably used the rev.60 sql file and got the error.This is how I fixed it:

First of all make a backup of your character table, so you have all the data of the characters table safe. Then use this sql query (pleas do not use line numbering, or it will mess up your query):

Line number On/Off | Expand/Contract | Select all

1.  
2. DROP TABLE IF EXISTS `characters`;
3.  
4. CREATE TABLE `characters` (
5.   `account_name` varchar(64) NOT NULL,
6.   `id` int(11) NOT NULL AUTO_INCREMENT,
7.   `char_name` varchar(64) NOT NULL,
8.   `zuly` decimal(11,0) NOT NULL DEFAULT '500',
9.   `level` decimal(11,0) NOT NULL DEFAULT '1',
10.   `curHp` decimal(18,0) NOT NULL DEFAULT '50',
11.   `curMp` decimal(18,0) NOT NULL DEFAULT '18',
12.   `str` decimal(11,0) NOT NULL DEFAULT '15',
13.   `con` decimal(11,0) NOT NULL DEFAULT '15',
14.   `dex` decimal(11,0) NOT NULL DEFAULT '15',
15.   `_int` decimal(11,0) NOT NULL DEFAULT '15',
16.   `cha` decimal(11,0) NOT NULL DEFAULT '10',
17.   `sen` decimal(11,0) NOT NULL DEFAULT '10',
18.   `face` decimal(11,0) NOT NULL DEFAULT '1',
19.   `hairStyle` decimal(11,0) NOT NULL DEFAULT '1',
20.   `sex` decimal(11,0) NOT NULL DEFAULT '0',
21.   `exp` decimal(11,0) NOT NULL DEFAULT '0',
22.   `skillp` decimal(11,0) NOT NULL DEFAULT '0',
23.   `statp` decimal(11,0) NOT NULL DEFAULT '0',
24.   `clanid` decimal(11,0) NOT NULL DEFAULT '0',
25.   `classid` decimal(11,0) NOT NULL DEFAULT '0',
26.   `deletetime` decimal(20,0) NOT NULL DEFAULT '0',
27.   `clan_rank` int(11) NOT NULL DEFAULT '0',
28.   `stamina` int(11) NOT NULL DEFAULT '5000',
29.   `quests` blob,
30.   `questflags` blob,
31.   `quickbar` varchar(255) NOT NULL DEFAULT '0',
32.   `basic_skills` varchar(255) NOT NULL DEFAULT '11,12,16,20,41,42,43,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,',
33.   `askill` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
34.   `askilllvl` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
35.   `pskill` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
36.   `pskilllvl` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
37.   `respawnid` int(11) NOT NULL DEFAULT '89',
38.   `townid` int(11) NOT NULL DEFAULT '20',
39.   `class_skills` varchar(255) NOT NULL DEFAULT '0',
40.   `class_skills_level` varchar(255) NOT NULL DEFAULT '1',
41.   PRIMARY KEY (`id`)
42. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
43.  

Now, open up your backup of the characters table you've made, and search for the 'insert into' command (example):

Line number On/Off | Expand/Contract | Select all

1. /*
2. SQLyog Enterprise - MySQL GUI v6.15
3. MySQL - 6.0.3-alpha-community : Database - irose
4. *********************************************************************
5. */
6.  
7.  
8. /*!40101 SET NAMES utf8 */;
9.  
10. /*!40101 SET SQL_MODE=''*/;
11.  
12. CREATE DATABASE IF NOT EXISTS `irose`;
13.  
14. USE `irose`;
15.  
16. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18.  
19. /*Table structure for table `characters` */
20.  
21. DROP TABLE IF EXISTS `characters`;
22.  
23. CREATE TABLE `characters` (
24.   `account_name` varchar(64) NOT NULL,
25.   `id` int(11) NOT NULL AUTO_INCREMENT,
26.   `char_name` varchar(64) NOT NULL,
27.   `zuly` decimal(11,0) NOT NULL DEFAULT '500',
28.   `level` decimal(11,0) NOT NULL DEFAULT '1',
29.   `curHp` decimal(18,0) NOT NULL DEFAULT '50',
30.   `curMp` decimal(18,0) NOT NULL DEFAULT '18',
31.   `str` decimal(11,0) NOT NULL DEFAULT '15',
32.   `con` decimal(11,0) NOT NULL DEFAULT '15',
33.   `dex` decimal(11,0) NOT NULL DEFAULT '15',
34.   `_int` decimal(11,0) NOT NULL DEFAULT '15',
35.   `cha` decimal(11,0) NOT NULL DEFAULT '10',
36.   `sen` decimal(11,0) NOT NULL DEFAULT '10',
37.   `face` decimal(11,0) NOT NULL DEFAULT '1',
38.   `hairStyle` decimal(11,0) NOT NULL DEFAULT '1',
39.   `sex` decimal(11,0) NOT NULL DEFAULT '0',
40.   `exp` decimal(11,0) NOT NULL DEFAULT '0',
41.   `skillp` decimal(11,0) NOT NULL DEFAULT '0',
42.   `statp` decimal(11,0) NOT NULL DEFAULT '0',
43.   `clanid` decimal(11,0) NOT NULL DEFAULT '0',
44.   `classid` decimal(11,0) NOT NULL DEFAULT '0',
45.   `deletetime` decimal(20,0) NOT NULL DEFAULT '0',
46.   `clan_rank` int(11) NOT NULL DEFAULT '0',
47.   `stamina` int(11) NOT NULL DEFAULT '5000',
48.   `quests` blob,
49.   `questflags` blob,
50.   `quickbar` varchar(255) NOT NULL DEFAULT '0',
51.   `basic_skills` varchar(255) NOT NULL DEFAULT '11,12,16,20,41,42,43,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,',
52.   `askill` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
53.   `askilllvl` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,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.   `pskill` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
55.   `pskilllvl` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
56.   `respawnid` int(11) NOT NULL DEFAULT '89',
57.   `townid` int(11) NOT NULL DEFAULT '20',
58.   `class_skills` varchar(255) NOT NULL DEFAULT '0',
59.   `class_skills_level` varchar(255) NOT NULL DEFAULT '1',
60.   PRIMARY KEY (`id`)
61. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
62.  
63. /*Data for the table `characters` */
64.  
65. INSERT  INTO
66. `characters`(`account_name`,`id`,`char_name`,`zuly`,`level`,`curHp`,`curMp`,`str`,`con`,`dex`,`_int`,`cha`,`sen`,`face`,`hairStyle`,`sex`,`exp`,`skillp`,`statp`,`clanid`,`classid`,`deletetime`,`clan_rank`,`stamina`,`quests`,`questflags`,`quickbar`,`basic_skills`,`askill`,`askilllvl`,`pskill`,`pskilllvl`,`respawnid`,`townid`,`class_skills`,`class_skills_level`)
67. VALUES
68. ('Test',4,'Tester','20000','210','3031','2295','300','300','300','300','300','300','1','0','1','51746','17098','13115','1','322','0',6,5000,NULL,NULL,'3,35,1059,419,1027,995,1091,0,0,675,0,547,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0','11,12,16,20,41,42,43,19,21,3211,3212,3214,3216,3215,3217,3218,3206,3209,3207,3208,3219,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0','2631,1481,1521,1581,1621,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0','0,9,19,9,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0','3220,3221,2081,1401,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0','0,0,4,19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',72,20,'0','1');
69. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
70. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

(Please do not use the above given code, it is only an example)

Select all the code in your sql file that are used by the 'insert into' command (in the above called example, rows 65, 65, 66, 67 and 78), copy it and paste it in your sql query browser. Now execute it. Now all your characters already existed have been inserted into your database again. Oh, and also, the quickbar error is fixed

Conclusion (lol, now this all looks like a school project):

What the rev.60 sql file does:

Line number On/Off | Expand/Contract | Select all

1.  `quickbar` decimal(10,0) NOT NULL,

What the rev.57 sql file does:

Line number On/Off | Expand/Contract | Select all

1.  `quickbar` varchar(255) NOT NULL DEFAULT '0',

You notice the difference?

[SirSchnuffel]

What makes quickbar ?

[lilkel]

ei thx for that now its fix!

[Lolkereltje]

What makes quickbar ?

What do you mean? What code it's created by, or what it does?

ei thx for that now its fix!

You're most welcome

[SirSchnuffel]

yes i ,mean what does quickbar. Must we have this or can we play again without quickbar ?

[Lolkereltje]

yes i ,mean what does quickbar. Must we have this or can we play again without quickbar ?

I believe quickbar is the bar with the hot keys for skills (F1 - F8) So I think it is necessary. And why shouldn't you use it :S

[lmame]

I wonder why the sky is blue...

[sampler07]

where can i find this file in my server?? have the same error.. a little help please and also the instruction