Working Database cannot be detected
uniCenta oPOS - dynamically evolving POS project
Brought to you by:
unicenta-hugh
Menu
▾
▴
Hello. Newbie here. Hi!
I have just downloaded uniCenta oPOS. I have the latest Java and MySQL installed. I installe uniCenta and followed all of the instructions and completed the configuration. My 'test' connection to the database was successful. Now I cannot go any further. When I open uniCenta, I get several error messages. The first says, "A working database cannot be detected", followed by "WRN_00_0000 Warning Creation Script did not run successfully", followed by "NOT_00_0000 Notice: Cannot Close Cash". It then brings up the configuration dialog box again. I can't get past this. Please help. Thank you.
Also having that same error as yours any solution yet
What java, mysql and unicenta versions are you using?
Also having that same error as yours any solution yet
We've resolved this issue 4.6.4 - please take a look here
https://unicenta.atlassian.net/browse/UOCL-212
Test Database Connection has changed your database name. Go back into Configuration and put proper database name back. Assume database name is unicentaopos. Do not test connection, just save, exit and restart unicenta.
Thank you so much for replying RickyO. I tried what you suggested but unfortunately, I'm still getting the same error messages.
When I click on info on the error messages, I get this repeated lots of times:
com.openbravo.basic.BasicException:
java.sql.SQLException: No database selected
Last edit: Ellie C 2018-09-15
If the database was not created, go to Windows Start (lower left button)...
All Programs > MySQL > MySQL Server 5.7 > MySQL 5.7 Command Line Client
enter database Password, then at mysql prompt type...
create database unicentaopos ;
Response should be "OK". Close the window.
Start the configuration. Make sure Username and Password are correct.
For the Database put "unicentaopos". DO NOT TEST CONNECTION as it will reset database.
Save. Restart uniCenta POS.
Thank you RickyO. I tried this aswell but still getting the same error messages.
Is it something to do with Java?
I uninstalled unicenta and reinstalled it again from scrath but it's still giving me the same error messages, the configure pages are still set up as I had them before so it's getting the info from somewhere but just not all of it.
Did you install MySQL 5.7 or some other Not Supported version?