Error connecting to database  [SOLVED]

Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules
Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
Karol3509
Posts: 14
Joined: 07 Aug 2018, 21:55
what is two(2) plus three(3) ?: 5

Re: Error connecting to database  [SOLVED]

Post by Karol3509 » 17 Aug 2018, 19:47

Frustrated. I may not be understanding right (I have Dyslexia and I am NOT computer savvy at all) . . . but attached is what happened when I tried to follow instructions below. I am NOT running "Linus" I have Windows 10. I am not sure if that's the problem or not BUT I have to have Windows 10 for my work so I"m stuck with it. This database is killing my productivity BIG TIME. Needs to work, it worked GREAT for MONTHS, stopped using it a few weeks and now issues! :-( I appreciate the help!
Attachments
Mysqlcheck.jpg
I am trying!
Mysqlcheck.jpg (32.45 KiB) Viewed 70 times

Karol3509
Posts: 14
Joined: 07 Aug 2018, 21:55
what is two(2) plus three(3) ?: 5

Re: Error connecting to database

Post by Karol3509 » 18 Aug 2018, 23:49

OK. . . I tried to isolate the c: prompt and then paste in the command you asked me to and it appears that I don't even have sql on the machine. That's weird since it should come with opencats install instructions. I am complete novice!

I tried something else (see attached) but that wasn't fruitful either.

I am at a loss as to how to repair/restore things so that my database will work. . . I hate to remove it and start over but frankly that is preferred to continued frustration, it is IMPARATIVE that I am able to use a database reliably - the very limited time I have to work needs to be highly productive for this single self-employed home schooling mother of a twice exceptional child, aging grandparents and disabled cousin to care for.

Is there anyone/anywhere else that might be able to help? I am just beside myself upset that this isn't working right. I am worried the data is going to be corrupted - a lot of work has gone into annotating my candidate records . . . I hate to lose that progress by starting completely over.

Any thoughts as to how to resolve the issues? it's having issues almost every request I make, a lot of "refreshing" and a lot of lost efforts. :-(

Thanks for TRYING to help so far, I really DO appreciate it. Just really uncertain. I need a functioning database!
Attachments
anotherTry.jpg
anotherTry.jpg (165.79 KiB) Viewed 70 times

Karol3509
Posts: 14
Joined: 07 Aug 2018, 21:55
what is two(2) plus three(3) ?: 5

Re: Error connecting to database

Post by Karol3509 » 01 Sep 2018, 02:24

STILL having SAME issues. . . any thoughts?? :roll:

User avatar
RussH
Site Admin
Posts: 783
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Error connecting to database

Post by RussH » 04 Sep 2018, 15:16

Hi,

sorry if this is getting very command-line, but the repair function will work if it's split over two lines - so do the same as you did previously, but use the following;

mysqlcheck --check --auto-repair --all-databases
mysqlcheck --optimize --all-databases

..then restart mysql
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

Karol3509
Posts: 14
Joined: 07 Aug 2018, 21:55
what is two(2) plus three(3) ?: 5

Re: Error connecting to database

Post by Karol3509 » 07 Sep 2018, 18:07

For clarity can you please post full instructions? I have done so many different things I am not sure what it means:
-----------------
sorry if this is getting very command-line, but the repair function will work if it's split over two lines - so do the same as you did previously, but use the following;

mysqlcheck --check --auto-repair --all-databases
mysqlcheck --optimize --all-databases

..then restart mysql
-----------------

Karol3509
Posts: 14
Joined: 07 Aug 2018, 21:55
what is two(2) plus three(3) ?: 5

Re: Error connecting to database

Post by Karol3509 » 07 Sep 2018, 18:51

I asked for clarification b/c THIS is what happens when I start to do as requested and it is CONFUSING!
mysql.jpg
mysql.jpg (27.3 KiB) Viewed 52 times

Karol3509
Posts: 14
Joined: 07 Aug 2018, 21:55
what is two(2) plus three(3) ?: 5

Re: Error connecting to database

Post by Karol3509 » 09 Sep 2018, 18:48

I believe I have figured this out!

I was using the WRONG c prompt! ( I wasn't kidding when I said I wasn't computer savvy AND I lost over a month of work due to this error!)
The attachment Starting-repair-.jpg is no longer available
The attachment Starting-repair-.jpg is no longer available
instead of "c prompt" where I needed to be was "shell" inside the open cats stuff. . .THAT would have been GOOD to know.

I do thank you for your help b/c those command lines fixed it once I got them to the right place!

THANKS! :lol:
Attachments
Starting-repair-.jpg
Starting-repair-.jpg (200.7 KiB) Viewed 39 times

Post Reply