linkace:simple image doesn't work with sqlite, can't create user

[helmut72]

Describe the bug

linkace:simple image doesn't work with sqlite, can't create user:

To Reproduce

I used this docs setup, variables and APP_KEY:
https://www.linkace.org/docs/v1/setup/setup-with-docker/simple/
https://www.linkace.org/docs/v1/setup/setup-with-sqlite/

docker exec -it linkace php artisan migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Migration table created successfully.
Nothing to migrate.

/app # ls -l /app/.env /app/database/linkace.sqlite 
-rw-rw-rw-    1 root     root          2442 Jan 16 11:18 /app/.env
-rw-rw-rw-    1 root     root         12288 Jan 16 11:12 /app/database/linkace.sqlite

Then run:

docker exec -it linkace php artisan registeruser

 Please enter the user name::
 > test

 Please enter the user email address::
 > test@test.com


In Connection.php line 712:
                                                                                                                             
  SQLSTATE[HY000]: General error: 1 no such table: users (SQL: select * from "users" where "email" = test@test.com limit 1)  
                                                                                                                             

In Exception.php line 18:
                                                          
  SQLSTATE[HY000]: General error: 1 no such table: users  
                                                          

In PDOConnection.php line 82:
                                                          
  SQLSTATE[HY000]: General error: 1 no such table: users  
                                                          

Expected behavior

Register first user should work

[Kovah]

Hi, could you please delete the database file and try again?

[helmut72]

Have tried it many times and also used production in APP_ENV=local. Edit: Also tried with APP_URL=https://linkace.mydomain.com. My Reverse Proxy is ready. I just want to try Linkace in my environment, but looks like I need MariaDB or Postgres. Here is my env file:

APP_NAME=LinkAce
COMPOSE_PROJECT_NAME=linkace

APP_URL=http://localhost
APP_ENV=local
APP_KEY=base64:deleted
APP_DEBUG=false
SETUP_COMPLETED=false
SESSION_LIFETIME=10080

BACKUP_ENABLED=false
BACKUP_DISK=s3
BACKUP_NOTIFICATION_EMAIL=your@email.com
BACKUP_MAX_SIZE=512

AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=

MAIL_FROM_ADDRESS=your@email.com
MAIL_FROM_NAME=LinkAce
MAIL_DRIVER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null

DB_CONNECTION=sqlite
DB_DATABASE=/app/database/linkace.sqlite

SESSION_DRIVER=file
LOG_CHANNEL=stack
BROADCAST_DRIVER=log
CACHE_DRIVER=file
QUEUE_DRIVER=database

Edit2: There is only a migration table:

sqlite3 linkace.sqlite 
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.

sqlite> .tables
migrations

[Kovah]

Well, yes please use MySQL or Postgres in the meantime. I will update the documentation to discourage usage of SQlite because it only causes issues at the moment.

[helmut72]

MariaDB works. But want to avoid another DB server just for testing Linkace with a Single User.

[Kovah]

I am closing this issue in favor of #327. Please add any new issues there.