java - PlayFramework - Error when deploying to Heroku (pgsql 'user' table) -
i have been writing application using play (great framework, can't fault it). however, i'm getting weird error when pushing app heroku.
2013-08-12t15:52:17.641129+00:00 app[web.1]: [←[31merror←[0m] play - error: synt ax error @ or near "user" 2013-08-12t15:52:17.744588+00:00 app[web.1]: position: 14 [error:0, sqlstate:4 2601]
that's seems going wrong. weird aspect of error fact don't have tables or references 'user' in sql-related code (evolutions, models , database). issue being cached?
thanks in advance, adil
edit
i seem have fixed error:
- i deleted evolution scripts, reason filled data didn't need (e.g sql scripts create 'user table')
- i updated references user table (even class names) 'appuser' (this changeable).
- i ran sql queries on pgsql database directly, creating tables manually.
- i disabled evolutions plugin , removed jdbc username , password when committing heroku.
postgresql has default "user" table. recommend naming table else member. conflict otherwise. caps might work, or tildes `user`, i'd recommend using different name table. wipe table in case there evolution backup.
Comments
Post a Comment