I get these errors when I enable the versioncontrol_git module...

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "(" LINE 5: repo_id int(11) NOT NULL, ^ in /home/rmh3093/public_html/includes/database.pgsql.inc on line 125.
* user warning: query: CREATE TABLE versioncontrol_git_latest_commits ( lastest_commits_id int NOT NULL, branch_id int NOT NULL, revision varchar(255) NOT NULL, repo_id int(11) NOT NULL, PRIMARY KEY (lastest_commits_id) ) in /home/rmh3093/public_html/includes/database.pgsql.inc on line 144.

Comments

jpetso’s picture

jpetso commented

I guess that's the "(11)" after the "int" type specification. Please uninstall the module, remove the "(11)" and try installing it again.

rmh3093’s picture

rmh3093 commented

yeah I've done that... and that does allow for the module to enable properly, but I still get other sql errors

boombatower’s picture

boombatower commented
Status: Active » Postponed (maintainer needs more info)

I don't have a postgress setup to test code on. If you can give me details on what errors you can I can try to fix them.

I have been rather busy and apologize for the lag in response.

boombatower’s picture

boombatower commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

Appears to be issue with creating table schema...this will be fixed in #303680: Port to 6.x

CorniI’s picture

CorniI commented
Version: 5.x-1.2 »
Status: Closed (won't fix) » Active

As we dropped nearly all schemas for vc_git in #303680: Port to 6.x but I did no tests with psql, this may be still an issue (but I doubt it) so i'm re-opening till someone (me) gets around to install psql to test this.

marvil07’s picture

marvil07 commented
Version: » 6.x-1.2-alpha2
Status: Active » Fixed

:-D

I have just tried it with PostgreSQL and it works now!

thanks schema ;-)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.