Search Engine: Elastic

Article ID: 120498, created on Mar 11, 2014, last review on May 8, 2014

  • Applies to:
  • H-Sphere 3.6.1


Account can not be suspended. In the hsphere logs the following error is present:

Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not exist

Table easy_app has the following view:

hsphere=# select * from easy_app;
 sequence_name | last_value | increment_by |      max_value      | min_value | cache_value | log_cnt | is_cycled | is_called


Table easy_app has not been updated.


1) Log into H-sphere Database; 2) Delete affected table:

hsphere=# DROP SEQUENCE easy_app;

3) Recreate table anew:

hsphere=# CREATE TABLE easy_app (
hsphere(#     id integer NOT NULL,
hsphere(#     app_type integer NOT NULL,
hsphere(#     owner_id integer NOT NULL,
hsphere(#     "version" character varying(20),
hsphere(#     vhost character varying(25),
hsphere(#     "path" character varying(128),
hsphere(#     type_id integer
hsphere(# );

4) Check that the table has been created fine:

hsphere=# select * from easy_app;
 id | app_type | owner_id | version | vhost | path | type_id
(0 rows)

5) Restart PSQL and H-sphere services:

[root@cp~]# service postgresql restart
Stopping postgresql service:                               [  OK  ]
Starting postgresql service:                               [  OK  ]
[root@cp1 ~]# service httpdcp restart

1a2ef5d5f346a43e1324533020837760 6311ae17c1ee52b36e68aaf4ad066387 f213b9fa8759d57bee5d547445806fe7 2e39a5e5b1423cc126cf735bac076008

Email subscription for changes to this article
Save as PDF