Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

[Problem]: Local deployment point to akaunting.com

M.shuaib Imran   ( User )

Commented 4 years ago

I just follow the instructions on git repo and do these tasks

1.Install Composer and Npm
2.Clone the repository: git clone https://github.com/akaunting/akaunting.git
3.Install dependencies: composer install ; npm install ; npm run dev

Install Akaunting:
4.php artisan install --db-name="akaunting" --db-username="root" --db-password="pass" --admin-email="[email protected]" --admin-password="123456"

Create sample data (optional):
5.php artisan sample-data:seed

but facing a problem i.e
When I try to login with credentials gave while installing, login buton stucks and a loading spinner appears on the button which keeps running hours and hours but nothing happened.
NOTE: webpage's bottom bar shows that it is trying hit akaunting.com instead of my local deployment host akaunting.local.

will anyone please help me on this.?

M.shuaib Imran   ( User )

Commented 4 years ago

When I check my logs I got this

[2020-07-02 11:20:42] testing.ERROR: SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from `0il_users` where `email` = [email protected] and `0il_users`.`deleted_at` is null limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from `0il_users` where `email` = [email protected] and `0il_users`.`deleted_at` is null limit 1) at /Users/shuaib/Sites/akaunting/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)

so here the culprit is query that is generated like this

select * from `0il_users` where `email` = [email protected] and `0il_users`.`deleted_at` is null limit 1
it is also giving error in mysql clients. but the correct one is with inverted commas around email value which is successfully working in mysql client i.e
select * from `0il_users` where `email` = '[email protected]' and `0il_users`.`deleted_at` is null limit 1

now will you plz fix it or tell me how to do it in akaunting code, as I'm not a web developer and will face some struggle to make it fix.


M.shuaib Imran   ( User )

Commented 4 years ago

I just restart the mysql server and it starts working. I don't understand what was the cause but it is working. :)

Please login or register to leave a response.

Showing 1 to 3 of 3 discussions