Solved [Gesior aac] Problems with gesior in linux

[uke15]

Hi

Today I installed gesior on my vps and everything was fine, but when i try to create an account i get this error in a blank page:

Failed to create account.

Also if you try to create a guild at first it seem to create it, but when you click on back button you get this error:

The Following Errors Have Occurred:

• Guild with ID 0 doesn't exist.

The thing is that I have the same database and the same gesior folder on my windows pc and I dont have error here.

What could it be?

Thanks in advance

BUMP!

 

[uke15]

Sorry for another bump but i cannot edit my comment :/

I have changed the version of gesior and when i create an account it seems like it was successful created but the thing is that gesior dont connect with phpmyadmin. Its the same case with guilds....

Im using ubuntu and apache2 and phpmyadmin.


To clarify, for example, you can see how is online, managge account(the sample that is created with gesior) ... but you cannot do something that need to update database

 

[strutZ]

did you edit the config.php in gess?

 

[Fencore Team]

If he can login to a sample characters account then config.php is okay, also set debug to true index.php - > find line define('DEBUG_DATABASE', false); change to - > true -> Save ~ ~ ~ Create account - > make a screen of what you get after account has been created.

 

[uke15]

Here you have config.php

Spoiler

<?PHP
# Account Maker Config
$config['site']['serverPath'] = "/home/antonio/exysiau";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'Elexia');
$towns_list[0] = array(1 => 'Intiri');

$config['site']['outfit_images_url'] = 'http://outfit-images.ots.me/outfit.php';
$config['site']['item_images_url'] = 'http://item-images.ots.me/960/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = 'http://flag-images.ots.me/';
$config['site']['flag_images_extension'] = '.png';

# Create Account Options
$config['site']['one_email'] = false;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 999;
$config['site']['send_register_email'] = false;

# Create Character Options
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_towns'][0] = array(1);
$config['site']['max_players_per_account'] = 7;


# Emails Config
$config['site']['send_emails'] = false;
$config['site']['mail_address'] = "[email protected]";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "mail.gmx.com";
$config['site']['smtp_port'] = 25;
$config['site']['smtp_auth'] = false;
$config['site']['smtp_user'] = "[email protected]";
$config['site']['smtp_pass'] = "xxxx";

# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 1;
/*
Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature.
To use this feature you must register on 'private-servlist.com' and add your server.
Format: number, 0 [disable] or higher
*/

# PAGE: characters.php
$config['site']['quests'] = array();
$config['site']['show_skills_info'] = true;
$config['site']['show_vip_storage'] = 0;

# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['generate_new_reckey'] = false;
$config['site']['generate_new_reckey_price'] = 500;

# PAGE: guilds.php
$config['site']['guild_need_level'] = 15;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;

# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;

# PAGE: latestnews.php
$config['site']['news_limit'] = 6;

# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;

# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6);

# PAGE: highscores.php
$config['site']['groups_hidden'] = array(4, 5, 6);
$config['site']['accounts_hidden'] = array(1);

# PAGE: shopsystem.php
$config['site']['shop_system'] = false;

# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;

# Layout Config
$config['site']['layout'] = 'tibiacom';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = false;
$config['site']['serverinfo_page'] = true;

And this is the code of the debug mode

Query: SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = 'TFSTEST'
SQLSTATE: 00000
Driver code:
Error message:
Query: INSERT INTO `accounts` (`name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag`) VALUES ('TFSTEST', 'f3fcbb98aaae8192dd0e22111b90bd383b450f6e', '999', '1472827411', '[email protected]', '', '1', '3232235817', '1472827411', '', '', '', '', '', '', '', '', '', 'unknown')
SQLSTATE: 22003
Driver code: 1264
Error message: Out of range value for column 'create_ip' at row 1

Thanks for the replys

 

[Fencore Team]

In phpMyAdmin go to -> accounts - > Structure TAB - > find create_ip row - > edit - > Change Type to VARCHAR -> SAVE

I guess after youll fix that youll have another column out of range. So then you do the same thing with the next thing you will get an error with .

 

[uke15]

Thank you very much!!! I dont know how to thank you... i was going crazy


Solved!