jonwsoto
commented
1 year ago you can use phpmyadmin and modify the values yourself here is the two lines from the server.sh that tell you what you need to modify
`$DOCKER_COMPOSE_COMMAND exec db sh -c "MYSQL_PWD=\$MYSQL_ROOT_PASSWORD mysql \$MYSQL_DATABASE -e \ 'INSERT INTO user_roles (role_uuid , user_uuid) VALUES ((SELECT uuid FROM roles WHERE name=\"PRO_USER\" ORDER BY version DESC limit 1) ,(SELECT uuid FROM users WHERE email=\"$EMAIL\")) ON DUPLICATE KEY UPDATE role_uuid = VALUES(role_uuid);' \ "
$DOCKER_COMPOSE_COMMAND exec db sh -c "MYSQL_PWD=\$MYSQL_ROOT_PASSWORD mysql \$MYSQL_DATABASE -e \ 'INSERT INTO user_subscriptions SET uuid=UUID(), plan_name=\"PRO_PLAN\", ends_at=8640000000000000, created_at=0, updated_at=0, user_uuid=(SELECT uuid FROM users WHERE email=\"$EMAIL\"), subscription_id=1, subscription_type=\"regular\";' \ "`
koopernick
mehdiMj-ir
antonheitz
Describe the bug Running the command
./server.sh create-subscription EMAIL@ADDRdoesn't work. It gives the following error../server.sh: 85: [[: not foundI am using Ubuntu 22.04.
To Reproduce Steps to reproduce the behavior: Run the command
./server.sh create-subscription EMAIL@ADDRExpected behavior The subscription for the email account should be activated.
Additional context I have realized that the solution is either to run the command as
bash ./server.sh create-subscription EMAIL@ADDRor change the first line of the file from#!/bin/shto#!/bin/bashThis should be explained in the docs or a solution should be implemented that works across all Linux distributions and shells.