Skip to content
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

Database error on clean installation #131

Closed
mrc0mmand opened this issue Feb 23, 2014 · 2 comments
Closed

Database error on clean installation #131

mrc0mmand opened this issue Feb 23, 2014 · 2 comments

Comments

@mrc0mmand
Copy link
Contributor

I decided to migrate from MySQL to PostgreSQL, but after clean installation and proper configuration I get following error:

A Database Error Occurred

Error Number:

ERROR: syntax error at or near "CHANGE" LINE 1: ALTER TABLE trending CHANGE COLUMN ip_address ip_address VAR... ^

ALTER TABLE trending CHANGE COLUMN ip_address ip_address VARCHAR(45) NOT NULL DEFAULT '0'

Filename: /var/www/stikked/controllers/main.php

Line Number: 263

I use PostgreSQL 9.3.2

@claudehohl
Copy link
Owner

Oh crap. Never tested it out with PostgreSQL. Maybe you can add support for it? :)

mrc0mmand pushed a commit to mrc0mmand/Stikked that referenced this issue Feb 25, 2014
@mrc0mmand
Copy link
Contributor Author

Sure. I've never opened pull request before, so I hope I haven't messed something up.

claudehohl added a commit that referenced this issue Feb 25, 2014
Fixed #131 - Added correct PostgreSQL queries
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants