Creating tables for database does not match case

stoneharry / WoW-Spell-Editor

A Spell Editor for WoW versions WOTLK 3.3.5, TBC 2.4.3, or Vanilla 1.12.1.

260 stars 119 forks source link

Creating tables for database does not match case #119

Closed ph1lt0r closed 2 years ago

ph1lt0r commented 4 years ago

Spell editor version 3.3.5A 12340

Describe the bug Creating a database the spells table is created as Spells, but the client on windows 10 looks for (dbname).test

To Reproduce Steps to reproduce the behavior:

create the database and tables from a windows 10 client on a mysql database on a remote linux server

Expected behavior The attached screenshot should not happen.

Capture

stoneharry commented 4 years ago

I guess you can workaround by using a database called test?

I'm not sure what could be causing this without some research. It could be your user does not have permissions to create/use the database.

Sanavesa commented 4 years ago

Unfortunately I saw this after I made my bug issue on the same topic here. Nevertheless, I added more detail and a way to fix this issue. A temporary solution would be to go in your SQL DB and rename Spell to spell, and it would work correctly.

stoneharry commented 2 years ago

Should finally be fixed in v2.0.3.