Error adding samples - 0.3.6

[bury]

Hello, I'm doing one more try to see If I can fix this.

I decided to start again my server but this time in (my desktop) windows and found a 64 bits version of 0.3.6 edited by Cyko and developed by other members like Talaturen, Elf etc. Okay. Tried my data and it worked 90% (some bugs I'll fix easily with time but the most important things worked).

Downloaded uniserver and the last branch 0.3.6 gesior version (TFS-0.3.6_and_0.4_to_rev_3703).

I used this schemas for the phpmyadmin database:

· TFS 0.3.6 - [MySQL] TFS 0.3.6 mysql_schema - Pastebin.com

Okay, I'm installing the server and everything goes ok:

The columns that are not added is because they already exist, but now when I try to add the samples...:

Everything seems ok, right?:

As you can see no player is created, it only exists the acc manager that was created with the schemas... Obiously If I try to create a chracter in the website it gives error because of the vocation since it doesnt find the sample.... What could I do?

Thanks you.

 

[Elgenady]

check config in site file and be sure u use right database

 

[bury]

check config in site file and be sure u use right database

Yeah, I realized about that because I checked if columns in step 3 are added, and yeah, before they weren't there, so everything is going fine until the samples and I dont know why. This is frustrating, I dont have much time but I'm trying to fix this for some days yet.

bump

 

[WibbenZ]

Insert them manually to your database and skip that step;

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `show_outfit`, `show_eq`, `show_bars`, `show_skills`, `show_quests`) VALUES
(1, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(2, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(3, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 1302858859, 16777343, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(4, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(5, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1);

 

[bury]

Insert them manually to your database and skip that step;

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `show_outfit`, `show_eq`, `show_bars`, `show_skills`, `show_quests`) VALUES
(1, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(2, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(3, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 1302858859, 16777343, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(4, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1),
(5, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 0, 0, 0, 0, 0, 128, 0, 0, 35, 35, 0, 0, 2, 0, 0, 0, '', 600, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 1, 0, '', 1, 1, 1, 1, 1);

Hey, thanks for the answer. If I try to execute this in sql:

MySQL ha dicho:

#1054 - La columna 'created' en field list es desconocida

In English:

Mysql has said:

#1054 - The column 'created' in field list is unkown.

 

[WibbenZ]

Hey, thanks for the answer. If I try to execute this in sql:

MySQL ha dicho:

#1054 - La columna 'created' en field list es desconocida

In English:

Mysql has said:

#1054 - The column 'created' in field list is unkown.

Go to index.php and look for DEBUG_DATABASE (at top of the file), then change false to true, re-do the installation and take an ss of the installation screens again.

 

[bury]

Go to index.php and look for DEBUG_DATABASE (at top of the file), then change false to true, re-do the installation and take an ss of the installation screens again.

One thing, when I import the schemas mysql.sql to the database (I pasted in the OP the schemas 0.3.6 I use) it gives me this error. Maybe this is the problem? (if u dont understand something tell me)

Now, with the option switched true as you told me, is exactly the same. It says it creates samples but then only account manager is created!

 

[WibbenZ]

One thing, when I import the schemas mysql.sql to the database (I pasted in the OP the schemas 0.3.6 I use) it gives me this error. Maybe this is the problem? (if u dont understand something tell me)

Now, with the option switched true as you told me, is exactly the same. It says it creates samples but then only account manager is created!

It should give a bunch of text of all the queries that got executed.
Try to reinstall uniform or w/e you are using, creating a new database and installation gesior again.
Seems like something is bugged, might be oncreate_players but if that is the correct database schema it has to be something in the installation / bugged version of uniform etc

 

[bury]

It should give a bunch of text of all the queries that got executed.
Try to reinstall uniform or w/e you are using, creating a new database and installation gesior again.
Seems like something is bugged, might be oncreate_players but if that is the correct database schema it has to be something in the installation / bugged version of uniform etc

Found it on znote github!

Database schemas · Znote/ZnoteAAC Wiki · GitHub

Uniform server is the last version, gesior is the last version of 0.3.6 downloaded from his github too and downloaded that one because my server as I said is o.3.6 64 bits for Windows. I can try with xampp and see if the problem is of the uniserver.

 

[WibbenZ]

And you are sure you are using 0.3.6?
Ye try that, I only use xampp just don't host with it

 

[bury]

And you are sure you are using 0.3.6?
Ye try that, I only use xampp just don't host with it

The problem is that I dont know what version of xampp could I use. I used this data in a debian OVH host some years ago (around 2013), but now I wanted to start again in my PC and you can't host a server with a 32 bits exe, so I searched here a 64 bits version and found the one edited by Cyko. My server starts and work 90% properly, for example, Yalahari quest had a little bug but all spells worked fine. The thing is I worked in that OT for 2 years but it was adapted to debian. Maybe I used 0.4 in debian?

Anyway the branch is called:

TFS-0.3.6_and_0.4_to_rev_3703

When the server starts:

The Forgotten Server - Edited By Cyko V8, version 0.3.6 - Edited By Cyko V8 (Crying Damson - Edited By Cyko V8)
Compiled with GNU C++ version 3.4.5 (mingw special) at Apr 6 2013, 11:07:44.
A server developed by Elf, slawkens, Talaturen, KaczooH, Lithium, Kiper, Kornholijo.
Visit our forum for updates, support and resources: OTLand.

 

[bury]

Okey, tried with xampp and samples are added automatically so yea, the problem could be uniformserver...

I had to change something in the phpmyadmin/libraries to create the properly user and password (set in config.lua) to allow gesior install the website. Now the problem is that everything is installed fine (finally!!) but I get this error....:

Tried with the last version of xampp (Download XAMPP). Tried with both schemas sql (0.4 and 0.3.6) and the branch of gesior is 0.3.6 to 0.4... with uniform server was 0 bugs but the samples were not added.

 

[WibbenZ]

That's not an error, that is what I was talking about with debugging the database, doing that you can see the "hidden" errors from queries, ex if your most powerfull guilds dosn't show up your would have a message at "Error message".
Just change it back to false in index.php.

 

[bury]

Lol DD ok, Fixed!

Thanks for your help, WibbenZ