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

Popular posts from this blog

ios - UICollectionView Self Sizing Cells with Auto Layout -

node.js - ldapjs - write after end error -

DOM Manipulation in Wordpress (and elsewhere) using php -