Log in Get Started Login with Google

Forum

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

All Discussions

Dedicated Support Collaboration Hub

Table or view not found

Keno ( User )

Commented 5 years ago

I’m trying to install Akaunting on my own server, using the Git master branch and MySQL as the database. After entering the credentials for my database (called book) and the admin, I got the following error:

QueryException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'book.ak_companies' doesn't exist (SQL: insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (, 2019-02-04 09:38:45, 2019-02-04 09:38:45))

Listing all the tables in the database, I got indeed no `ak_companies` table:

+------------------------+
| Tables_in_book         |
+------------------------+
| snz_accounts           |
| snz_bill_histories     |
| snz_bill_item_taxes    |
| snz_bill_items         |
| snz_bill_payments      |
| snz_bill_statuses      |
| snz_bill_totals        |
| snz_bills              |
| snz_categories         |
| snz_companies          |
| snz_currencies         |
| snz_customers          |
| snz_failed_jobs        |
| snz_invoice_histories |
| snz_invoice_item_taxes |
| snz_invoice_items      |
| snz_invoice_payments   |
| snz_invoice_statuses   |
| snz_invoice_totals     |
| snz_invoices           |
| snz_items              |
| snz_jobs               |
| snz_media              |
| snz_mediables          |
| snz_migrations         |
| snz_module_histories   |
| snz_modules            |
| snz_notifications      |
| snz_password_resets    |
| snz_payments           |
| snz_permissions        |
| snz_reconciliations    |
| snz_recurring          |
| snz_revenues           |
| snz_role_permissions   |
| snz_roles              |
| snz_sessions           |
| snz_settings           |
| snz_taxes              |
| snz_transfers          |
| snz_user_companies     |
| snz_user_permissions   |
| snz_user_roles         |
| snz_users              |
| snz_vendors            |
+------------------------+

What is the problem here?

<p>I’m trying to install Akaunting on my own server, using the Git master branch and MySQL as the database. After entering the credentials for my database (called book) and the admin, I got the following error:</p><br />
<p style="padding-left: 30px;">QueryException<br /><br />SQLSTATE[42S02]: Base table or view not found: 1146 Table 'book.ak_companies' doesn't exist (SQL: insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (, 2019-02-04 09:38:45, 2019-02-04 09:38:45))</p><br />
<p>Listing all the tables in the database, I got indeed no `ak_companies` table:</p><br />
<p style="padding-left: 30px;">+------------------------+<br />| Tables_in_book         |<br />+------------------------+<br />| snz_accounts           |<br />| snz_bill_histories     |<br />| snz_bill_item_taxes    |<br />| snz_bill_items         |<br />| snz_bill_payments      |<br />| snz_bill_statuses      |<br />| snz_bill_totals        |<br />| snz_bills              |<br />| snz_categories         |<br />| snz_companies          |<br />| snz_currencies         |<br />| snz_customers          |<br />| snz_failed_jobs        |<br />| snz_invoice_histories  |<br />| snz_invoice_item_taxes |<br />| snz_invoice_items      |<br />| snz_invoice_payments   |<br />| snz_invoice_statuses   |<br />| snz_invoice_totals     |<br />| snz_invoices           |<br />| snz_items              |<br />| snz_jobs               |<br />| snz_media              |<br />| snz_mediables          |<br />| snz_migrations         |<br />| snz_module_histories   |<br />| snz_modules            |<br />| snz_notifications      |<br />| snz_password_resets    |<br />| snz_payments           |<br />| snz_permissions        |<br />| snz_reconciliations    |<br />| snz_recurring          |<br />| snz_revenues           |<br />| snz_role_permissions   |<br />| snz_roles              |<br />| snz_sessions           |<br />| snz_settings           |<br />| snz_taxes              |<br />| snz_transfers          |<br />| snz_user_companies     |<br />| snz_user_permissions   |<br />| snz_user_roles         |<br />| snz_users              |<br />| snz_vendors            |<br />+------------------------+</p><br />
<p>What is the problem here?</p>

Denis Dulici ( Admin )

Commented 5 years ago

You should following the installation instructions:

https://akaunting.com/docs/installation

Keno ( User )

Commented 5 years ago

I did. The error occured after step 3 of the instructions.

Keno ( User )

Commented 5 years ago

Now I’ve tried the released version instead of installing everything by myself using the master on GitHub. It’s working!

Ezdokan ( User )

Commented 4 years ago

prefixe tables name in .env

Please login or register to leave a response.

Showing 1 to 5 of 5 discussions