antedebaas / Viesti-Reports

DMARC & SMTP-TLS Reports processor and visualizer and BIMI file hoster
https://docs.viestireports.com/
GNU Affero General Public License v3.0
82 stars 16 forks source link

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'users' doesn't exist #107

Closed mshannaq closed 5 months ago

mshannaq commented 5 months ago

SQLSTATE[42S02] Base table or view not found: 1146 Table 'users'

Describe the bug After installing and running bash update.sh and installservice.sh and goto http://hostname.dev/ it forward me to http://hostname.dev/setup and I entered the values then I see that .env.local created. but then error message "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dmarcdb.users' doesn't exist" appear in web browser.

Are you using the Docker image?

Database used

Error Messages SQLSTATE[42S02]: Base table or view not found: 1146 Table 'users' doesn't exist

Steps to Reproduce Please provide detailed steps to reproduce the problem:

  1. install
  2. goto http://hostname.dev/setup and enter the values
  3. See error

Screenshots image

Environment (please complete the following information):

mshannaq commented 5 months ago

I noticed that as @k04d01 said in https://github.com/antedebaas/DMARC-SMTPTLS-Reports/issues/104

after i have startet /setup in my webbrowser and see the error then run bash update.sh again in console.

I can see databases tables created.

then I return to http://hostname.dev/setup and continue creating the user.

do I think bash update.sh step must be after the http://hostname.dev/setup in instructions.

antedebaas commented 5 months ago

thank you for reporting. there was a bug in the setup script preventing the normal setup flow. this is fixed in 1.14.1.

Please let me know if this solves the issue for you.

antedebaas commented 5 months ago

cloing this as it should be fixed. if not please reopen