Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG]: Application Doesn't run after converting Database Driver to MariaDB #573

Closed
Starboy-Xo opened this issue Jan 8, 2022 · 4 comments
Assignees
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

Comments

@Starboy-Xo
Copy link

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:
image

Operating system and version

  • OS: Windows 11
  • RSS Guard version: 4.0.4
@Starboy-Xo Starboy-Xo added the Type-Defect This is BUG!!! label Jan 8, 2022
@martinrotter
Copy link
Owner

martinrotter commented Jan 8, 2022

will check, those special strings are just placeholders which are meant to get replaced before the sql statement is sent to server

posting the actual debug log of app would help

@martinrotter martinrotter added the Status-Not-Enough-Data Ticket creator must append more precise info to the ticket. label Jan 8, 2022
@Starboy-Xo
Copy link
Author

Starboy-Xo commented Jan 8, 2022

posting the actual debug log of app would help

Where is it located?

@martinrotter
Copy link
Owner

OK, should be fixed, i found the issue.

daa889e

@martinrotter martinrotter added the Status-Fixed Ticket is resolved. label Jan 9, 2022
@martinrotter martinrotter added this to the 4.2.0 milestone Jan 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
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!!!
Projects
None yet
Development

No branches or pull requests

2 participants