Unable to install or upgrade master (SQL migrations?)

Question

Unable to install or upgrade master (SQL migrations?)

ZaneA opened this issue 11 years ago · 12 comments

Hopefully I'm just missing something, I'm unable to get master (i.e. 4.3.x) running locally, it looks like there is some problem with the SQL migrations, I have tried installing into an empty database, as well as upgrading from a 4.2.2 database, and both fail in a similar way.

Logs (log/install.log and log/upgrade.log):

I also tried merging the patches in #702 and #703 but this didn't change much.

Any advice would be great, thanks!

Answer 1 · 2014-06-04T16:19:27.000Z

what error you have on clean master install?

Answer 2 · 2014-06-04T16:23:27.000Z

for now master installation is not finished but i would be happy to help you.

Answer 3 · 2014-06-04T21:23:39.000Z

Thanks, the error that was shown was:

[2014-06-04 16:11:39] myapp.CRITICAL: RuntimeException:
[Doctrine\DBAL\DBALException]
An exception occurred while executing 'SELECT t0.Id AS Id1, t0.Name AS Name2, t0.Details AS Details3, t0.type AS type4, t0.installed_with AS installed_with5, t0.Description AS Description6, t0.Version AS Version7, t0.author AS author8, t0.license AS license9, t0.Enabled AS Enabled10, t0.installed_at AS installed_at11, t0.updated_at AS updated_at12 FROM Plugins t0': SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.Id' in 'field list'
[PDOException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.Id' in 'field list'
cache:clear [--no-warmup] [--no-optional-warmers]  (uncaught exception) at /vagrant/newscoop/library/Newscoop/Installer/Services/DemositeService.php line 67 {"exception":"[object] (RuntimeException:
[Doctrine\\DBAL\\DBALException]
An exception occurred while executing 'SELECT t0.Id AS Id1, t0.Name AS Name2, t0.Details AS Details3, t0.type AS type4, t0.installed_with AS installed_with5, t0.Description AS Description6, t0.Version AS Version7, t0.author AS author8, t0.license AS license9, t0.Enabled AS Enabled10, t0.installed_at AS installed_at11, t0.updated_at AS updated_at12 FROM Plugins t0':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.Id' in 'field list'
[PDOException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.Id' in 'field list'
cache:clear [--no-warmup] [--no-optional-warmers]\n\n\n at /vagrant/newscoop/library/Newscoop/Installer/Services/DemositeService.php:67)"} []

Here is a screenshot:

Answer 4 · 2014-06-04T21:25:06.000Z

looks like our bug in demo tables - i will check it tomorrow morning! thanks!

Answer 5 · 2014-06-04T21:30:30.000Z

Thanks Paweł, much appreciated!

Answer 6 · 2014-06-06T06:56:54.000Z

sorry - i need some more time.

Answer 7 · 2014-06-06T07:07:57.000Z

No problem, thanks for the update :)

Answer 8 · 2014-06-30T12:25:01.000Z

I taked some time ;/ sorry for that - we've ben bussy making performance fixes. Installer is back on table - https://dev.sourcefabric.org/browse/CS-5445.

Answer 9 · 2014-07-02T15:20:45.000Z

@ZaneA if you are still there then you can try install latest master from @takeit master branch.

git pull https://github.com/takeit/Newscoop.git master

Answer 10 · 2014-07-03T00:23:46.000Z

Thanks Paweł, we ended up using Newscoop 4.2.x for now but I will try this again soon and let you know how I get on.

Answer 11 · 2014-07-10T11:27:44.000Z

@ZaneA if you will find a minute to test 4.3 (lot's of new stuff) then please use this branch: #744 (or if it will be merged already - latest master).

We simplified installer a lot, and lot's of things is changed from 4.2 (+ performance).

Answer 12 · 2014-07-10T23:48:32.000Z

Looks good! Will try to test this weekend for you :)