✅Erro Guild with ID 0 doesn't exist. no Windows funciona normal, mas na minha vps Linux dá esse erro.

[Fabio Leandro 7]

Bom dia. 

Quando abro meu servidor em meu computador pelo Xampp, entro no gesior, e crio guild, ele cria a guild normal sem nenhum problema. 
Daí subi meu servidor pra uma vps da google cloud, e quando vou criar guild, aparece o seguinte erro: 

 

"Guild with ID 0 doesn't exist."

 

Eu estou acordado desde ontem, já mechi no phpmyadmin, mechi nas tabelas de guild, e não consigo resolver o problema. Algém poderia por favor me ajudar? O que me deixa mais intrigado, é que em meu computador funciona perfeito a criação de guilds, mas na vps dá esse erro. 

 

meu config.php: 

<?PHP
# Account Maker Config
$config['site']['serverPath'] = "/var/server/";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'Yurots');
$towns_list[0] = array(1 => 'Yurots', 2 => 'Gamemaster Isle');

$config['site']['outfit_images_url'] = '/outfit.php';
$config['site']['item_images_url'] = '/images/items/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = '/images/flags/';
$config['site']['flag_images_extension'] = '.png';
$config['site']['players_group_id_block'] = 3;
$config['site']['limitDeath'] = 8;
$config['site']['levelVideo'] = 100;

# PAGE: donate.php
$config['site']['usePagseguro'] = true; //true show / false hide
$config['site']['usePaypal'] = true;	//true show / false hide
$config['site']['useDeposit'] = true;	//true show / false hide
$config['site']['useZaypay'] = false;	//true show / false hide
$config['site']['useContenidopago'] = false;	//true show / false hide
$config['site']['useOnebip'] = false;	//true show / false hide

# Pagseguro config By IVENSPONTES
$config['pagSeguro']['email'] = "[email protected]"; //Email Pagseguro
$config['pagSeguro']['token'] = "20501e99-58fd-4789-adce-f49fd13b46ad466b5e044b8887c89683f5c3f099fd153066-0e33-4390-8068-150b80f8de15"; // TOKEN
$config['pagSeguro']['urlRedirect'] = 'http://baiakretro.com/index.php?subtopic=pagconcluido'; //turn off redirect and notifications in pagseguro.com.br
$config['pagSeguro']['urlNotification'] = 'http://baiakretro.com/retpagseguro.php'; //your return location

$config['pagSeguro']['productName'] = 'Premium Points';
$config['pagSeguro']['productValue'] = 1.00; 	// 1.50 = R$ 1,50 etc...
$config['pagSeguro']['doublePoints'] = false; 	## Double points - true is on / false is off

$config['pagSeguro']['host'] = 'baiakretro.com';		## YOUR HOST
$config['pagSeguro']['database'] = 'tibiabaiakserver';	## DATABASE
$config['pagSeguro']['databaseUser'] = 'tibiabaiakserver';	## USER
$config['pagSeguro']['databasePass'] = 'TNogFFEbG3eO6P57';		## PASSWORD

# Create Account Options
$config['site']['one_email'] = true;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = false;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 0;
$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'] = 10;


# Emails Config
$config['site']['send_emails'] = true;
$config['site']['mail_address'] = "[email protected]";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "smtp.xxxxx.com.br";
$config['site']['smtp_port'] = 587;
$config['site']['smtp_auth'] = true;
$config['site']['smtp_user'] = "[email protected]";
$config['site']['smtp_pass'] = "xxx";

# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 0;
/*
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('Quest 100k' => 45109,'Dwarven Armor'=>45271,'Annihilator' => 42229,'Pits of Inferno Quest' => 45235,'Firewalker Boots Quest' => 45276,'Demon Helmet' => 45267,'Promotion Quest' => 45286,'Dwarven Legs Quest' => 45287,'Inquisition Quest' => 45253,'Demon Oak Quest' => 45297,'AURA Quest' => 25950,'Yalahari Quest' => 45259,'Wrath of the Emperor Quest' => 45263,'Canivete Quest' => 45348,'Ring Quest' => 45374,'Weapon Quest' => 45346,'Golden Helmet Quest' => 45353,'Shield Quest' => 45354,'Blessed Shield Quest' => 45357,'Classic Set Quest' =>45501,'Classic Helmet Quest' => 45455,'Classic Boots Quest' => 45456,'Classic Weapon Quest' => 45386);
$config['site']['show_skills_info'] = false;
$config['site']['show_vip_storage'] = 0;

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

# PAGE: guilds.php
$config['site']['guild_need_level'] = 100;
$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;
$config['site']['access_tickers'] = 3;
$config['site']['access_admin_painel'] = 3;
$config['site']['access_staff_painel'] = 3;

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

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

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

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

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

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

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

///Lista de itens Characters
///exemplo
//$config['site']['itensname'] = array(ID DO ITEM => 'DESCRIÇÃO DO ITEM',ID DO ITEM => 'DESCRIÇÃO DO ITEM');
$config['site']['itensname'] = array(
	//vip boots
	12859 => '(Arm: 3, speed +20, +15mp/1sec, +10hp/1sec).<br>It weighs 10.00 oz.<br><br><font color="green"><b><big>Item VIP</big></b></font>',
	//vip helmet
	12861 => '(Arm: 11, speed +5, protection all +3%, +1mp/1sec, +1hp/1sec).<br>It weighs 27.60 oz.<br><br><font color="green"><b><big>Item VIP</big></b></font>',
	//Claw Ring
	12890 => '(Arm:2, club fighting +3, sword fighting +3, axe fighting +3, distance fighting +3, shielding +3, protection all +2%, speed +10).<br>It can only be wielded properly by elite knights and royal paladins.<br>It weighs 10.00 oz.<br>Use this item to gain +3 skill for 15 minutes.<br><br><font color="green"><b><big>Item VIP</big></b></font>',
	//Claw Ring
	12891 => '(Arm:2, club fighting +3, sword fighting +3, axe fighting +3, distance fighting +3, shielding +3, protection all +2%, speed +10).<br>It can only be wielded properly by elite knights and royal paladins.<br>It weighs 10.00 oz.<br>Use this item to gain +3 skill for 15 minutes.<br><br><font color="green"><b><big>Item VIP</big></b></font>',
	//Serpent Ring
	12892 => '(Arm:2, shielding +3, magic level +3, protection all +2%, speed +10).<br>It can only be wielded properly by master sorcerers and elder druids.<br>It weighs 8.00 oz.<br>Use this item to gain +3 magic level for 15 minutes.<br><br><font color="green"><b><big>Item VIP</big></b></font>');
?>

 

[GamerGoiano 109]

Apaga guilds e executa esse sql

Experimenta pra ver se resolve: 
 

CREATE TABLE IF NOT EXISTS `guilds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `ownerid` int(11) NOT NULL,
  `creationdata` int(11) NOT NULL,
  `motd` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `guild_logo` mediumblob,
  `create_ip` int(11) NOT NULL DEFAULT '0',
  `balance` bigint(20) unsigned NOT NULL DEFAULT '0',
  `last_execute_points` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `ownerid` (`ownerid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;

Editado Março 25, 2020 por BrazItzMe (veja o histórico de edições)

[Fabio Leandro 7]

Mano, ja tentei isso, não dá certo, quando coloco isso, a pagina guilds fica toda em branco. 

acho que o buraco é mais embaixo

[Chriistian 30]

Não esquece que linux tem case sensitive, não sei se pode ser mas se no windows funciona

[Fabio Leandro 7]

@Chriistian Consegui resolver o problema, grato. Pode fechar o topico.

[Aback 0]

podia explicar pra gente como resolveu né?

[elielder 9]

Em 26/03/2020 em 18:18, Fabio Leandro disse:

@Chriistian Consegui resolver o problema, grato. Pode fechar o topico.

se possível explica como resolveu, talvez apareça mais gente com o mesmo problema.