?
avatar Dygear
Dygear
3 Mar 2016

Steps to reproduce the issue

git clone https://github.com/joomla/joomla-cms.git
git checkout 3.5-dev
Try the install process.

Expected result

Joomla Installs

Actual result

Once you get to the last page, and click install, this error comes up resulting in the install failing.

```ERROR: relation "#__redirect_links" does not existSQL=CREATE INDEX "#__redirect_links_idx_link_modifed" ON "#__redirect_links" ("modified_date")

ERROR: relation "#__redirect_links" does not existSQL=CREATE INDEX "#__redirect_links_idx_old_url" ON "#__redirect_links" ("old_url")

ERROR: syntax error at or near ")" LINE 13: ) ^SQL=CREATE TABLE "#__redirect_links" ( "id" serial NOT NULL, "old_url" varchar(2048) NOT NULL, "new_url" varchar(2048), "referer" varchar(2048) NOT NULL, "comment" varchar(255) NOT NULL, "hits" bigint DEFAULT 0 NOT NULL, "published" smallint NOT NULL, "created_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, "modified_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, "header" INTEGER DEFAULT 301 NOT NULL, PRIMARY KEY ("id"), )```

System information (as much as possible)

Ubuntu 14.04
nginx 1.9.12
PHP 7.0.3
PostgreSQL 9.5.1

Additional comments

Very much a SQL problem.

avatar Dygear Dygear - open - 3 Mar 2016
avatar richard67
richard67 - comment - 3 Mar 2016

My fault, came with PR #9269

I will see what I can find out, but help by anyone who has experience with PostgreSQL would be very welcome.


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9292.

avatar alikon
alikon - comment - 3 Mar 2016

I will be able to help on this if needed
On 3 Mar 2016 1:06 pm, "Richard Fath" notifications@github.com wrote:

My fault, came with PR #9269
#9269

I will see what I can find out, but help by anyone who has experience with

PostgreSQL would be very welcome.

This comment was created with the J!Tracker Application
https://github.com/joomla/jissues at issues.joomla.org/joomla-cms/9292
https://issues.joomla.org/tracker/joomla-cms/9292.


Reply to this email directly or view it on GitHub
#9292 (comment).

avatar richard67
richard67 - comment - 3 Mar 2016

@alikon I have found the mistake alreaday, silly one. Will make a PR in a minute or two. But thanks for your offer, I come back to it if more problems.

avatar Dygear
Dygear - comment - 3 Mar 2016

I'll follow along, I plan on using PostgreSQL in production at version 9.5.x.

avatar richard67
richard67 - comment - 3 Mar 2016

@Dygear New PR for this issue is #9294 , please test.

@alikon If you wanna help and have time and PostgreSQL test db available: Please test #9294 , too.

avatar Dygear
Dygear - comment - 3 Mar 2016

Just waiting for the CI tests to be done.

avatar richard67
richard67 - comment - 3 Mar 2016

Done now

avatar Dygear
Dygear - comment - 3 Mar 2016

Yep, it's good! Successfully installed using PostgreSQL 9.5.1 on PHP 7.0.3.

avatar brianteeman brianteeman - close - 3 Mar 2016
avatar Dygear Dygear - change - 3 Mar 2016
Status New Closed
Closed_Date 0000-00-00 00:00:00 2016-03-03 13:00:32
Closed_By Dygear
avatar Dygear Dygear - close - 3 Mar 2016
avatar Dygear Dygear - close - 3 Mar 2016
avatar richard67
richard67 - comment - 3 Mar 2016

@Dygear Could you mark your test result as success then at the issue tracker? Just go to https://issues.joomla.org/tracker/joomla-cms/9294, click the "Test this" button at the to left area and then select the test result. Thanks.

avatar Dygear
Dygear - comment - 3 Mar 2016

Done.

avatar brianteeman brianteeman - change - 8 Mar 2016
Labels Added: ?

Add a Comment

Login with GitHub to post a comment