• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC Gesior Not Add samples to DB:

tanii

Empire-war.com
Joined
Jan 16, 2015
Messages
383
Solutions
1
Reaction score
12
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
 
Last edited:
Solution
I think we fixed it on Skype/Discord.

If you have similar problem, you should edit install.php, under (179 line):
PHP:
$SQL = Website::getDBHandle();
Add:
PHP:
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'.
I think we fixed it on Skype/Discord.

If you have similar problem, you should edit install.php, under (179 line):
PHP:
$SQL = Website::getDBHandle();
Add:
PHP:
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'.
 
Solution
I think we fixed it on Skype/Discord.

If you have similar problem, you should edit install.php, under (179 line):
PHP:
$SQL = Website::getDBHandle();
Add:
PHP:
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
 
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:

bump
 
Last edited:
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 ?
 
Hi!
I am having trouble as well.
I am using Gesior
With the latest version of Uniserver.

This is the info.
1673308799580.png
Everything is fine up until step 4.
Then it is blank.
1673308962381.png
I am using TFS1.5
Compiled with Windows 10 64x.

Grateful for guidance!
 
Hi!
I am having trouble as well.
I am using Gesior
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.
 
Back
Top