GESIOR ACC HTTP ERROR 500

[zapo]

Hi, I installed your website on the server and I'm having this problem. As I create an account or try to log in, an http error 500 error pops up.

It seems to me that this is due to problems with the database, because when creating an account, when he gives a player's name, it does not automatically check if the name is already in the database.

I would be very grateful for your help.

Let me add that I use an OVH vps server

Config.lua

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "admin"
mysqlPass = "****!"
mysqlDatabase = "ots"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"

Config.php

<?PHP
# Account Maker Config
$config['site']['serverPath'] = "/home/ots/";
$config['site']['server_name'] = 'Forgotten';
$towns_list = array(2 => 'Thais', 1 => 'Venore', 4 => 'Carlin');

$config['site']['outfit_images_url'] = '[URL='http://outfit-images.ots.me/outfit.php%27;']Tibia Outfit Images Generator hosted by OTS.ME (http://outfit-images.ots.me/outfit.php';)[/URL]
$config['site']['item_images_url'] = '[URL='http://item-images.ots.me/960/%27;']http://item-images.ots.me/960/';[/URL]
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = '[URL='http://flag-images.ots.me/%27;']http://flag-images.ots.me/';[/URL]
$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;
$config['site']['select_flag'] = true;

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

# Emails Config
$config['site']['send_emails'] = false;
$config['site']['mail_address'] = "[EMAIL][email protected][/EMAIL]";
$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][email protected][/EMAIL]";
$config['site']['smtp_pass'] = "xxxx";

# 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();
$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'] = true;

# 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;

 

[ROKI721]

You have all chmods?
chmod -R 755 /var/www
chown -R x /var/www <- where 'x' your user of apache.

URL="ur domain" on end config.lua.

 

[wick3dr0se]

The chown -R command will vary depending on his setting in Apache. It'll either be www-data:www-data for user and group or <user>:<user>. Obviously /var/www is your web directory. So if you've changed that, you should know . Mine's located in /srv/http because I'm on Arch Linux

However it should be a 404 error if it was a permission issue, but I unfamiliarized myself with Apache purposefully!

 

[zapo]

I set chmod 777 for all folders
My web folder is in /var/www/html/

Maybe is something with apache because when i try reset apache2 use „sudo service apache2 reload/restart” error pops up about not turned on. When I try to enable it I get an error that port 80 is already used probably by nginx. Maybe than is a problem but i cant fix it.

 

[ROKI721]

You have apache and nginx? why?
You can check if nginx is on,

sudo systemctl status nginx

Nginx have apache services but isnt apache.
When u use from nginx then ur apache is disable and when apache is on then nginx is off.

 

[zapo]

I don't know much about these things, I don't have access to a computer now, so I won't check. So this could be the solution

 

[alisonrenna]

I use nignx and I have the same error

 

[lennonpcwb]

Hey there i received the same error here any options to solved that?

The error in my apache2 log is

[29/May/2021:18:24:21 -0700] "GET / HTTP/1.1" 500 295 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36"