Page 1 of 1

OpenKM 6.2: relation "okm_wiki_page" does not exist

PostPosted:Fri Nov 02, 2012 1:27 pm
by xtingray
Hi everybody,

Last night I was trying a fresh installation of OpenKM 6.2. I configured PostgreSQL as back-end and everything went well until I got this message from the log (catalina.out):
Code: Select all
2012-11-02 07:59:59,495 [pool-2-thread-1] ERROR com.openkm.dao.HibernateUtil - Error during import script execution at line 151: [b]ERROR: relation "okm_wiki_page" does not exist[/b]
  Position: 13 [ INSERT INTO OKM_WIKI_PAGE (WKP_ID,WKP_CONTENT, WKP_DATE,WKP_TITLE,     WKP_USER, WKP_DELETED) VALUES (1, 'Main wiki page', NOW(), 'index', 'system', 'F') ]
2012-11-02 07:59:59,495 [pool-2-thread-1] ERROR com.openkm.dao.HibernateUtil - Error during import script execution at line 152: ERROR: current transaction is aborted, commands ignored until end of transaction block [ INSERT INTO OKM_FORUM (FRM_ID, FRM_NAME, FRM_DESCRIPTION, FRM_DATE, FRM_LAST_POST_USER, FRM_LAST_POST_DATE, FRM_NUM_TOPICS, FRM_NUM_POSTS, FRM_ACTIVE) VALUES (1, 'Documents discussions', 'Documents discussions general forum', NOW(), 'system', NOW(), 0, 0, 'T') ]
Although there are a lot of tables created in the database, it seems that the SQL loading process was unsuccessful. Any suggestion?

Thanks!

Re: OpenKM 6.2: relation "okm_wiki_page" does not exist

PostPosted:Fri Nov 02, 2012 2:08 pm
by xtingray
For the people interested in this issue, I made a simple "work-around" and it seems to be working well (no error messages in the logs).
I just created the 2 tables missing in the database and restarted the Tomcat (adding the option "hibernate.hbm2ddl=create" in the
OpenKM.cfg file).

These are the SQL instructions:
Code: Select all
CREATE TABLE okm_wiki_page (
    wkp_id integer NOT NULL,
    wkp_content text,
    wkp_date timestamp without time zone NOT NULL,
    wkp_title varchar(255) NOT NULL,
    wkp_user varchar(50) NOT NULL,
    wkp_deleted char(5) NOT NULL
);

CREATE TABLE okm_forum (
    frm_id integer NOT NULL,
    frm_name character varying(255) NOT NULL,
    frm_description text NOT NULL,
    frm_date timestamp without time zone NOT NULL,
    frm_last_post_user character varying(127) NOT NULL,
    frm_last_post_date timestamp without time zone NOT NULL,
    frm_num_topics integer NOT NULL,
    frm_num_posts integer NOT NULL,
    frm_active character(1) NOT NULL
);

Re: OpenKM 6.2: relation "okm_wiki_page" does not exist

PostPosted:Sun Nov 04, 2012 11:05 am
by jllort
It's a bug this sql sentence should not be there. More easy if you simply delete it. I think at nighly build ( integration.openkm.com ) is already solved.