Database wont update

[Tarien]

I have set up my server and it works fine, people can join, doesn't crash. However I can't edit accounts/players. When I create a character or account, it never shows up in my database. After looking through the forums, a few people said I needed to change my sqltype from 'sqlite' to 'mysql'; I tried this, it doesn't change anything although my server crashes when it tries to load items as it's starting up if I make this change.

I can edit the account manager freely and I've even manually created accounts and players in phpmyadmit, however they never show up in game, the accounts I create just get me "account name invalid". Does anyone have any insight into what I could do?

Any reply would be greatly appreciated, Thanks.

Sorry if any of this was unclear, I'm new to this.

 

[Limos]

If you use MySQL, make sure you set it up correctly, with SQLite you don't have to setup anything and you have edit the database with SQLite manager/studio/expert.
You can follow this tutorial to see if you did the MySQL setup correct.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

The crash at items when you use MySQL instead of SQLite is probable caused by your libmysql.dll, so you can try a different one.
http://www.speedy*****malware.localhost/2xZRC/libmysql.dll