Open joelaran13 opened 3 months ago
You have to import the following SQL database to your installed computer. Sorry I didn't include it in the repository. In the database you can add any credentials as login in the user table or use existing credentials to log in to the system. When selecting user type in the user table Admin A (1) is for the Admin panel login And Cashier (4) for cashier login. I hope this resolves your issue.
thanks for the guide, really appreciate it.
On Fri, 7 Jun 2024 at 15:14, Nidula Gunawardana @.***> wrote:
Closed #1 https://github.com/NidulaGunawardana/NShop/issues/1 as completed.
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#event-13076179782, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRFX3QZNPMYWQN555ETZGFMWPAVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJTGA3TMMJXHE3TQMQ . You are receiving this because you authored the thread.Message ID: @.***>
What the name of the database? Is it "nshop" or "Nshop_db" ?
On Fri, 7 Jun 2024 at 14:23, Nidula Gunawardana @.***> wrote:
You have to import the following SQL database to your installed computer. Sorry I didn't include it in the repository. In the database you can add any credentials as login in the user table or use existing credentials to log in to the system. When selecting user type in the user table Admin A (1) is for the Admin panel login And Cashier (4) for cashier login.
Nshop_db.zip https://github.com/user-attachments/files/15712191/Nshop_db.zip
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#issuecomment-2154167151, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRGE743AUPKSPS5W4BLZGFGV7AVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJUGE3DOMJVGE . You are receiving this because you authored the thread.Message ID: @.***>
Yes it is "nshop", Nshop_db is just the exported file name. You just need to execute the sql file it will create the database as well.
i see, i've done that but i can't log in eventho i know the username and the password.
On Fri, 7 Jun 2024 at 16:25, Nidula Gunawardana @.***> wrote:
Yes it is "nshop", Nshop_db is just the exported file name. You just need to execute the sql file it will create the database as well.
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#issuecomment-2154345464, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRD546S3M6SGSU2CJVLZGFVAJAVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJUGM2DKNBWGQ . You are receiving this because you authored the thread.Message ID: @.***>
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
it says this, why is it denied me?
On Fri, 7 Jun 2024 at 16:28, Joel Aran @.***> wrote:
i see, i've done that but i can't log in eventho i know the username and the password.
On Fri, 7 Jun 2024 at 16:25, Nidula Gunawardana @.***> wrote:
Yes it is "nshop", Nshop_db is just the exported file name. You just need to execute the sql file it will create the database as well.
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#issuecomment-2154345464, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRD546S3M6SGSU2CJVLZGFVAJAVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJUGM2DKNBWGQ . You are receiving this because you authored the thread.Message ID: @.***>
This error comes because of the database login details are wrong in your system. you have to enter your database password in the following directory in your project. You have to update the password to your database password in the src/model/MySQL.java File
[image: localhost 127.0.0.1 phpMyAdmin 5.2.1 - Google Chrome 07_06_2024 16_42_31.png]
On Fri, 7 Jun 2024 at 16:35, Nidula Gunawardana @.***> wrote:
This error comes because of the database login details are wrong in your system. you have to enter your database password in the following directory in your project. Screenshot.2024-06-07.140130.png (view on web) https://github.com/NidulaGunawardana/NShop/assets/94860959/a47087e6-3761-495e-88ea-1cf154e043d1 You have to update the password to your database password in the src/model/MySQL.java File
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#issuecomment-2154362547, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRGVEOFHJJSQFS4KY2LZGFWGBAVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJUGM3DENJUG4 . You are receiving this because you authored the thread.Message ID: @.***>
you mean here on the database?
On Fri, 7 Jun 2024 at 16:43, Joel Aran @.***> wrote:
[image: localhost 127.0.0.1 phpMyAdmin 5.2.1 - Google Chrome 07_06_2024 16_42_31.png]
On Fri, 7 Jun 2024 at 16:35, Nidula Gunawardana @.***> wrote:
This error comes because of the database login details are wrong in your system. you have to enter your database password in the following directory in your project. Screenshot.2024-06-07.140130.png (view on web) https://github.com/NidulaGunawardana/NShop/assets/94860959/a47087e6-3761-495e-88ea-1cf154e043d1 You have to update the password to your database password in the src/model/MySQL.java File
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#issuecomment-2154362547, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRGVEOFHJJSQFS4KY2LZGFWGBAVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJUGM3DENJUG4 . You are receiving this because you authored the thread.Message ID: @.***>
it okay i got it
On Fri, 7 Jun 2024 at 16:43, Joel Aran @.***> wrote:
you mean here on the database?
On Fri, 7 Jun 2024 at 16:43, Joel Aran @.***> wrote:
[image: localhost 127.0.0.1 phpMyAdmin 5.2.1 - Google Chrome 07_06_2024 16_42_31.png]
On Fri, 7 Jun 2024 at 16:35, Nidula Gunawardana @.***> wrote:
This error comes because of the database login details are wrong in your system. you have to enter your database password in the following directory in your project. Screenshot.2024-06-07.140130.png (view on web) https://github.com/NidulaGunawardana/NShop/assets/94860959/a47087e6-3761-495e-88ea-1cf154e043d1 You have to update the password to your database password in the src/model/MySQL.java File
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#issuecomment-2154362547, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRGVEOFHJJSQFS4KY2LZGFWGBAVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJUGM3DENJUG4 . You are receiving this because you authored the thread.Message ID: @.***>
Glad to hear that. if any issue let me know.
Hello, good days. i encounter another problems here... Which is the dashboard doesnt appear total sale and etc. it just blank. Got any idea on how to fix it?
On Fri, 7 Jun 2024 at 20:17, Nidula Gunawardana @.***> wrote:
Closed #1 https://github.com/NidulaGunawardana/NShop/issues/1 as completed.
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#event-13079905507, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRGVDSZEGRHBY3JN5SLZGGQF5AVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJTGA3TSOJQGU2TANY . You are receiving this because you authored the thread.Message ID: @.***>
Hello, my dashboard doesn't appear the total sales, etc. It just blank.
On Fri, 7 Jun 2024 at 20:17, Nidula Gunawardana @.***> wrote:
Closed #1 https://github.com/NidulaGunawardana/NShop/issues/1 as completed.
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#event-13079905507, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRGVDSZEGRHBY3JN5SLZGGQF5AVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJTGA3TSOJQGU2TANY . You are receiving this because you authored the thread.Message ID: @.***>
After you do sales it will appear automatically in there, You can sell products in cashiers section then they will appear.
Hello, good day to you. I still have the same problem with the dashboard, it still blank, total blank like there nothing there.
On Sat, 8 Jun 2024 at 11:44, Nidula Gunawardana @.***> wrote:
After you do sales it will appear automatically in there, You can sell products in cashiers section then they will appear.
— Reply to this email directly, view it on GitHub https://github.com/NidulaGunawardana/NShop/issues/1#issuecomment-2155790964, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHRMGRDHMJLSGUQYKMTAVQTZGJ4YJAVCNFSM6AAAAABI6ASXWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJVG44TAOJWGQ . You are receiving this because you authored the thread.Message ID: @.***>
May i know what the login details?