[BUG]: Application Doesn't run after converting Database Driver to MariaDB #573
Labels
Status-Fixed
Ticket is resolved.
Status-Not-Enough-Data
Ticket creator must append more precise info to the ticket.
Type-Defect
This is BUG!!!
Milestone
Brief description of the issue
After converting the database driver to MariaDB. Application prompts restart. After that, It doesn't run at all.
How to reproduce the bug?
Goto Data Storage
Select MariaDB as a database driver (input everything required)
Apply and restart it, It will never start again.
You must have fresh database in your MariaDB server.
What was the expected result?
Data Storage feature is truly appealing, it makes you try it.
I tried it but got hit with the bug.
What actually happened?
I switched the database driver to MariaDB > It prompted a restart > on confirming, The application closed and never started.
Then, to revive it back, I had to delete the config.ini file from the config folder.
It started and settings reverted to default (as expected).
All in all, It failed to convert the database to MariaDB.
Other information
Potential Reason
I went through my localhost to PhpMyAdmin. There, I found that it failed to create few of the tables.
Then i used SQL DB browser to browse the Tables schema, I copied the "Create Statement" of Tables. Pasted into sql query in phpmyadmin
Through SQL query, I found a potential problem that could be causing it to fail to create the table.
There is a wrong "
value
" in column named "icon
" in every table that hinder it to create tables.Below is the picture that depicts it:
Operating system and version
The text was updated successfully, but these errors were encountered: