Debug on server

[Tibia Rox]

Whenever I try to log into my server, my client debugs after I enter in my account name and password. Here is the error:

https://gyazo.com/e1294a73a0106c36fee5f8b81dc49bf9

I'm using client 10.77

 

[Itutorial]

Have you made your character a god yet? or...Did you set the temple positions right and put the right values into your website and config.lua?

 

[Tibia Rox]

I couldn't get the website to create a character successfully, so I imported an account and player from a different ot that I know worked on another client. I edited the position on the character so it would spawn in the temple.

 

[Itutorial]

I would say first you need to get your website working then try to fix the debug problem, if it doesn't fix already.

 

[Tibia Rox]

Is there any way I can get on my server without having to set up all of this unnecessary stuff? I'm just trying to get on this server to see my mapping, I'm not trying to set up an entire server.

 

[Itutorial]

Can you post your schemas.sql

 

[Limos]

The debug seems to be caused by a textmessage (probable in a login creaturescript like login.lua), do you use the default datapack?

 

[Tibia Rox]

http://pastebin.com/zyD0EKRC

And yes, I use the default login lua.

 

[Limos]

What about other scripts like an other login creaturescript or other libs like global.lua?

 

[Itutorial]

Reupload your schema into your database then run these sql commands:

First: make sure you edit -accountname -accountpassword

INSERT INTO `accounts` (`name`, `password`, `email`) VALUES ('accountname', 'accountpassword', 'email');

Second:

INSERT INTO `players` (`name`, `account_id`, `vocation`, `town_id`, `sex`, `lastip`) VALUES ('Admin', 1, 1, 1, 1, 0);

 

[Tibia Rox]

The only scripts I've edited are npcs and chat channels

 

[Itutorial]

Probably a problem with chat channels then...

 

[Limos]

You can try to disable any login creaturescript (like remove or comment out the xml entry) to see if you still get the debug.
It should be caused by a script that runs at the moment you login.

 

[Itutorial]

Limos he could of also messed up his channels so when it loads one of them it debugs the player. I think this is the case seems he says he hasn't edited any of his creaturescripts. It is very easy to make your server crash messing with chat channels...It says right on the page dont mess with this unless you know what you doing.

 

[Tibia Rox]

I downloaded a default version of chat channels, still debugs. I've commented out my xml files in creature scripts and still debugs.

 

[Itutorial]

I could help you on teamviewer if u trust me

 

[Limos]

Limos he could of also messed up his channels so when it loads one of them it debugs the player. I think this is the case seems he says he hasn't edited any of his creaturescripts. It is very easy to make your server crash messing with chat channels...It says right on the page dont mess with this unless you know what you doing.

Also a not edited login script can cause a debug if the message type enum is overwritten somewhere.

 

[Tibia Rox]

Reupload your schema into your database then run these sql commands:

First: make sure you edit -accountname -accountpassword

INSERT INTO `accounts` (`name`, `password`, `email`) VALUES ('accountname', 'accountpassword', 'email');

Second:

INSERT INTO `players` (`name`, `account_id`, `vocation`, `town_id`, `sex`, `lastip`) VALUES ('Admin', 1, 1, 1, 1, 0);

I just tried doing this, and when I try to enter in the second line, it says Field 'conditions' doesnt have a default value

 

[Itutorial]

INSERT INTO `players` (`name`, `account_id`, `vocation`, `town_id`, `sex`, `lastip`, `conditions`) VALUES ('Admin', 1, 1, 1, 1, 0, '');

 

[Tibia Rox]

Still debugging after all that.

Here is the most recent error report, maybe it changed:
https://gyazo.com/c39e0d529252fd139744ae77490218ad

Also, when I try and create an account on the website, it creates the account but produces this error:
https://gyazo.com/5b1d97311ab2e56d2339c5b5c7aefb4d

Also, when I try and log into the account I just created on the website, I get this error:
https://gyazo.com/389d8277cdd432edd1a06b1654909ca6