New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to install Cachet v2.3.10 #2272

Closed
h3ct0rjs opened this Issue Dec 19, 2016 · 12 comments

Comments

4 participants
@h3ct0rjs

h3ct0rjs commented Dec 19, 2016

Hi Everybody,

I was trying to install this app; until version v2.2.2 it was working like a charm, but due to some changes in our infrastructure we were updating old services like our status page we're using v2.3.10 and the procedure used to install the app was the same founded here, our .env file contains the following configuration:

APP_ENV=production
APP_DEBUG=false
APP_URL=http://status.sample.co
APP_KEY=ourkeyhere
DB_DRIVER=sqlite
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
CACHET_EMOJI=false
MAIL_DRIVER=smtp
MAIL_HOST=null
MAIL_PORT=null
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ADDRESS=null
MAIL_NAME=null
MAIL_ENCRYPTION=tls
REDIS_HOST=null
REDIS_DATABASE=null
REDIS_PORT=null
GITHUB_TOKEN=null

after checking all the configuration in our box we couldn't find whats the problem, seems something like a dependency reference error,
alt text

Is there any solution to this ?

@phy25

This comment has been minimized.

Show comment
Hide comment
@phy25

phy25 Dec 19, 2016

Seems like duplicate as #1997. For me using SQLite and PHP 7.0 Windows, under 2.3.10 / 2.4.0-dev, installing db fails.

>php artisan app:install
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 17 database schema has changed (SQL: create
table "cachet_component_groups" ("id" integer not null primary key autoinc
rement, "name" varchar not null, "created_at" datetime null, "updated_at" d
atetime null))
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000]: General error: 17 database schema has changed
[PDOException]
SQLSTATE[HY000]: General error: 17 database schema has changed

>php artisan migrate
[Doctrine\DBAL\Schema\SchemaException]
There is no column with name 'user_id' on table 'components'.`

phy25 commented Dec 19, 2016

Seems like duplicate as #1997. For me using SQLite and PHP 7.0 Windows, under 2.3.10 / 2.4.0-dev, installing db fails.

>php artisan app:install
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 17 database schema has changed (SQL: create
table "cachet_component_groups" ("id" integer not null primary key autoinc
rement, "name" varchar not null, "created_at" datetime null, "updated_at" d
atetime null))
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000]: General error: 17 database schema has changed
[PDOException]
SQLSTATE[HY000]: General error: 17 database schema has changed

>php artisan migrate
[Doctrine\DBAL\Schema\SchemaException]
There is no column with name 'user_id' on table 'components'.`

@h3ct0rjs

This comment has been minimized.

Show comment
Hide comment
@h3ct0rjs

h3ct0rjs Dec 20, 2016

I was checking #1997 @phy25 but if I just run php artisan migrate I get the same error. I was testing the same exact steps to install v2.2.2 and it works, but with this new version even if I try to update didn't work.

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

yes
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1 table "component_groups" already exists (
SQL: create table "component_groups" ("id" integer not null primary key aut
oincrement, "name" varchar not null, "created_at" datetime null, "updated_a
t" datetime null))

[PDOException]
SQLSTATE[HY000]: General error: 1 table "component_groups" already exists

h3ct0rjs commented Dec 20, 2016

I was checking #1997 @phy25 but if I just run php artisan migrate I get the same error. I was testing the same exact steps to install v2.2.2 and it works, but with this new version even if I try to update didn't work.

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

yes
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1 table "component_groups" already exists (
SQL: create table "component_groups" ("id" integer not null primary key aut
oincrement, "name" varchar not null, "created_at" datetime null, "updated_a
t" datetime null))

[PDOException]
SQLSTATE[HY000]: General error: 1 table "component_groups" already exists

@GrahamCampbell

This comment has been minimized.

Show comment
Hide comment
@GrahamCampbell

GrahamCampbell Dec 20, 2016

Member

SQLite is unfortunately a bit rubbish. Please try with a real database. :)

Member

GrahamCampbell commented Dec 20, 2016

SQLite is unfortunately a bit rubbish. Please try with a real database. :)

@h3ct0rjs

This comment has been minimized.

Show comment
Hide comment
@h3ct0rjs

h3ct0rjs Dec 20, 2016

We were thinking to move to postgres, can you @GrahamCampbell confirm if this .env is correct asuming that we're goint to use postgres :

APP_ENV=production
APP_DEBUG=false
APP_URL=http://status.sample.com
APP_KEY=
DB_DRIVER=postgres
DB_HOST=localhost
DB_DATABASE=cachetdb
DB_USERNAME=cachet
DB_PASSWORD=secret
DB_PORT=null
DB_PREFIX=null
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
CACHET_BEACON=true
CACHET_EMOJI=false
MAIL_DRIVER=log
MAIL_HOST=null
MAIL_PORT=null
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ADDRESS=null
MAIL_NAME=null
MAIL_ENCRYPTION=tls
REDIS_HOST=null
REDIS_DATABASE=null
REDIS_PORT=null
GITHUB_TOKEN=null

h3ct0rjs commented Dec 20, 2016

We were thinking to move to postgres, can you @GrahamCampbell confirm if this .env is correct asuming that we're goint to use postgres :

APP_ENV=production
APP_DEBUG=false
APP_URL=http://status.sample.com
APP_KEY=
DB_DRIVER=postgres
DB_HOST=localhost
DB_DATABASE=cachetdb
DB_USERNAME=cachet
DB_PASSWORD=secret
DB_PORT=null
DB_PREFIX=null
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
CACHET_BEACON=true
CACHET_EMOJI=false
MAIL_DRIVER=log
MAIL_HOST=null
MAIL_PORT=null
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ADDRESS=null
MAIL_NAME=null
MAIL_ENCRYPTION=tls
REDIS_HOST=null
REDIS_DATABASE=null
REDIS_PORT=null
GITHUB_TOKEN=null

@GrahamCampbell

This comment has been minimized.

Show comment
Hide comment
@GrahamCampbell

GrahamCampbell Dec 20, 2016

Member

No, the driver name is pgsql. :)

Member

GrahamCampbell commented Dec 20, 2016

No, the driver name is pgsql. :)

@GrahamCampbell

This comment has been minimized.

Show comment
Hide comment
@h3ct0rjs

This comment has been minimized.

Show comment
Hide comment
@h3ct0rjs

h3ct0rjs Dec 20, 2016

Thank you @GrahamCampbell After checking seems that the best option is move to another database.
I'm closing this.

h3ct0rjs commented Dec 20, 2016

Thank you @GrahamCampbell After checking seems that the best option is move to another database.
I'm closing this.

@h3ct0rjs h3ct0rjs closed this Dec 20, 2016

@phy25

This comment has been minimized.

Show comment
Hide comment
@phy25

phy25 Dec 20, 2016

Maybe we can print a warning message to console when installing with SQLite? I used that because the docs mentioned SQLite.

phy25 commented Dec 20, 2016

Maybe we can print a warning message to console when installing with SQLite? I used that because the docs mentioned SQLite.

@jbrooksuk

This comment has been minimized.

Show comment
Hide comment
@jbrooksuk

jbrooksuk Dec 20, 2016

Member

Cachet should install with SQLite since that's what we use when running the tests. I don't know what had happened to @heticor915's database by the point he went to upgrade, did you do any manual modifications?

Member

jbrooksuk commented Dec 20, 2016

Cachet should install with SQLite since that's what we use when running the tests. I don't know what had happened to @heticor915's database by the point he went to upgrade, did you do any manual modifications?

@h3ct0rjs

This comment has been minimized.

Show comment
Hide comment
@h3ct0rjs

h3ct0rjs Dec 20, 2016

@jbrooksuk No, the .env file is the same mentioned before, I was thinking to mention the part of the drivers and what's the best alternative in cachet in the official documentation

h3ct0rjs commented Dec 20, 2016

@jbrooksuk No, the .env file is the same mentioned before, I was thinking to mention the part of the drivers and what's the best alternative in cachet in the official documentation

@jbrooksuk

This comment has been minimized.

Show comment
Hide comment
@jbrooksuk

jbrooksuk Dec 22, 2016

Member

Postgres or MySQL 👍

Member

jbrooksuk commented Dec 22, 2016

Postgres or MySQL 👍

@h3ct0rjs

This comment has been minimized.

Show comment
Hide comment
@h3ct0rjs

h3ct0rjs Dec 23, 2016

postgres, and change the version in the documentation from v2.1.0 to the most stable version(v2.3.9). I would like to say Thank you because the site is up and running after a long fight 😄

h3ct0rjs commented Dec 23, 2016

postgres, and change the version in the documentation from v2.1.0 to the most stable version(v2.3.9). I would like to say Thank you because the site is up and running after a long fight 😄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment