AAC Gesior Not Add samples to DB:

[tanii]

Hello,

I have issues with gesior acc 0.4 and i am using 0.4 - 3777 rev - ubuntu 16.04

i didn't faced this issue from other hosts, this time i am using other company host, and i am getting this error.

the error is gesior acc dosen't Add samples to DB:




please help me to fix that

 

[Gesior.pl]

I think we fixed it on Skype/Discord.

If you have similar problem, you should edit install.php, under (179 line):

$SQL = Website::getDBHandle();

Add:

Website::getDBHandle()->setPrintQueries(true);

Then website will print all queries send to database during installation. It will also print all errors with text messages what is wrong with query to database.

In this case it was missing 'comment' column in table 'players'.

 

[tanii]

I think we fixed it on Skype/Discord.

If you have similar problem, you should edit install.php, under (179 line):

$SQL = Website::getDBHandle();

Add:

Website::getDBHandle()->setPrintQueries(true);

Then website will print all queries send to database during installation. It will also print all errors with text messages what is wrong with query to database.

In this case it was missing 'comment' column in table 'players'.

Thanks you gesior to help us always, solved

 

[cocacola13]

bump im have this same problem.

Add samples to DB: [TABLE] [TR] [TD]Query:[/TD] [TD]SELECT `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`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Account Manager'[/TD] [/TR] [TR] [TD]SQLSTATE:[/TD] [TD]42S22[/TD] [/TR] [TR] [TD]Driver code:[/TD] [TD]1054[/TD] [/TR] [TR] [TD]Error message:[/TD] [TD]Unknown column 'comment' in 'field list'[/TD] [/TR] [/TABLE]

Post automatically merged: Mar 22, 2020

bump

 

[Xentiss]

bump

 

[Rombadr]

bump

Add field 'comment' to the players table, just like gesior said..

 

[Akirama]

Add samples to DB:

Query:	SELECT id, name, password, premium_ends_at, email, key, create_ip, creation, premium_points, page_access, location, rlname, email_new, email_new_time, email_code, next_email, last_post, flag FROM accounts WHERE name = '1'
SQLSTATE:	42S22
Driver code:	1054
Error message:	Unknown column 'premium_ends_at' in 'field list'

I have this problem , someone can help ?

 

[goo_pile]

just INSERT the field "premium_ends_at" in the accounts table in the sql.
this may cause the server/website to read/write in different fields.
be aware.

 

[absorc]

Hi!
I am having trouble as well.
I am using Gesior

GitHub - gesior/Gesior2012 at TFS-1.5

Gesior 2012 - Account Maker [website] for OTSes, account maker you can find in BRANCHES. Select 'branch'. - GitHub - gesior/Gesior2012 at TFS-1.5

github.com

With the latest version of Uniserver.

This is the info.

Everything is fine up until step 4.
Then it is blank.

I am using TFS1.5
Compiled with Windows 10 64x.

Grateful for guidance!

 

[absorc]

Hi!
I am having trouble as well.
I am using Gesior

GitHub - gesior/Gesior2012 at TFS-1.5

Gesior 2012 - Account Maker [website] for OTSes, account maker you can find in BRANCHES. Select 'branch'. - GitHub - gesior/Gesior2012 at TFS-1.5

github.com

With the latest version of Uniserver.

This is the info.
View attachment 72744
Everything is fine up until step 4.
Then it is blank.
View attachment 72745
I am using TFS1.5
Compiled with Windows 10 64x.

Grateful for guidance!

Switched to xampp. Works there.